Using NumPyArrayToFeatureClass without JSON Key/Values

GeoffreyWest — Sat, 11 Dec 2021 08:57:44 GMT

I have a JSON web-service that I would like to parse data from and write to a feature class. I have a proof of concept script for a more robust and user friendly API. Taking most pieces from this script, I would like to use in the same way, however, due to the structure of the JSON I am having difficulty grabbing the key/value pairs. Here is the original script which Joshua Bixby has offered great assistance with.

My print decoded.items and .keys function in the 2nd script returns identical outputs. I would like to be able to successfully parse out key/values in the output to write to a feature class, i.e. lat/lng, address, name SR type, etc.

Are there ever instances when JSON files do not have key/value pairs?? And if so, what is an elegant solution to handle this?

import arcpy
import json
import numpy
import requests


fc = "C:\MYLATesting.gdb\MYLA311"
if arcpy.Exists(fc):
  arcpy.Delete_management(fc)


url = "http://api.metro.net/agencies/lametro/vehicles/"

r = requests.get(url)

parsed_json = r.json()
sr = arcpy.SpatialReference(4326)  #assuming wgs84 coords but didn't verify


r.json()


ndtype = numpy.dtype([
  ('id', 'S12'),
   ('route_id', 'S12'),
   ('latitude', 'f8'),
   ('longitude', 'f8'),
   ('heading', 'f8'),
   ('seconds_since_report', 'i4'),
   ('predictable', '?')
])

vehicles = []
for item in parsed_json['items']:
  vehicles.append(tuple(item for k in ndtype.names))

narr = numpy.array([vehicles],  ndtype)
arcpy.da.NumPyArrayToFeatureClass(narr, fc, ['longitude', 'latitude'], sr)

Here is the script that I am having difficulties with.

import jsonpickle
import arcpy
import json
import numpy
import requests


fc = "C:\MYLATesting.gdb\MYLA311"
if arcpy.Exists(fc):
  arcpy.Delete_management(fc)

f = open('C:\Users\Administrator\Desktop\myla311.json', 'r')

data = jsonpickle.encode( jsonpickle.decode(f.read()) )

url = "https://myla311test.lacity.org/myla311router/mylasrbe/1/QuerySR"
headers = {'Content-type': 'text/plain', 'Accept': '/'}

r = requests.post(url, data=data, headers=headers)
sr = arcpy.SpatialReference(4326)


decoded = json.loads(r.text)

print json.dumps(decoded, sort_keys=True, indent=4)

print decoded
print decoded.keys()
print decoded.items()




f.close()

Input JSON

