get a value from a json file that contains multiple json objects












-1















i am new to python and json I'm trying to get a specific value for each of the objects that are stored. i am trying to print all of the attributes stores under "NAME" and "OBJECTID" . how can i do this? i have been looking at different answers but I'm still confused. (EDIT: most of the objects in the whole file have different names, my objective is to create a list of all of the names.)
here is a small sample of the file i am using.
thank you for your help!



    {"type":"FeatureCollection", "features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":{"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}









share|improve this question

























  • do you mind posting only the json that's relevant or a smaller sample of your json rather than the entire file? it's hard to understand. thanks :)

    – Yang K
    Nov 16 '18 at 3:57











  • It's unclear what you mean by "the attributes stores under 'NAME'". The json data does have some keys such as "NAME":"0001", but I don't know how this relates to the question, if at all.

    – John Gordon
    Nov 16 '18 at 4:04











  • sorry, i didn't explain myself. this .json file contains a list of precincts (each line contains a precinct) each of the precinct has a "NAME" key and all i want to do is to print 0001, and so on for all of the "names" of each of the objects. i hope that clears things up

    – tony
    Nov 16 '18 at 4:10











  • @YangK sorry about that i deleted most of the filed i didn't need i hope that makes things more clear :) thank you for your help!

    – tony
    Nov 16 '18 at 4:14
















-1















i am new to python and json I'm trying to get a specific value for each of the objects that are stored. i am trying to print all of the attributes stores under "NAME" and "OBJECTID" . how can i do this? i have been looking at different answers but I'm still confused. (EDIT: most of the objects in the whole file have different names, my objective is to create a list of all of the names.)
here is a small sample of the file i am using.
thank you for your help!



    {"type":"FeatureCollection", "features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":{"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}









share|improve this question

























  • do you mind posting only the json that's relevant or a smaller sample of your json rather than the entire file? it's hard to understand. thanks :)

    – Yang K
    Nov 16 '18 at 3:57











  • It's unclear what you mean by "the attributes stores under 'NAME'". The json data does have some keys such as "NAME":"0001", but I don't know how this relates to the question, if at all.

    – John Gordon
    Nov 16 '18 at 4:04











  • sorry, i didn't explain myself. this .json file contains a list of precincts (each line contains a precinct) each of the precinct has a "NAME" key and all i want to do is to print 0001, and so on for all of the "names" of each of the objects. i hope that clears things up

    – tony
    Nov 16 '18 at 4:10











  • @YangK sorry about that i deleted most of the filed i didn't need i hope that makes things more clear :) thank you for your help!

    – tony
    Nov 16 '18 at 4:14














-1












-1








-1








i am new to python and json I'm trying to get a specific value for each of the objects that are stored. i am trying to print all of the attributes stores under "NAME" and "OBJECTID" . how can i do this? i have been looking at different answers but I'm still confused. (EDIT: most of the objects in the whole file have different names, my objective is to create a list of all of the names.)
here is a small sample of the file i am using.
thank you for your help!



    {"type":"FeatureCollection", "features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":{"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}









share|improve this question
















i am new to python and json I'm trying to get a specific value for each of the objects that are stored. i am trying to print all of the attributes stores under "NAME" and "OBJECTID" . how can i do this? i have been looking at different answers but I'm still confused. (EDIT: most of the objects in the whole file have different names, my objective is to create a list of all of the names.)
here is a small sample of the file i am using.
thank you for your help!



    {"type":"FeatureCollection", "features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":{"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}






python json geojson






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 16 '18 at 4:19







tony

















asked Nov 16 '18 at 3:54









tonytony

14




14













  • do you mind posting only the json that's relevant or a smaller sample of your json rather than the entire file? it's hard to understand. thanks :)

    – Yang K
    Nov 16 '18 at 3:57











  • It's unclear what you mean by "the attributes stores under 'NAME'". The json data does have some keys such as "NAME":"0001", but I don't know how this relates to the question, if at all.

    – John Gordon
    Nov 16 '18 at 4:04











  • sorry, i didn't explain myself. this .json file contains a list of precincts (each line contains a precinct) each of the precinct has a "NAME" key and all i want to do is to print 0001, and so on for all of the "names" of each of the objects. i hope that clears things up

    – tony
    Nov 16 '18 at 4:10











  • @YangK sorry about that i deleted most of the filed i didn't need i hope that makes things more clear :) thank you for your help!

    – tony
    Nov 16 '18 at 4:14



















  • do you mind posting only the json that's relevant or a smaller sample of your json rather than the entire file? it's hard to understand. thanks :)

    – Yang K
    Nov 16 '18 at 3:57











  • It's unclear what you mean by "the attributes stores under 'NAME'". The json data does have some keys such as "NAME":"0001", but I don't know how this relates to the question, if at all.

    – John Gordon
    Nov 16 '18 at 4:04











  • sorry, i didn't explain myself. this .json file contains a list of precincts (each line contains a precinct) each of the precinct has a "NAME" key and all i want to do is to print 0001, and so on for all of the "names" of each of the objects. i hope that clears things up

    – tony
    Nov 16 '18 at 4:10











  • @YangK sorry about that i deleted most of the filed i didn't need i hope that makes things more clear :) thank you for your help!

    – tony
    Nov 16 '18 at 4:14

















do you mind posting only the json that's relevant or a smaller sample of your json rather than the entire file? it's hard to understand. thanks :)

– Yang K
Nov 16 '18 at 3:57





do you mind posting only the json that's relevant or a smaller sample of your json rather than the entire file? it's hard to understand. thanks :)

– Yang K
Nov 16 '18 at 3:57













It's unclear what you mean by "the attributes stores under 'NAME'". The json data does have some keys such as "NAME":"0001", but I don't know how this relates to the question, if at all.

– John Gordon
Nov 16 '18 at 4:04





It's unclear what you mean by "the attributes stores under 'NAME'". The json data does have some keys such as "NAME":"0001", but I don't know how this relates to the question, if at all.

– John Gordon
Nov 16 '18 at 4:04













sorry, i didn't explain myself. this .json file contains a list of precincts (each line contains a precinct) each of the precinct has a "NAME" key and all i want to do is to print 0001, and so on for all of the "names" of each of the objects. i hope that clears things up

– tony
Nov 16 '18 at 4:10





sorry, i didn't explain myself. this .json file contains a list of precincts (each line contains a precinct) each of the precinct has a "NAME" key and all i want to do is to print 0001, and so on for all of the "names" of each of the objects. i hope that clears things up

– tony
Nov 16 '18 at 4:10













@YangK sorry about that i deleted most of the filed i didn't need i hope that makes things more clear :) thank you for your help!

– tony
Nov 16 '18 at 4:14





@YangK sorry about that i deleted most of the filed i didn't need i hope that makes things more clear :) thank you for your help!

– tony
Nov 16 '18 at 4:14












1 Answer
1






active

oldest

votes


















0














Assuming your json is like



json = {"type": "FeatureCollection", 
"features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}


You can get a list of tuples with OBJECTID, NAME using a list comprehension like this:



oid_name = [(feature['properties']['OBJECTID'], feature['properties']['NAME']) for feature in json['features']]


which will evaluate to



[(1, '0001'), (2, '0001'), (6278, '0001')]


in this example.



If your need is to look up the name for an object, you might find it more useful to use a dictionary for this:



names = {feature['properties']['OBJECTID']: feature['properties']['NAME'] for feature in json['features']}


This will allow you to look up the name like this:



>>> names[1]
'0001'





share|improve this answer
























  • thank you! that is what i was looking for :)

    – tony
    Nov 16 '18 at 4:41












Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53331198%2fget-a-value-from-a-json-file-that-contains-multiple-json-objects%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














Assuming your json is like



json = {"type": "FeatureCollection", 
"features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}


You can get a list of tuples with OBJECTID, NAME using a list comprehension like this:



oid_name = [(feature['properties']['OBJECTID'], feature['properties']['NAME']) for feature in json['features']]


which will evaluate to



[(1, '0001'), (2, '0001'), (6278, '0001')]


in this example.



If your need is to look up the name for an object, you might find it more useful to use a dictionary for this:



names = {feature['properties']['OBJECTID']: feature['properties']['NAME'] for feature in json['features']}


This will allow you to look up the name like this:



>>> names[1]
'0001'





share|improve this answer
























  • thank you! that is what i was looking for :)

    – tony
    Nov 16 '18 at 4:41
















0














Assuming your json is like



json = {"type": "FeatureCollection", 
"features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}


You can get a list of tuples with OBJECTID, NAME using a list comprehension like this:



oid_name = [(feature['properties']['OBJECTID'], feature['properties']['NAME']) for feature in json['features']]


which will evaluate to



[(1, '0001'), (2, '0001'), (6278, '0001')]


in this example.



If your need is to look up the name for an object, you might find it more useful to use a dictionary for this:



names = {feature['properties']['OBJECTID']: feature['properties']['NAME'] for feature in json['features']}


This will allow you to look up the name like this:



>>> names[1]
'0001'





share|improve this answer
























  • thank you! that is what i was looking for :)

    – tony
    Nov 16 '18 at 4:41














0












0








0







Assuming your json is like



json = {"type": "FeatureCollection", 
"features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}


You can get a list of tuples with OBJECTID, NAME using a list comprehension like this:



oid_name = [(feature['properties']['OBJECTID'], feature['properties']['NAME']) for feature in json['features']]


which will evaluate to



[(1, '0001'), (2, '0001'), (6278, '0001')]


in this example.



If your need is to look up the name for an object, you might find it more useful to use a dictionary for this:



names = {feature['properties']['OBJECTID']: feature['properties']['NAME'] for feature in json['features']}


This will allow you to look up the name like this:



>>> names[1]
'0001'





share|improve this answer













Assuming your json is like



json = {"type": "FeatureCollection", 
"features": [
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[552346.2856999999,380222.8998000007]]]},"properties":{"OBJECTID":1,"STFID":"55001442500001","NAME":"0001"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[529754.7249999996,409135.9135999996],[529740.0305000003,408420.03810000047]]]},"properties":{"OBJECTID":2,"STFID":"55001537250001","NAME":"0001","COUSUBFP":"53725"}},
{"type":"Feature","geometry":{"type":"Polygon","coordinates":[[[508795.9363000002,441655.3672000002],[508813.49899999984,441181.034]]]},"properties":"OBJECTID":6278,"STFID":"55141885750001","NAME":"0001","COUSUBFP":"88575"}}
]}


You can get a list of tuples with OBJECTID, NAME using a list comprehension like this:



oid_name = [(feature['properties']['OBJECTID'], feature['properties']['NAME']) for feature in json['features']]


which will evaluate to



[(1, '0001'), (2, '0001'), (6278, '0001')]


in this example.



If your need is to look up the name for an object, you might find it more useful to use a dictionary for this:



names = {feature['properties']['OBJECTID']: feature['properties']['NAME'] for feature in json['features']}


This will allow you to look up the name like this:



>>> names[1]
'0001'






share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 16 '18 at 4:19









chthonicdaemonchthonicdaemon

12.6k3147




12.6k3147













  • thank you! that is what i was looking for :)

    – tony
    Nov 16 '18 at 4:41



















  • thank you! that is what i was looking for :)

    – tony
    Nov 16 '18 at 4:41

















thank you! that is what i was looking for :)

– tony
Nov 16 '18 at 4:41





thank you! that is what i was looking for :)

– tony
Nov 16 '18 at 4:41




















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53331198%2fget-a-value-from-a-json-file-that-contains-multiple-json-objects%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Florida Star v. B. J. F.

Danny Elfman

Retrieve a Users Dashboard in Tumblr with R and TumblR. Oauth Issues