cgnadinger

REST Query returning all records instead of one

Discussion created by cgnadinger on Nov 19, 2012
Latest reply on Feb 1, 2013 by paupepui
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)[/h] 
  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)[/h] 
  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


Outcomes