{

"RequestSpecificDetail": {

"ParentSRNumberForLink": ""

"MetaData": {

"appVersion": "1.34",

"deviceModel": "x86_64",

"dateAndTime": "01/15/2015 12:46:36",

"deviceToken": "A2C1DD9D-D17D-4031-BA3E-977C250BFD58",

"osVersion": "8.1"

"SRData": {

"SRNumber": "1-1080871"

}

Output

{

"Response": {

"ListOfServiceRequest": {

"ServiceRequest": [

{

"ActionTaken": "",

"AddressVerified": "Y",

"Anonymous": "N",

"AssignTo": "North Central - 104 - IED",

"Assignee": "Siebel Administrator",

"CreatedByUserLogin": "PRASAD89",

"CreatedDate": "12/31/2014 13:49:23",

"CustomerAccessNumber": "",

"Email": "prasadpotale@gmail.com",

"FirstName": "Prasad",

"HomePhone": "3123123123",

"IntegrationId": "1420033765921",

"LADWPAccountNo": "",

"Language": "English",

"LastName": "Pp",

"Latitude": "34.064937",

"ListOfAuditTrailItem2": {},

"ListOfChildServiceRequest": {},

"ListOfLa311BarricadeRemoval": {},

"ListOfLa311BeesOrBeehive": {},

"ListOfLa311BillingCsscAdjustment": {},

"ListOfLa311BillingEccAdjustment": {},

"ListOfLa311BillingRsscAdjustment": {},

"ListOfLa311BillingRsscExemption": {},

"ListOfLa311BrushItemsPickup": {},

"ListOfLa311BulkyItem": {},

"ListOfLa311BusPadLanding": {},

"ListOfLa311Containers": {},

"ListOfLa311CurbRepair": {},

"ListOfLa311DeadAnimalRemoval": {},

"ListOfLa311DocumentLog": {},

"ListOfLa311ElectronicWaste": {},

"ListOfLa311Flooding": {},

"ListOfLa311GeneralStreetInspection": {},

"ListOfLa311GenericBc": {

"La311GenericBc": [

{

"ATTRIB_08": "",

"ListOfLa311GenericbcAuditTrail": {},

"NAME": "41572025-3803-49c4-8561-6e7ef41775df",

"PAR_ROW_ID": "1-N607",

"ROW_ID": "1-N60A",

"TYPE": "GIS"

{

"ATTRIB_08": "",

"ListOfLa311GenericbcAuditTrail": {},

"NAME": "a5b5b2b9-d2e7-400a-bf75-1138ff013caa",

"PAR_ROW_ID": "1-N607",

"ROW_ID": "1-N609",

"TYPE": "Homeless Encampment"

{

"ATTRIB_08": "",

"ListOfLa311GenericbcAuditTrail": {},

"NAME": "010420150405",

"PAR_ROW_ID": "1-N607",

"ROW_ID": "1-RN2D",

"TYPE": "Subscription"

}

]

"ListOfLa311GisLayer": {

"La311GisLayer": [

{

"A_Call_No": "",

"Area": "",

"BOSRadioHolderName": "",

"CommunityPlanningArea": "Westlake",

"Day": "",

"DirectionSuffix": "",

"DistrictAbbr": "",

"DistrictName": "Central",

"DistrictNumber": "104",

"DistrictOffice": "North Central",

"Fraction": "",

"LastUpdatedBy": "",

"Name": "41572025-3803-49c4-8561-6e7ef41775df",

"R_Call_No": "",

"SectionId": "5279800",

"ShortDay": "",

"StreetFrom": "BOYLSTON ST",

"StreetLightId": "",

"StreetLightStatus": "",

"StreetTo": "FIRMIN ST",

"Type": "GIS",

"Y_Call_No": ""

}

]

"ListOfLa311GraffitiRemoval": {},

"ListOfLa311GuardWarningRailMaintenance": {},

"ListOfLa311GutterRepair": {},

"ListOfLa311HomelessEncampment": {

"La311HomelessEncampment": [

{

"ApprovedBy": "",

"AssignedTo": "",

"CompletedBy": "",

"Contact": "",

"ContactDate": "",

"Crew": "",

"DateCompleted": "12/31/2014 00:00:00",

"InspectedBy": "",

"InspectionDate": "",

"LastUpdatedBy": "",

"Location": "Alley",

"Name": "a5b5b2b9-d2e7-400a-bf75-1138ff013caa",

"OptionalTrackingCode": "",

"Type": "Homeless Encampment"

}

]

"ListOfLa311IllegalAutoRepair": {},

"ListOfLa311IllegalConstruction": {},

"ListOfLa311IllegalConstructionFence": {},

"ListOfLa311IllegalDischargeOfWater": {},

"ListOfLa311IllegalDumpingInProgress": {},

"ListOfLa311IllegalDumpingPickup": {},

"ListOfLa311IllegalExcavation": {},

"ListOfLa311IllegalSignRemoval": {},

"ListOfLa311IllegalVending": {},

"ListOfLa311InformationOnly": {},

"ListOfLa311LandMudSlide": {},

"ListOfLa311LeafBlowerViolation": {},

"ListOfLa311ManualPickup": {},

"ListOfLa311MedianIslandMaintenance": {},

"ListOfLa311MetalHouseholdAppliancesPickup": {},

"ListOfLa311MoveInMoveOut": {},

"ListOfLa311MultipleStreetlightIssue": {},

"ListOfLa311NewsRackViolation": {},

"ListOfLa311Obstructions": {},

"ListOfLa311Other": {},

"ListOfLa311OvergrownVegetationPlants": {},

"ListOfLa311PalmFrondsDown": {},

"ListOfLa311Pothole": {},

"ListOfLa311Resurfacing": {},

"ListOfLa311SanitationBillingBif": {},

"ListOfLa311SanitationBillingCssc": {},

"ListOfLa311SanitationBillingEcc": {},

"ListOfLa311SanitationBillingInquiry": {},

"ListOfLa311SanitationBillingLifeline": {},

"ListOfLa311SanitationBillingRssc": {},

"ListOfLa311SanitationBillingSrf": {},

"ListOfLa311ServiceNotComplete": {},

"ListOfLa311ServiceRequestNotes": {

"La311ServiceRequestNotes": [

{

"Comment": "",

"CommentType": "External",

"CreatedByUser": "PRASAD89",

"CreatedDate": "12/31/2014 13:49:23",

"Date1": "",

"Date2": "",

"Date3": "",

"FeedbackSRType": "",

"IntegrationId": "1420033765921",

"IsSrNoAvailable": "N",

"ListOfLa311SrNotesAuditTrail": {},

"Notification": "N",

"Text1": ""

}

]

"ListOfLa311SidewalkRepair": {},

"ListOfLa311SingleStreetlightIssue": {},

"ListOfLa311SrPhotoId": {

"La311SrPhotoId": []

"ListOfLa311StreetSweeping": {},

"ListOfLa311StreetTreeInspection": {},

"ListOfLa311StreetTreeViolations": {},

"ListOfLa311SubscribeDuplicateSr": {

"La311SubscribeDuplicateSr": [

{

"Activeflag": "Y",

"EmailId": "pratik.desai@yoopmail.com",

"LastUpdatedBy": "",

"Name": "010420150405",

"Type": "Subscription"

}

]

"ListOfLa311TablesAndChairsObstructing": {},

"ListOfLa311TreeEmergency": {},

"ListOfLa311TreeObstruction": {},

"ListOfLa311TreePermits": {},

"ListOfLa311WeedAbatementForPrivateParcels": {},

"LoginUser": "",

"Longitude": "-118.252968",

"MobilOS": "iOS",

"NewContactEmail": "",

"NewContactFirstName": "",

"NewContactLastName": "",

"NewContactPhone": "",

"Owner": "BSS",

"ParentSRLinkDate": "",

"ParentSRLinkUser": "",

"ParentSRNumber": "",

"ParentSRStatus": "",

"ParentSRType": "",

"Priority": "Normal",

"ReasonCode": "",

"RescheduleCounter": "",

"ResolutionCode": "",

"SRAddress": "1200 W TEMPLE ST, 90026",

"SRAddressName": "",

"SRAreaPlanningCommission": "Central APC",

"SRAreaPlanningCommissionId": "4",

"SRCity": "",

"SRCommunityPoliceStation": "",

"SRCommunityPoliceStationAPREC": "RAMPART",

"SRCommunityPoliceStationPREC": "2",

"SRCouncilDistrictMember": "Gilbert Cedillo",

"SRCouncilDistrictNo": "1",

"SRCrossStreet": "",

"SRDirection": "W",

"SRHouseNumber": "",

"SRNeighborhoodCouncilId": "44",

"SRNeighborhoodCouncilName": "GREATER ECHO PARK ELYSIAN NC",

"SRNumber": "1-1080871",

"SRStreetName": "TEMPLE",

"SRSuffix": "ST",

"SRTBColumn": "E",

"SRTBMapGridPage": "634",

"SRTBRow": "2",

"SRType": "Homeless Encampment",

"SRUnitNumber": "",

"SRXCoordinate": "6485064",

"SRYCoordinate": "1846114",

"ServiceDate": "12/31/2014 00:00:00",

"Source": "311",

"Status": "Open",

"UpdatedByUserLogin": "PRASAD89",

"UpdatedDate": "12/31/2014 13:49:23",

"Zipcode": "90026"

}

]

"NumOutputObjects": "1"

"status": {

"cause": "",

"code": 311,

"message": "Service Request Successfully Queried."

}

{u'status': {u'message': u'Service Request Successfully Queried.', u'code': 311, u'cause': u''}, u'Response': {u'NumOutputObjects': u'1', u'ListOfServiceRequest': {u'ServiceRequest': [{u'ListOfLa311StreetSweeping': {}, u'SRCouncilDistrictMember': u'Gilbert Cedillo', u'ListOfLa311IllegalConstructionFence': {}, u'UpdatedDate': u'12/31/2014 13:49:23', u'ListOfLa311ServiceNotComplete': {}, u'ListOfChildServiceRequest': {}, u'ListOfLa311ElectronicWaste': {}, u'SRAddress': u'1200 W TEMPLE ST, 90026', u'ListOfLa311MetalHouseholdAppliancesPickup': {}, u'ListOfLa311SubscribeDuplicateSr': {u'La311SubscribeDuplicateSr': [{u'EmailId': u'pratik.desai@yoopmail.com', u'LastUpdatedBy': u'', u'Type': u'Subscription', u'Name': u'010420150405', u'Activeflag': u'Y'}]}, u'ListOfLa311IllegalSignRemoval': {}, u'CustomerAccessNumber': u'', u'ListOfLa311IllegalDumpingInProgress': {}, u'Anonymous': u'N', u'SRDirection': u'W', u'ListOfLa311NewsRackViolation': {}, u'SRXCoordinate': u'6485064', u'ListOfLa311GenericBc': {u'La311GenericBc': [{u'ATTRIB_08': u'', u'NAME': u'41572025-3803-49c4-8561-6e7ef41775df', u'PAR_ROW_ID': u'1-N607', u'ROW_ID': u'1-N60A', u'TYPE': u'GIS', u'ListOfLa311GenericbcAuditTrail': {}}, {u'ATTRIB_08': u'', u'NAME': u'a5b5b2b9-d2e7-400a-bf75-1138ff013caa', u'PAR_ROW_ID': u'1-N607', u'ROW_ID': u'1-N609', u'TYPE': u'Homeless Encampment', u'ListOfLa311GenericbcAuditTrail': {}}, {u'ATTRIB_08': u'', u'NAME': u'010420150405', u'PAR_ROW_ID': u'1-N607', u'ROW_ID': u'1-RN2D', u'TYPE': u'Subscription', u'ListOfLa311GenericbcAuditTrail': {}}]}, u'ListOfLa311TreePermits': {}, u'Longitude': u'-118.252968', u'ListOfLa311SanitationBillingCssc': {}, u'ListOfLa311SanitationBillingSrf': {}, u'ListOfLa311HomelessEncampment': {u'La311HomelessEncampment': [{u'DateCompleted': u'12/31/2014 00:00:00', u'ContactDate': u'', u'ApprovedBy': u'', u'Name': u'a5b5b2b9-d2e7-400a-bf75-1138ff013caa', u'Contact': u'', u'LastUpdatedBy': u'', u'InspectionDate': u'', u'Crew': u'', u'AssignedTo': u'', u'CompletedBy': u'', u'Location': u'Alley', u'InspectedBy': u'', u'OptionalTrackingCode': u'', u'Type': u'Homeless Encampment'}]}, u'ListOfLa311ServiceRequestNotes': {u'La311ServiceRequestNotes': [{u'Comment': u'', u'FeedbackSRType': u'', u'Date3': u'', u'Date2': u'', u'Notification': u'N', u'Date1': u'', u'Text1': u'', u'IntegrationId': u'1420033765921', u'CreatedByUser': u'PRASAD89', u'CommentType': u'External', u'ListOfLa311SrNotesAuditTrail': {}, u'CreatedDate': u'12/31/2014 13:49:23', u'IsSrNoAvailable': u'N'}]}, u'ListOfLa311SingleStreetlightIssue': {}, u'SRYCoordinate': u'1846114', u'ListOfLa311Pothole': {}, u'ParentSRLinkDate': u'', u'ListOfLa311TreeEmergency': {}, u'ListOfLa311GeneralStreetInspection': {}, u'ListOfLa311MedianIslandMaintenance': {}, u'ListOfLa311StreetTreeInspection': {}, u'SRNumber': u'1-1080871', u'ListOfLa311InformationOnly': {}, u'ListOfLa311ManualPickup': {}, u'ListOfLa311Obstructions': {}, u'SRSuffix': u'ST', u'Zipcode': u'90026', u'Priority': u'Normal', u'Source': u'311', u'SRCity': u'', u'Latitude': u'34.064937', u'SRNeighborhoodCouncilName': u'GREATER ECHO PARK ELYSIAN NC', u'Email': u'prasadpotale@gmail.com', u'RescheduleCounter': u'', u'AssignTo': u'North Central - 104 - IED', u'ListOfLa311Resurfacing': {}, u'SRCommunityPoliceStation': u'', u'ListOfLa311GuardWarningRailMaintenance': {}, u'SRAreaPlanningCommissionId': u'4', u'ListOfLa311BusPadLanding': {}, u'ListOfLa311SanitationBillingInquiry': {}, u'SRTBMapGridPage': u'634', u'ListOfLa311SanitationBillingBif': {}, u'AddressVerified': u'Y', u'MobilOS': u'iOS', u'ParentSRLinkUser': u'', u'SRAddressName': u'', u'ListOfLa311Other': {}, u'ListOfLa311SanitationBillingLifeline': {}, u'SRUnitNumber': u'', u'UpdatedByUserLogin': u'PRASAD89', u'ListOfLa311SanitationBillingRssc': {}, u'SRHouseNumber': u'', u'ListOfLa311IllegalAutoRepair': {}, u'CreatedDate': u'12/31/2014 13:49:23', u'Owner': u'BSS', u'SRCrossStreet': u'', u'FirstName': u'Prasad', u'CreatedByUserLogin': u'PRASAD89', u'LastName': u'Pp', u'SRCouncilDistrictNo': u'1', u'ListOfLa311DocumentLog': {}, u'SRTBColumn': u'E', u'Status': u'Open', u'SRCommunityPoliceStationPREC': u'2', u'ListOfLa311IllegalConstruction': {}, u'ListOfLa311BarricadeRemoval': {}, u'ParentSRStatus': u'', u'NewContactEmail': u'', u'ListOfLa311SanitationBillingEcc': {}, u'ListOfLa311StreetTreeViolations': {}, u'Language': u'English', u'ListOfLa311DeadAnimalRemoval': {}, u'ListOfLa311PalmFrondsDown': {}, u'ListOfLa311IllegalExcavation': {}, u'ServiceDate': u'12/31/2014 00:00:00', u'LoginUser': u'', u'ParentSRNumber': u'', u'SRAreaPlanningCommission': u'Central APC', u'ListOfLa311IllegalDumpingPickup': {}, u'ListOfLa311SidewalkRepair': {}, u'LADWPAccountNo': u'', u'ListOfLa311BillingCsscAdjustment': {}, u'ListOfAuditTrailItem2': {}, u'ListOfLa311IllegalDischargeOfWater': {}, u'SRCommunityPoliceStationAPREC': u'RAMPART', u'ParentSRType': u'', u'Assignee': u'Siebel Administrator', u'ListOfLa311Containers': {}, u'ListOfLa311BeesOrBeehive': {}, u'ListOfLa311BulkyItem': {}, u'SRType': u'Homeless Encampment', u'SRStreetName': u'TEMPLE', u'ListOfLa311WeedAbatementForPrivateParcels': {}, u'ResolutionCode': u'', u'ListOfLa311GraffitiRemoval': {}, u'ListOfLa311Flooding': {}, u'ListOfLa311IllegalVending': {}, u'ListOfLa311TablesAndChairsObstructing': {}, u'ListOfLa311MoveInMoveOut': {}, u'ListOfLa311BillingEccAdjustment': {}, u'ListOfLa311OvergrownVegetationPlants': {}, u'NewContactFirstName': u'', u'ListOfLa311BrushItemsPickup': {}, u'IntegrationId': u'1420033765921', u'ReasonCode': u'', u'ListOfLa311CurbRepair': {}, u'ListOfLa311LeafBlowerViolation': {}, u'ListOfLa311MultipleStreetlightIssue': {}, u'ListOfLa311TreeObstruction': {}, u'ActionTaken': u'', u'ListOfLa311BillingRsscAdjustment': {}, u'ListOfLa311GisLayer': {u'La311GisLayer': [{u'DistrictOffice': u'North Central', u'Area': u'', u'Y_Call_No': u'', u'Fraction': u'', u'StreetLightId': u'', u'Type': u'GIS', u'DistrictAbbr': u'', u'R_Call_No': u'', u'CommunityPlanningArea': u'Westlake', u'LastUpdatedBy': u'', u'DistrictName': u'Central', u'BOSRadioHolderName': u'', u'A_Call_No': u'', u'Day': u'', u'DistrictNumber': u'104', u'Name': u'41572025-3803-49c4-8561-6e7ef41775df', u'StreetTo': u'FIRMIN ST', u'StreetLightStatus': u'', u'DirectionSuffix': u'', u'ShortDay': u'', u'SectionId': u'5279800', u'StreetFrom': u'BOYLSTON ST'}]}, u'ListOfLa311SrPhotoId': {u'La311SrPhotoId': []}, u'ListOfLa311LandMudSlide': {}, u'SRNeighborhoodCouncilId': u'44', u'ListOfLa311BillingRsscExemption': {}, u'SRTBRow': u'2', u'NewContactLastName': u'', u'NewContactPhone': u'', u'ListOfLa311GutterRepair': {}, u'HomePhone': u'3123123123'}]}}}

[u'status', u'Response']

[(u'status', {u'message': u'Service Request Successfully Queried.', u'code': 311, u'cause': u''}), (u'Response', {u'NumOutputObjects': u'1', u'ListOfServiceRequest': {u'ServiceRequest': [{u'ListOfLa311StreetSweeping': {}, u'SRCouncilDistrictMember': u'Gilbert Cedillo', u'ListOfLa311IllegalConstructionFence': {}, u'UpdatedDate': u'12/31/2014 13:49:23', u'ListOfLa311ServiceNotComplete': {}, u'ListOfChildServiceRequest': {}, u'ListOfLa311ElectronicWaste': {}, u'SRAddress': u'1200 W TEMPLE ST, 90026', u'ListOfLa311MetalHouseholdAppliancesPickup': {}, u'ListOfLa311SubscribeDuplicateSr': {u'La311SubscribeDuplicateSr': [{u'EmailId': u'pratik.desai@yoopmail.com', u'LastUpdatedBy': u'', u'Type': u'Subscription', u'Name': u'010420150405', u'Activeflag': u'Y'}]}, u'ListOfLa311IllegalSignRemoval': {}, u'CustomerAccessNumber': u'', u'ListOfLa311IllegalDumpingInProgress': {}, u'Anonymous': u'N', u'SRDirection': u'W', u'ListOfLa311NewsRackViolation': {}, u'SRXCoordinate': u'6485064', u'ListOfLa311GenericBc': {u'La311GenericBc': [{u'ATTRIB_08': u'', u'NAME': u'41572025-3803-49c4-8561-6e7ef41775df', u'PAR_ROW_ID': u'1-N607', u'ROW_ID': u'1-N60A', u'TYPE': u'GIS', u'ListOfLa311GenericbcAuditTrail': {}}, {u'ATTRIB_08': u'', u'NAME': u'a5b5b2b9-d2e7-400a-bf75-1138ff013caa', u'PAR_ROW_ID': u'1-N607', u'ROW_ID': u'1-N609', u'TYPE': u'Homeless Encampment', u'ListOfLa311GenericbcAuditTrail': {}}, {u'ATTRIB_08': u'', u'NAME': u'010420150405', u'PAR_ROW_ID': u'1-N607', u'ROW_ID': u'1-RN2D', u'TYPE': u'Subscription', u'ListOfLa311GenericbcAuditTrail': {}}]}, u'ListOfLa311TreePermits': {}, u'Longitude': u'-118.252968', u'ListOfLa311SanitationBillingCssc': {}, u'ListOfLa311SanitationBillingSrf': {}, u'ListOfLa311HomelessEncampment': {u'La311HomelessEncampment': [{u'DateCompleted': u'12/31/2014 00:00:00', u'ContactDate': u'', u'ApprovedBy': u'', u'Name': u'a5b5b2b9-d2e7-400a-bf75-1138ff013caa', u'Contact': u'', u'LastUpdatedBy': u'', u'InspectionDate': u'', u'Crew': u'', u'AssignedTo': u'', u'CompletedBy': u'', u'Location': u'Alley', u'InspectedBy': u'', u'OptionalTrackingCode': u'', u'Type': u'Homeless Encampment'}]}, u'ListOfLa311ServiceRequestNotes': {u'La311ServiceRequestNotes': [{u'Comment': u'', u'FeedbackSRType': u'', u'Date3': u'', u'Date2': u'', u'Notification': u'N', u'Date1': u'', u'Text1': u'', u'IntegrationId': u'1420033765921', u'CreatedByUser': u'PRASAD89', u'CommentType': u'External', u'ListOfLa311SrNotesAuditTrail': {}, u'CreatedDate': u'12/31/2014 13:49:23', u'IsSrNoAvailable': u'N'}]}, u'ListOfLa311SingleStreetlightIssue': {}, u'SRYCoordinate': u'1846114', u'ListOfLa311Pothole': {}, u'ParentSRLinkDate': u'', u'ListOfLa311TreeEmergency': {}, u'ListOfLa311GeneralStreetInspection': {}, u'ListOfLa311MedianIslandMaintenance': {}, u'ListOfLa311StreetTreeInspection': {}, u'SRNumber': u'1-1080871', u'ListOfLa311InformationOnly': {}, u'ListOfLa311ManualPickup': {}, u'ListOfLa311Obstructions': {}, u'SRSuffix': u'ST', u'Zipcode': u'90026', u'Priority': u'Normal', u'Source': u'311', u'SRCity': u'', u'Latitude': u'34.064937', u'SRNeighborhoodCouncilName': u'GREATER ECHO PARK ELYSIAN NC', u'Email': u'prasadpotale@gmail.com', u'RescheduleCounter': u'', u'AssignTo': u'North Central - 104 - IED', u'ListOfLa311Resurfacing': {}, u'SRCommunityPoliceStation': u'', u'ListOfLa311GuardWarningRailMaintenance': {}, u'SRAreaPlanningCommissionId': u'4', u'ListOfLa311BusPadLanding': {}, u'ListOfLa311SanitationBillingInquiry': {}, u'SRTBMapGridPage': u'634', u'ListOfLa311SanitationBillingBif': {}, u'AddressVerified': u'Y', u'MobilOS': u'iOS', u'ParentSRLinkUser': u'', u'SRAddressName': u'', u'ListOfLa311Other': {}, u'ListOfLa311SanitationBillingLifeline': {}, u'SRUnitNumber': u'', u'UpdatedByUserLogin': u'PRASAD89', u'ListOfLa311SanitationBillingRssc': {}, u'SRHouseNumber': u'', u'ListOfLa311IllegalAutoRepair': {}, u'CreatedDate': u'12/31/2014 13:49:23', u'Owner': u'BSS', u'SRCrossStreet': u'', u'FirstName': u'Prasad', u'CreatedByUserLogin': u'PRASAD89', u'LastName': u'Pp', u'SRCouncilDistrictNo': u'1', u'ListOfLa311DocumentLog': {}, u'SRTBColumn': u'E', u'Status': u'Open', u'SRCommunityPoliceStationPREC': u'2', u'ListOfLa311IllegalConstruction': {}, u'ListOfLa311BarricadeRemoval': {}, u'ParentSRStatus': u'', u'NewContactEmail': u'', u'ListOfLa311SanitationBillingEcc': {}, u'ListOfLa311StreetTreeViolations': {}, u'Language': u'English', u'ListOfLa311DeadAnimalRemoval': {}, u'ListOfLa311PalmFrondsDown': {}, u'ListOfLa311IllegalExcavation': {}, u'ServiceDate': u'12/31/2014 00:00:00', u'LoginUser': u'', u'ParentSRNumber': u'', u'SRAreaPlanningCommission': u'Central APC', u'ListOfLa311IllegalDumpingPickup': {}, u'ListOfLa311SidewalkRepair': {}, u'LADWPAccountNo': u'', u'ListOfLa311BillingCsscAdjustment': {}, u'ListOfAuditTrailItem2': {}, u'ListOfLa311IllegalDischargeOfWater': {}, u'SRCommunityPoliceStationAPREC': u'RAMPART', u'ParentSRType': u'', u'Assignee': u'Siebel Administrator', u'ListOfLa311Containers': {}, u'ListOfLa311BeesOrBeehive': {}, u'ListOfLa311BulkyItem': {}, u'SRType': u'Homeless Encampment', u'SRStreetName': u'TEMPLE', u'ListOfLa311WeedAbatementForPrivateParcels': {}, u'ResolutionCode': u'', u'ListOfLa311GraffitiRemoval': {}, u'ListOfLa311Flooding': {}, u'ListOfLa311IllegalVending': {}, u'ListOfLa311TablesAndChairsObstructing': {}, u'ListOfLa311MoveInMoveOut': {}, u'ListOfLa311BillingEccAdjustment': {}, u'ListOfLa311OvergrownVegetationPlants': {}, u'NewContactFirstName': u'', u'ListOfLa311BrushItemsPickup': {}, u'IntegrationId': u'1420033765921', u'ReasonCode': u'', u'ListOfLa311CurbRepair': {}, u'ListOfLa311LeafBlowerViolation': {}, u'ListOfLa311MultipleStreetlightIssue': {}, u'ListOfLa311TreeObstruction': {}, u'ActionTaken': u'', u'ListOfLa311BillingRsscAdjustment': {}, u'ListOfLa311GisLayer': {u'La311GisLayer': [{u'DistrictOffice': u'North Central', u'Area': u'', u'Y_Call_No': u'', u'Fraction': u'', u'StreetLightId': u'', u'Type': u'GIS', u'DistrictAbbr': u'', u'R_Call_No': u'', u'CommunityPlanningArea': u'Westlake', u'LastUpdatedBy': u'', u'DistrictName': u'Central', u'BOSRadioHolderName': u'', u'A_Call_No': u'', u'Day': u'', u'DistrictNumber': u'104', u'Name': u'41572025-3803-49c4-8561-6e7ef41775df', u'StreetTo': u'FIRMIN ST', u'StreetLightStatus': u'', u'DirectionSuffix': u'', u'ShortDay': u'', u'SectionId': u'5279800', u'StreetFrom': u'BOYLSTON ST'}]}, u'ListOfLa311SrPhotoId': {u'La311SrPhotoId': []}, u'ListOfLa311LandMudSlide': {}, u'SRNeighborhoodCouncilId': u'44', u'ListOfLa311BillingRsscExemption': {}, u'SRTBRow': u'2', u'NewContactLastName': u'', u'NewContactPhone': u'', u'ListOfLa311GutterRepair': {}, u'HomePhone': u'3123123123'}]}})]

topic Using NumPyArrayToFeatureClass without JSON Key/Values in Python Questions

Using NumPyArrayToFeatureClass without JSON Key/Values

Re: Using NumPyArrayToFeatureClass without JSON Key/Values