cd782c42-7952-4c21-813b-f4055d3cdeed2.922000.125PO Box 123Beverly Hillsca9021034.073109-118.39946100ExactCityArealInterpolationArealInterpolationGeometricCentroidLOCATION_TYPE_POST_OFFICE_BOXSuccess06037700800401640167008.0003706PO BOX123Beverly HillsCA90210Beverly HillsBeverly Hills14696078MetersSOURCE_CENSUS_2000_PLACES2000place63086308SOURCE_PARCEL_GEOMETRIES0Required parameters missing - required parameters SOURCE_PARCEL_CENTROIDS0Required parameters missing - required parameters SOURCE_CENSUS_TIGERLINES_20080Required parameters missing - required parameters SOURCE_USPS_ZIP4TIGERLINES0CA 90210NA0Exact000 SELECT tlid as featurePrimaryId, tlid, frlong, frlat, tolong, tolat, carrierRoute, state, county, rlFlag, censusTract, censusBlock, pMSA, cMSA, mMatch, shapeGeog, shapeGeom from CA t where t.zipCode=@param1 and t.plus4=@param2param190210param2SOURCE_CENSUS_2008_ZCTAS090210NA0Exact11001 SELECT zcta5ce as featurePrimaryId, zcta5ce, shapeGeog, shapeGeom, shapeGeog.STArea() as area, shapeGeom.STCentroid().STX as centroidX, shapeGeom.STCentroid().STY as centroidY FROM us_zcta5 t WHERE zcta5ce=@param1param19021010009021090210SOURCE_CENSUS_2000_ZCTAS15.625CA 90210NA15.625Exact11001 select zip as featurePrimaryId, ABBRV, NAME, ZIP, POPULATION, HOUSING, LANDAREAMETERS, WATERAREAMETERS, LANDAREAMILES, WATERAREAMILES, LATITUDE, LONGITUDE from FIPS_Zcta5 t where ZIP=@param1param19021010009021090210SOURCE_CENSUS_2008_PLACES31.25Beverly Hills CA NA31.25Exact11001 SELECT placeFp as featurePrimaryId, placeNs as featureSecondaryId, name, name_soundex, name_soundexDM, shapeGeog, shapeGeom, shapeGeog.STArea() as area, shapeGeom.STCentroid().STX as centroidX, shapeGeom.STCentroid().STY as centroidY FROM CA_place WHERE name_soundex=@param1param1B164100006308Beverly HillsSOURCE_CENSUS_2008_CONSOLIDATED_CITIES31.25Beverly Hills CA NA31.25Exact000 SELECT conctyFp as featurePrimaryId, conctyNs as featureSecondaryId, name, name_soundex, name_soundexDM, shapeGeog, shapeGeom, shapeGeog.STArea() as area, shapeGeom.STCentroid().STX as centroidX, shapeGeom.STCentroid().STY as centroidY FROM CA_concity WHERE name_soundex=@param1param1B164SOURCE_CENSUS_2000_PLACES15.625B164 CA NA15.625Exact11001 select place as featurePrimaryId, ABBRV, STATE, PLACE, NAME, POPULATION, HOUSING, LANDAREAMETERS, WATERAREAMETERS, LANDAREAMILES, WATERAREAMILES, LATITUDE, LONGITUDE from FIPS_Places2k t where SoundexName=@param1 and ABBRV=@param2param1B164param2CA10006308Beverly HillsSOURCE_CENSUS_2008_COUNTY_SUBREGIONS15.625Beverly Hills CA NA15.625Exact000 SELECT cousubFp as featurePrimaryId, cousubNs as featureSecondaryId, name, name_soundex, name_soundexDM, shapeGeog, shapeGeom, shapeGeog.STArea() as area, shapeGeom.STCentroid().STX as centroidX, shapeGeom.STCentroid().STY as centroidY FROM CA_cousub WHERE name_soundex=@param1param1B164SOURCE_CENSUS_2000_COUNTY_SUBREGIONS15.625B164 CA NA15.625Exact000 select countysub as featurePrimaryId, ABBRV, STATE, COUNTY, COUNTYSUB, NAME, POPULATION, HOUSING, LANDAREAMETERS, WATERAREAMETERS, LANDAREAMILES, WATERAREAMILES, LATITUDE, LONGITUDE from FIPS_Cousub2k t where SoundexName=@param1 and ABBRV=@param2param1B164param2CASOURCE_CENSUS_2008_COUNTIES31.25Beverly Hills NA31.25Exact000 SELECT countyFp as featurePrimaryId, countyNs as featureSecondaryId, name, name_soundex, name_soundexDM, shapeGeog, shapeGeom, shapeGeog.STArea() as area, shapeGeom.STCentroid().STX as centroidX, shapeGeom.STCentroid().STY as centroidY FROM us_county WHERE name_soundex=@param1param1B164SOURCE_CENSUS_2000_COUNTIES15.625B164 CA NA15.625Exact000 select county as featurePrimaryId, ABBRV, STATE, COUNTY, NAME, POPULATION, HOUSING, LANDAREAMETERS, WATERAREAMETERS, LANDAREAMILES, WATERAREAMILES, LATITUDE, LONGITUDE from FIPS_County2k t where SoundexName=@param1 and ABBRV=@param2param1B164param2CASOURCE_CENSUS_2008_STATES109.375CA NA109.375Exact11001 SELECT stateFp as featurePrimaryId, stateNs as featureSecondaryId, name, shapeGeog, shapeGeom, shapeGeog.STArea() as area, shapeGeom.STCentroid().STX as centroidX, shapeGeom.STCentroid().STY as centroidY FROM us_state WHERE stUsPs=@param1param1CA100006California