I have a weird issue that I cannot work past. When using the REST Query and searching by ObjectID it appears to return all results (it stops at 1,00 records) instead of the one unique ID. The weirder part is that the same data is working on the consultant's version but is not working here. I thought that maybe this was a data issue but now I am wondering if it's a setting above that which has been missed on our end. Anyone seen this before or have any ideas? I'm going to use the 'code' below just to show you comparitive snippets from my side and theirs. Thank you! MY REST Query Result ... [h=2]Feature (ID: 11)
DEERING
Service.OBJECTID: 1
Service.FACILITY_ID: SP000000001
Service.GIS_CONVERSION_DELIVERY_AREA:
Service.LAST_EDITED_BY:
Service.LAST_EDITED_ON:
Service.SV_OBJECTID: 142292
Service.TEMP_SUBTYPE: 2
Service.SUBTYPE_CODE: 2
Service.ATTACHMENT_NUMBER: 249926
Service.LEAD_DIAMETER: 6
Service.LEAD_MATERIAL: 9
Service.LEAD_MATL_VERIFICATION_CODE:
Service.DATE_INSTALLED: 1989/01/18 00:00:00 UTC
Service.DATE_RENEWED:
Service.DBL_SETTER:
Service.PRESSURE_PLANE:
Service.PRESSURE_CODE: 3
Service.PRV_CODE:
Service.PRV_DATE_INSTALLED:
Service.MEASUREMENT:
Service.SERVICE_ADDRESS_NUMBER: 10801
Service.STREET_DIRECTION:
Service.STREET_TYPE: RD
Service.STREET_ADDRESS: 10801,DEERING RD
Service.GEOCODE_ADDRESS: 10801 DEERING RD
Service.MEASUREMENT_LOCATION1: 30'E C/L DEERING RD
Service.MEASUREMENT_LOCATION2: 38'S NBL
Service.BETWEEN_STREETS: GLYNDON WAY & NORTH
Service.LOCATION_CODE: A
Service.SERVICE_TYPE: FS
Service.ELEVATION:
Service.PROJECT_NUMBER:
Service.METER_VAULT_ID:
Service.MASTER_METER_VAULT_ID:
Service.STREET_NUMBER_SUPPLEMENT:
Service.DATE_POSTED:
Service.DATE_TRANSFERRED:
Service.ECIS_PREMISE: 9104116
T_GIS_EXTRACT.PREMISE_NUMBER: 9104116
T_GIS_EXTRACT.PREMISE_STATUS: AC
T_GIS_EXTRACT.SERVICE_ADDRESS: 10801 DEERING RD
T_GIS_EXTRACT.METER_NUMBER: 50457489
T_GIS_EXTRACT.SERVICE_TYPE: F
T_GIS_EXTRACT.ATTACHMENT_NUMBER: 249926
T_GIS_EXTRACT.CLOSE_DATE:
T_GIS_EXTRACT.ACCOUNT_NUMBER: 660824
T_GIS_EXTRACT.ACCOUNT_STATUS: AC
T_GIS_EXTRACT.CUSTOMER_NAME: OUR LADY OF CONSOLATION
T_GIS_EXTRACT.MAILING_ADDRESS_1: ST PETER THE APOSTLE CATH CH
T_GIS_EXTRACT.MAILING_ADDRESS_2: 5431 JOHNSONTOWN RD
T_GIS_EXTRACT.MAILING_ADDRESS_3: LOUISVILLE KY
T_GIS_EXTRACT.MAILING_ZIP: 40272
T_GIS_EXTRACT.TELEPHONE_NUMBER: 5029375920
T_GIS_EXTRACT.TAXING_DISTRICT: JEFF
T_GIS_EXTRACT.PROJECT:
T_GIS_EXTRACT.MEASUREMENT:
T_GIS_EXTRACT.BETWEEN_STREETS: GLYNDON WAY & NORTH
- Point:
X: 1176861.50322944
Y: 221638.358323187
VALLEY STATION
Service.OBJECTID:
2
Service.FACILITY_ID: SP000000002
Service.GIS_CONVERSION_DELIVERY_AREA:
Service.LAST_EDITED_BY:
Service.LAST_EDITED_ON:
Service.SV_OBJECTID: 142293
Service.TEMP_SUBTYPE: 2
Service.SUBTYPE_CODE: 2
Service.ATTACHMENT_NUMBER: 191493
Service.LEAD_DIAMETER: 4
Service.LEAD_MATERIAL: 7
Service.LEAD_MATL_VERIFICATION_CODE: 1
Service.DATE_INSTALLED: 1968/09/30 00:00:00 UTC
Service.DATE_RENEWED:
Service.DBL_SETTER:
Service.PRESSURE_PLANE:
Service.PRESSURE_CODE: 3
Service.PRV_CODE:
Service.PRV_DATE_INSTALLED:
Service.MEASUREMENT: 4X2
Service.SERVICE_ADDRESS_NUMBER: 4601
Service.STREET_DIRECTION:
Service.STREET_TYPE: RD
Service.STREET_ADDRESS: 4601,VALLEY STATION RD
Service.GEOCODE_ADDRESS: 4601 VALLEY STATION RD
Service.MEASUREMENT_LOCATION1: 220' N-SBL
Service.MEASUREMENT_LOCATION2: 266' S-NBL
Service.BETWEEN_STREETS: VALLEY STA RD & W
Service.LOCATION_CODE: O
Service.SERVICE_TYPE: DS
Service.ELEVATION:
Service.PROJECT_NUMBER: 12387
Service.METER_VAULT_ID:
Service.MASTER_METER_VAULT_ID:
Service.STREET_NUMBER_SUPPLEMENT:
Service.DATE_POSTED:
Service.DATE_TRANSFERRED:
Service.ECIS_PREMISE: 9103377
T_GIS_EXTRACT.PREMISE_NUMBER: 9103377
T_GIS_EXTRACT.PREMISE_STATUS: AC
T_GIS_EXTRACT.SERVICE_ADDRESS: 4601 VALLEY STATION RD
T_GIS_EXTRACT.METER_NUMBER: 70204147A
T_GIS_EXTRACT.SERVICE_TYPE: WM
T_GIS_EXTRACT.ATTACHMENT_NUMBER: 191493
T_GIS_EXTRACT.CLOSE_DATE:
T_GIS_EXTRACT.ACCOUNT_NUMBER: 659646
T_GIS_EXTRACT.ACCOUNT_STATUS: AC
T_GIS_EXTRACT.CUSTOMER_NAME: JEFF CO BD OF ED
T_GIS_EXTRACT.MAILING_ADDRESS_1: STUART MIDDLE 144
T_GIS_EXTRACT.MAILING_ADDRESS_2: PO BOX 35340
T_GIS_EXTRACT.MAILING_ADDRESS_3: LOUISVILLE KY
T_GIS_EXTRACT.MAILING_ZIP: 402325340
T_GIS_EXTRACT.TELEPHONE_NUMBER: 0
T_GIS_EXTRACT.TAXING_DISTRICT: JEFF
T_GIS_EXTRACT.PROJECT: 12387
T_GIS_EXTRACT.MEASUREMENT: 2X8
T_GIS_EXTRACT.BETWEEN_STREETS: VALLEY STA RD & OLD 3RD ST RD
Point:
X: 1181470.27091478
Y: 225510.985748515
.... and it goes on until it maxes at 1,000
THEIR result: [h=2]Feature (ID: 11)
VALLEY COLLEGE
Service.OBJECTID: 11
Service.FACILITY_ID: SP000000011
Service.GIS_CONVERSION_DELIVERY_AREA:
Service.LAST_EDITED_BY:
Service.LAST_EDITED_ON:
Service.SV_OBJECTID: 142302
Service.TEMP_SUBTYPE: 2
Service.SUBTYPE_CODE: 2
Service.ATTACHMENT_NUMBER: 231718
Service.LEAD_DIAMETER: 4
Service.LEAD_MATERIAL: 9
Service.LEAD_MATL_VERIFICATION_CODE:
Service.DATE_INSTALLED: 1979/01/31 00:00:00 UTC
Service.DATE_RENEWED:
Service.DBL_SETTER:
Service.PRESSURE_PLANE:
Service.PRESSURE_CODE: 3
Service.PRV_CODE:
Service.PRV_DATE_INSTALLED:
Service.MEASUREMENT: 2X1
Service.SERVICE_ADDRESS_NUMBER: 1000
Service.STREET_DIRECTION:
Service.STREET_TYPE: DR
Service.STREET_ADDRESS: 1000,VALLEY COLLEGE DR
Service.GEOCODE_ADDRESS: 1000 VALLEY COLLEGE DR
Service.MEASUREMENT_LOCATION1: 1' W #231717
Service.MEASUREMENT_LOCATION2: 64' W F H #229246
Service.BETWEEN_STREETS: BENTFORD DR & W
Service.LOCATION_CODE: Y
Service.SERVICE_TYPE: FS
Service.ELEVATION:
Service.PROJECT_NUMBER:
Service.METER_VAULT_ID:
Service.MASTER_METER_VAULT_ID:
Service.STREET_NUMBER_SUPPLEMENT:
Service.DATE_POSTED:
Service.DATE_TRANSFERRED:
Service.ECIS_PREMISE: 9103214
T_GIS_EXTRACT.PREMISE_NUMBER: 9103214
T_GIS_EXTRACT.PREMISE_STATUS: AC
T_GIS_EXTRACT.SERVICE_ADDRESS: 1000 VALLEY COLLEGE DR
T_GIS_EXTRACT.METER_NUMBER: 80251622
T_GIS_EXTRACT.SERVICE_TYPE: F
T_GIS_EXTRACT.ATTACHMENT_NUMBER: 231718
T_GIS_EXTRACT.CLOSE_DATE:
T_GIS_EXTRACT.ACCOUNT_NUMBER: 659415
T_GIS_EXTRACT.ACCOUNT_STATUS: AC
T_GIS_EXTRACT.CUSTOMER_NAME: JEFFERSON COMM & TECH COLLEGE
T_GIS_EXTRACT.MAILING_ADDRESS_1: PAMELA WITMER- DUMM
T_GIS_EXTRACT.MAILING_ADDRESS_2: 109 E BROADWAY
T_GIS_EXTRACT.MAILING_ADDRESS_3: LOUISVILLE KY
T_GIS_EXTRACT.MAILING_ZIP: 402020000
T_GIS_EXTRACT.TELEPHONE_NUMBER: 5022132109
T_GIS_EXTRACT.TAXING_DISTRICT: JEFF
T_GIS_EXTRACT.PROJECT:
T_GIS_EXTRACT.MEASUREMENT: 2X1
T_GIS_EXTRACT.BETWEEN_STREETS: BENTFORD DR & W
- Point:
X: 1181498.59041195
Y: 227370.755322933