c322d4b5-e3b3-489e-913f-872de82502e22.922000.093759355 Berton WayBevirrly Hillsca9021034.1001824100596-118.412720944444100ExactZCTAArealInterpolationArealInterpolationGeometricCentroidLOCATION_TYPE_STREET_ADDRESSSuccess06037261101200720072611.01037069355BERTONWAYBevirrly HillsCA90210902109021024101004.3596798MetersSOURCE_CENSUS_2008_ZCTAS2008zcta5ce9021090210SOURCE_PARCEL_GEOMETRIES31.259355 BERTON WAY Bevirrly Hills CA 90210NA31.25Exact000 select assessorid as featurePrimaryId, p.id, p.hasmultipleassessorids, p.assessorid, p.number, p.name, p.suffix, p.pre, p.post, p.zip, p.city, g.centerLat, g.centerLon, g.coordinates, g.geometryType from la_assessor_cache_parcels p, la_assessor_cache_geometries g where p.assessorid=g.ain and number=@param1 and ( Name=@param2 ) and ( city=@param3 OR zip=@param4 ) and State=@param5param19355param2BERTONparam3Bevirrly Hillsparam490210param5CASOURCE_PARCEL_CENTROIDS09355 B635 WAY B164 CA 90210NA0Exact1351 select assessorid as featurePrimaryId, p.id, p.assessorid, p.number, p.name, p.suffix, p.pre, p.post, p.zip, p.city, p.state, p.latitude, p.longitude, p.area, p.areaUnits from parcelCentroids_CA p where number=@param1 and ( SoundexName=@param2 ) and ( p.SoundexCity=@param3 OR zip=@param4 ) param19355param2B635param3B164param4902103504342-011-9039355BURTONWAYBEVERLY HILLSCA90210SOURCE_CENSUS_TIGERLINES_200809355 B635 WAY B164 CA 90210Left0Exact000 select tlid as featurePrimaryId, tlid ,fromLon ,fromLat ,toLon ,toLat ,fullName ,preDirAbrv ,preTypAbrv ,preQualAbr ,name ,name_Soundex ,name_SoundexDM ,sufDirAbrv ,sufTypAbrv ,sufQualAbr , shapeGeog , shapeGeom ,lFromAdd ,lToAdd ,fromHn as lFromHn ,fromHN_Number as lfromHN_Number ,fromHN_Unit as lfromHN_Unit ,toHn as lToHn ,toHN_Number as ltoHN_Number ,toHN_Unit as ltoHN_Unit ,zip as lZip ,plus4 as lZipPlus4 ,placeFp00 as lplaceFp00 ,placeName00 as lplaceName00 ,placeName00_Soundex as lplaceName00_Soundex ,placeName00_SoundexDM as lplaceName00_SoundexDM ,conCtyFp00 as lconCtyFp00 ,conCtyName00 as lconCtyName00 ,conCtyName00_Soundex as lconCtyName00_Soundex ,conCtyName00_SoundexDM as lconCtyName00_SoundexDM ,subMcdFp00 as lsubMcdFp00 ,subMcdName00 as lsubMcdName00 ,subMcdName00_Soundex as lsubMcdName00_Soundex ,subMcdName00_SoundexDM as lsubMcdName00_SoundexDM ,couSubFp00 as lcouSubFp00 ,couSubName00 as lcouSubName00 ,couSubName00_Soundex as lcouSubName00_Soundex ,couSubName00_SoundexDM as lcouSubName00_SoundexDM ,countyFp00 as lcountyFp00 ,countyName00 as lcountyName00 ,countyName00_Soundex as lcountyName00_Soundex ,countyName00_SoundexDM as lcountyName00_SoundexDM ,stateFp00 as lstateFp00 ,tractCe00 as ltractCe00 ,blkGrpCe00 as lblkGrpCe00 ,blockCe00 as lblockCe00 ,suffix1Ce as lsuffix1Ce ,'' as rFromAdd ,'' as rToAdd ,'' as rFromHn ,'' as rfromHN_Number ,'' as rfromHN_Unit ,'' as rToHn ,'' as rtoHN_Number ,'' as rtoHN_Unit ,'' as rZip ,'' as rZipPlus4 ,'' as rplaceFp00 ,'' as rplaceName00 ,'' as rplaceName00_Soundex ,'' as rplaceName00_SoundexDM ,'' as rconCtyFp00 ,'' as rconCtyName00 ,'' as rconCtyName00_Soundex ,'' as rconCtyName00_SoundexDM ,'' as rsubMcdFp00 ,'' as rsubMcdName00 ,'' as rsubMcdName00_Soundex ,'' as rsubMcdName00_SoundexDM ,'' as rcouSubFp00 ,'' as rcouSubName00 ,'' as rcouSubName00_Soundex ,'' as rcouSubName00_SoundexDM ,'' as rcountyFp00 ,'' as rcountyName00 ,'' as rcountyName00_Soundex ,'' as rcountyName00_SoundexDM ,'' as rstateFp00 ,'' as rtractCe00 ,'' as rblkGrpCe00 ,'' as rblockCe00 ,'' as rsuffix1Ce from [Tiger2008Streets].[dbo].[CA_Left] where ( Name_Soundex=@param1 ) and ( zip=@param2 OR placeName00_Soundex=@param3 OR conCtyName00_Soundex=@param4 OR subMcdName00_Soundex=@param5 OR couSubName00_Soundex=@param6 OR countyName00_Soundex=@param7 ) and fromHn_Number_Even = 0 and ( ( fromHn_Number >=@param8 and toHn_Number <=@param9 ) or ( fromHn_Number <=@param10 and toHn_Number >=@param11 ) ) param1B635param290210param3B164param4B164param5B164param6B164param7B164param89355param99355param109355param1193559355 B635 WAY B164 CA 90210Right0Exact1351 select tlid as featurePrimaryId, tlid ,fromLon ,fromLat ,toLon ,toLat ,fullName ,preDirAbrv ,preTypAbrv ,preQualAbr ,name ,name_Soundex ,name_SoundexDM ,sufDirAbrv ,sufTypAbrv ,sufQualAbr , shapeGeog , shapeGeom ,rFromAdd ,rToAdd ,fromHn as rFromHn ,fromHN_Number as rfromHN_Number ,fromHN_Unit as rfromHN_Unit ,toHn as rToHn ,toHN_Number as rtoHN_Number ,toHN_Unit as rtoHN_Unit ,zip as rZip ,plus4 as rZipPlus4 ,placeFp00 as rplaceFp00 ,placeName00 as rplaceName00 ,placeName00_Soundex as rplaceName00_Soundex ,placeName00_SoundexDM as rplaceName00_SoundexDM ,conCtyFp00 as rconCtyFp00 ,conCtyName00 as rconCtyName00 ,conCtyName00_Soundex as rconCtyName00_Soundex ,conCtyName00_SoundexDM as rconCtyName00_SoundexDM ,subMcdFp00 as rsubMcdFp00 ,subMcdName00 as rsubMcdName00 ,subMcdName00_Soundex as rsubMcdName00_Soundex ,subMcdName00_SoundexDM as rsubMcdName00_SoundexDM ,couSubFp00 as rcouSubFp00 ,couSubName00 as rcouSubName00 ,couSubName00_Soundex as rcouSubName00_Soundex ,couSubName00_SoundexDM as rcouSubName00_SoundexDM ,countyFp00 as rcountyFp00 ,countyName00 as rcountyName00 ,countyName00_Soundex as rcountyName00_Soundex ,countyName00_SoundexDM as rcountyName00_SoundexDM ,stateFp00 as rstateFp00 ,tractCe00 as rtractCe00 ,blkGrpCe00 as rblkGrpCe00 ,blockCe00 as rblockCe00 ,suffix1Ce as rsuffix1Ce ,'' as lFromAdd ,'' as lToAdd ,'' as lFromHn ,'' as lfromHN_Number ,'' as lfromHN_Unit ,'' as lToHn ,'' as ltoHN_Number ,'' as ltoHN_Unit ,'' as lZip ,'' as lZipPlus4 ,'' as lplaceFp00 ,'' as lplaceName00 ,'' as lplaceName00_Soundex ,'' as lplaceName00_SoundexDM ,'' as lconCtyFp00 ,'' as lconCtyName00 ,'' as lconCtyName00_Soundex ,'' as lconCtyName00_SoundexDM ,'' as lsubMcdFp00 ,'' as lsubMcdName00 ,'' as lsubMcdName00_Soundex ,'' as lsubMcdName00_SoundexDM ,'' as lcouSubFp00 ,'' as lcouSubName00 ,'' as lcouSubName00_Soundex ,'' as lcouSubName00_SoundexDM ,'' as lcountyFp00 ,'' as lcountyName00 ,'' as lcountyName00_Soundex ,'' as lcountyName00_SoundexDM ,'' as lstateFp00 ,'' as ltractCe00 ,'' as lblkGrpCe00 ,'' as lblockCe00 ,'' as lsuffix1Ce from [Tiger2008Streets].[dbo].[CA_Right] where ( Name_Soundex=@param1 ) and ( zip=@param2 OR placeName00_Soundex=@param3 OR conCtyName00_Soundex=@param4 OR subMcdName00_Soundex=@param5 OR couSubName00_Soundex=@param6 OR countyName00_Soundex=@param7 ) and fromHn_Number_Even = 0 and ( ( fromHn_Number >=@param8 and toHn_Number <=@param9 ) or ( fromHn_Number <=@param10 and toHn_Number >=@param11 ) ) param1B635param290210param3B164param4B164param5B164param6B164param7B164param89355param99355param109355param1193553501415724429301-9369BurtonWayBeverly HillsLos AngelesLos AngelesCA90210SOURCE_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_ZCTAS15.62590210NA15.625Exact11001 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=@param1param19021010009021090210