REST Query returning all records instead of one

ChristinaGnadinger — Sun, 12 Dec 2021 01:42:41 GMT

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

Re: REST Query returning all records instead of one

AnthonyGiles — Mon, 19 Nov 2012 18:51:13 GMT

Christina,

What is the call you are making to the REST endpoint.

Does it resemble something like below?

http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/TaxParcel/AssessorsBasemap/MapServer/1/query?objectIds=23&f=json

Regards

Anthony

Re: REST Query returning all records instead of one

nicogis — Wed, 21 Nov 2012 05:18:52 GMT

Christina, if you write it have you same results?

http://stratus.lwc.local/ArcGIS/rest/services/SPIN/WaterSystem/MapServer/30/query?objectIds=11&f=json

Re: REST Query returning all records instead of one

PauPérez_Puigcerver — Tue, 29 Jan 2013 10:00:41 GMT

Hello,

I have the same strange problem. I make a query to a field with number format. The query is this:

http://cartoweb.cma.gva.es/arcgis/rest/services/web_biodiversidad/MapServer/35/query?text=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelContains&relationParam=&objectIds=&where=RECINTO%3D89242185&time=&returnCountOnly=false&returnIdsOnly=false&returnGeometry=true&maxAllowableOffset=&outSR=&outFields=&f=html

but the query returns 50 records with values of RECINTO=89242175 to RECINTO=89242195.

This occurs with a 64bit server with ArcGIS Server 10.04 (SP4).

I make the same query, with the same filegeodatabase table, but in another 32bit server with ArcGIS Server 10.03 (SP1,SP2,SP3 installed), and the result is as expected. The result is 3 records with RECINTO=89242185.

I'm going crazy, because it has no logic.

I tried to make various query (like RECINTO>89242174 AND RECINTO<89242176 with no records returned!!), and I test with diferent fields formats (long integer, double,...) with no results.

Does anyone know if this is a bug?

Thanks.

Pau Pérez Puigcerver
Conselleria de Infraestructuras, Territorio y Medio Ambiente
http://cartoweb.cma.gva.es

Re: REST Query returning all records instead of one

nicogis — Wed, 30 Jan 2013 06:19:30 GMT

try install sp5.
I see NIM080026 in Issues addressed with 10.0 Service Pack 5
http://gisupdates.esri.com/10sp5/ArcGIS/ArcGIS10sp5-issues.htm#Rest-sp5

Re: REST Query returning all records instead of one

PauPérez_Puigcerver — Fri, 01 Feb 2013 10:01:22 GMT

Thanks Domenico for the response,

I will install SP5 and I test it.

I inform you of the results of the test.

Regards

Pau Pérez Puigcerver
Conselleria de Infraestructuras, Territorio y Medio Ambiente
http://cartoweb.cma.gva.es

topic Re: REST Query returning all records instead of one in ArcGIS REST APIs and Services Questions

REST Query returning all records instead of one

Re: REST Query returning all records instead of one

Re: REST Query returning all records instead of one

Re: REST Query returning all records instead of one

Re: REST Query returning all records instead of one

Re: REST Query returning all records instead of one

Re: REST Query returning all records instead of one