Community
Select to view content in your preferred language

Using NumPyArrayToFeatureClass without JSON Key/Values

3989
1
02-12-2015 02:47 PM
GeoffreyWest
by
Frequent Contributor
‎02-12-2015 02:47 PM

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'}]}})]

Tags (2)
0 Kudos
1 Reply
SachinKanaujia
by
Deactivated User
‎02-12-2015 10:34 PM

Do you have any control over the JSON response that you are getting from your service? Or can you massage the json response to be able to directly used by arcpy.JSONToFeatures_conversion?

0 Kudos