20220420 09561200 1.0 FALSE c911_CreateCompositeAddressL1 Address Geocode addresses against multiple address locators. Addr_type Type $Revision: 14$ $Date: 1/31/2012 5:36:09 PM$ TRUE Street ZIP Type=Database;Wks=(ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path = ..\..\..\..\projects\TangiblePersonalProperty\2022Files) 911 :: TRUE Street Type=Database;Wks=(ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path = .) AddressSites_CreateFeatureLo :: 911 Roadsfor911Sys AddressSites_C TRUE Street ZIP Type=Database;Wks=(ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path = ..) Roadsfor911System_CreateAddr :: FALSE ByDescr PROJCS["NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercat or"],PARAMETER["False_Easting",656166.6666666665],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-81.0],PARAMETER["Scale_Factor",0.9999411764705882],PARAMETER["Latitude_Of_Origin",24.33333333333333],UNIT["Foot_US",0.3048006096012192]] -17791300.000000,-41645400.000000,2955094164192.938965,2955070310092.938965 {29B85A89-D2CE-4aeb-BC3F-661A3D2C296E} Street or Intersection ZIP Code Street ZIP Street ZIP 100 10 FALSE FALSE ProgID = esriDataSourcesFile.ShapefileWorkspaceFactory; Path = ..\..\..\..\..\user\kmulcahy\CrimeData\NassauCrime2021 True 10 132925168648290000 1:47:44 PM 1024000000 c911_CreateCompositeAddressL1 SingleLine Single Line Input Address SingleLine FullAddress Customer 100 {3D486637-6BCF-4A0C-83DB-A02D437FB8FC} True True 10.0 FALSE FALSE FALSE FALSE :: :: IN_Street IN_ZIP :: :: Loc_name Shape Status Score Match_addr Addr_type AddNum AddNumFrom AddNumTo Side StPreDir StPreType StName StType StDir StAddr City County State StateAbbr ZIP Country LangCode Distance DisplayX DisplayY Xmin Xmax Ymin Ymax Rank X Y GeocodeAddresses RealtorGeocodeTable D:\GIS\PropertyAppraiser\user\kmulcahy\CrimeData\NassauCrime2021\c911_CreateCompositeAddressL1.loc "'Street or Intersection' address VISIBLE NONE;'ZIP Code' Zipcode VISIBLE NONE" D:\GIS\PropertyAppraiser\projects\TangiblePersonalProperty\2022Files\2022Files\2022Files.gdb\RealtorGeocodeTable_Geocoded1 STATIC # # # # Merge RealtorGeocodeTable_Geocoded1;RealtorXYDisplay D:\GIS\PropertyAppraiser\projects\TangiblePersonalProperty\2022Files\2022Files\2022Files.gdb\RealtorGeocodeTable_Geocoded2 "Loc_name "Loc_name" true true false 14 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,Loc_name,0,14;Status "Status" true true false 1 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,Status,0,1;Score "Score" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Score,-1,-1;Match_type "Match_type" true true false 2 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,Match_type,0,2;Match_addr "Match_addr" true true false 500 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,Match_addr,0,500;Addr_type "Addr_type" true true false 50 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,Addr_type,0,50;AddNum "AddNum" true true false 12 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,AddNum,0,12;AddNumFrom "AddNumFrom" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,AddNumFrom,0,10;AddNumTo "AddNumTo" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,AddNumTo,0,10;Side "Side" true true false 1 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,Side,0,1;StPreDir "StPreDir" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,StPreDir,0,20;StPreType "StPreType" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,StPreType,0,20;StName "StName" true true false 70 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,StName,0,70;StType "StType" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,StType,0,20;StDir "StDir" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,StDir,0,20;StAddr "StAddr" true true false 120 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,StAddr,0,120;City "City" true true false 70 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,City,0,70;County "County" true true false 70 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,County,0,70;State "State" true true false 100 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,State,0,100;StateAbbr "StateAbbr" true true false 100 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,StateAbbr,0,100;ZIP "ZIP" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,ZIP,0,10;Country "Country" true true false 3 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,Country,0,3;LangCode "LangCode" true true false 3 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,LangCode,0,3;Distance "Distance" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Distance,-1,-1;DisplayX "DisplayX" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,DisplayX,-1,-1;DisplayY "DisplayY" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,DisplayY,-1,-1;Xmin "Xmin" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Xmin,-1,-1;Xmax "Xmax" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Xmax,-1,-1;Ymin "Ymin" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Ymin,-1,-1;Ymax "Ymax" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Ymax,-1,-1;Rank "Rank" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Rank,-1,-1;X "X" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,X,-1,-1;Y "Y" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,Y,-1,-1;IN_Street "Street or Intersection" true true false 100 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,IN_Street,0,100;IN_ZIP "ZIP Code" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,IN_ZIP,0,10;USER_house_id "house_id" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_house_id,0,255;USER_detailUrl "detailUrl" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_detailUrl,0,255;USER_unformattedPrice "unformattedPrice" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_unformattedPrice,0,255;USER_address "address" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_address,0,255;USER_addressCity "addressCity" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_addressCity,0,255;USER_addressState "addressState" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_addressState,0,255;USER_beds "beds" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_beds,0,255;USER_bathrooms "bathrooms" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_bathrooms,0,255;USER_area "area" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_area,0,255;USER_latitude "latitude" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_latitude,0,255;USER_longitude "longitude" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_longitude,0,255;USER_Zipcode "Zipcode" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_Zipcode,0,255;USER_homeStatus "homeStatus" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_homeStatus,0,255;USER_Lat "Lat" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_Lat,-1,-1;USER_Long "Long" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded1,USER_Long,-1,-1;house_id "house_id" true true false 255 Text 0 0,First,#,RealtorXYDisplay,house_id,0,255;detailUrl "detailUrl" true true false 255 Text 0 0,First,#,RealtorXYDisplay,detailUrl,0,255;unformattedPrice "unformattedPrice" true true false 255 Text 0 0,First,#,RealtorXYDisplay,unformattedPrice,0,255;address "address" true true false 255 Text 0 0,First,#,RealtorXYDisplay,address,0,255;addressCity "addressCity" true true false 255 Text 0 0,First,#,RealtorXYDisplay,addressCity,0,255;addressState "addressState" true true false 255 Text 0 0,First,#,RealtorXYDisplay,addressState,0,255;beds "beds" true true false 255 Text 0 0,First,#,RealtorXYDisplay,beds,0,255;bathrooms "bathrooms" true true false 255 Text 0 0,First,#,RealtorXYDisplay,bathrooms,0,255;area "area" true true false 255 Text 0 0,First,#,RealtorXYDisplay,area,0,255;latitude "latitude" true true false 255 Text 0 0,First,#,RealtorXYDisplay,latitude,0,255;longitude "longitude" true true false 255 Text 0 0,First,#,RealtorXYDisplay,longitude,0,255;Zipcode "Zipcode" true true false 255 Text 0 0,First,#,RealtorXYDisplay,Zipcode,0,255;homeStatus "homeStatus" true true false 255 Text 0 0,First,#,RealtorXYDisplay,homeStatus,0,255;Lat "Lat" true true false 8 Double 0 0,First,#,RealtorXYDisplay,Lat,-1,-1;Long "Long" true true false 8 Double 0 0,First,#,RealtorXYDisplay,Long,-1,-1" NO_SOURCE_INFO FeatureClassToFeatureClass RealtorGeocodeTable_Geocoded2 D:\GIS\PropertyAppraiser\projects\TangiblePersonalProperty\2022Files\2022Files\nassauflsql.sde\nassauEditing.NASSAUADMIN.WebScrapingData Realtor # "Loc_name "Loc_name" true true false 14 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Loc_name,0,14;Status "Status" true true false 1 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Status,0,1;Score "Score" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Score,-1,-1;Match_type "Match_type" true true false 2 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Match_type,0,2;Match_addr "Match_addr" true true false 500 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Match_addr,0,500;Addr_type "Addr_type" true true false 50 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Addr_type,0,50;AddNum "AddNum" true true false 12 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,AddNum,0,12;AddNumFrom "AddNumFrom" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,AddNumFrom,0,10;AddNumTo "AddNumTo" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,AddNumTo,0,10;Side "Side" true true false 1 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Side,0,1;StPreDir "StPreDir" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,StPreDir,0,20;StPreType "StPreType" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,StPreType,0,20;StName "StName" true true false 70 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,StName,0,70;StType "StType" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,StType,0,20;StDir "StDir" true true false 20 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,StDir,0,20;StAddr "StAddr" true true false 120 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,StAddr,0,120;City "City" true true false 70 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,City,0,70;County "County" true true false 70 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,County,0,70;State "State" true true false 100 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,State,0,100;StateAbbr "StateAbbr" true true false 100 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,StateAbbr,0,100;ZIP "ZIP" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,ZIP,0,10;Country "Country" true true false 3 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Country,0,3;LangCode "LangCode" true true false 3 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,LangCode,0,3;Distance "Distance" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Distance,-1,-1;DisplayX "DisplayX" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,DisplayX,-1,-1;DisplayY "DisplayY" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,DisplayY,-1,-1;Xmin "Xmin" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Xmin,-1,-1;Xmax "Xmax" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Xmax,-1,-1;Ymin "Ymin" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Ymin,-1,-1;Ymax "Ymax" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Ymax,-1,-1;Rank "Rank" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Rank,-1,-1;X "X" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,X,-1,-1;Y "Y" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Y,-1,-1;IN_Street "Street or Intersection" true true false 100 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,IN_Street,0,100;IN_ZIP "ZIP Code" true true false 10 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,IN_ZIP,0,10;USER_house_id "house_id" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_house_id,0,255;USER_detailUrl "detailUrl" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_detailUrl,0,255;USER_unformattedPrice "unformattedPrice" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_unformattedPrice,0,255;USER_address "address" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_address,0,255;USER_addressCity "addressCity" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_addressCity,0,255;USER_addressState "addressState" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_addressState,0,255;USER_beds "beds" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_beds,0,255;USER_bathrooms "bathrooms" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_bathrooms,0,255;USER_area "area" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_area,0,255;USER_latitude "latitude" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_latitude,0,255;USER_longitude "longitude" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_longitude,0,255;USER_Zipcode "Zipcode" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_Zipcode,0,255;USER_homeStatus "homeStatus" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_homeStatus,0,255;USER_Lat "Lat" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_Lat,-1,-1;USER_Long "Long" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,USER_Long,-1,-1;house_id "house_id" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,house_id,0,255;detailUrl "detailUrl" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,detailUrl,0,255;unformattedPrice "unformattedPrice" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,unformattedPrice,0,255;address "address" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,address,0,255;addressCity "addressCity" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,addressCity,0,255;addressState "addressState" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,addressState,0,255;beds "beds" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,beds,0,255;bathrooms "bathrooms" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,bathrooms,0,255;area "area" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,area,0,255;latitude "latitude" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,latitude,0,255;longitude "longitude" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,longitude,0,255;Zipcode "Zipcode" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,Zipcode,0,255;homeStatus "homeStatus" true true false 255 Text 0 0,First,#,RealtorGeocodeTable_Geocoded2,homeStatus,0,255;Lat "Lat" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Lat,-1,-1;Long "Long" true true false 8 Double 0 0,First,#,RealtorGeocodeTable_Geocoded2,Long,-1,-1" # nassauEditing.NASSAUADMIN.Realtor 002 Server=nassauflsql; Service=sde:sqlserver:nassauflsql; Database=nassauEditing; User=nassauadmin; Version=dbo.DEFAULT ArcSDE Connection Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) WGS_1984_Web_Mercator_Auxiliary_Sphere <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> 20220420 10024900 20220420 10024900 Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 17763) ; Esri ArcGIS 12.9.0.32739 nassauEditing_NASSAUADMIN_Realtor Nassau Realtor Enterprise Geodatabase Feature Class dataset EPSG 6.18.3(9.3.1.2) 0 Simple FALSE 0 TRUE FALSE nassauEditing.NASSAUADMIN.Realtor Feature Class 0 OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. Loc_name Loc_name String 14 0 0 Status Status String 1 0 0 Score Score Double 8 38 8 Match_type Match_type String 2 0 0 Match_addr Match_addr String 500 0 0 Addr_type Addr_type String 50 0 0 AddNum AddNum String 12 0 0 AddNumFrom AddNumFrom String 10 0 0 AddNumTo AddNumTo String 10 0 0 Side Side String 1 0 0 StPreDir StPreDir String 20 0 0 StPreType StPreType String 20 0 0 StName StName String 70 0 0 StType StType String 20 0 0 StDir StDir String 20 0 0 StAddr StAddr String 120 0 0 City City String 70 0 0 County County String 70 0 0 State State String 100 0 0 StateAbbr StateAbbr String 100 0 0 ZIP ZIP String 10 0 0 Country Country String 3 0 0 LangCode LangCode String 3 0 0 Distance Distance Double 8 38 8 DisplayX DisplayX Double 8 38 8 DisplayY DisplayY Double 8 38 8 Xmin Xmin Double 8 38 8 Xmax Xmax Double 8 38 8 Ymin Ymin Double 8 38 8 Ymax Ymax Double 8 38 8 Rank Rank Double 8 38 8 X X Double 8 38 8 Y Y Double 8 38 8 IN_Street Street or Intersection String 100 0 0 IN_ZIP ZIP Code String 10 0 0 USER_house_id house_id String 255 0 0 USER_detailUrl detailUrl String 255 0 0 USER_unformattedPrice unformattedPrice String 255 0 0 USER_address address String 255 0 0 USER_addressCity addressCity String 255 0 0 USER_addressState addressState String 255 0 0 USER_beds beds String 255 0 0 USER_bathrooms bathrooms String 255 0 0 USER_area area String 255 0 0 USER_latitude latitude String 255 0 0 USER_longitude longitude String 255 0 0 USER_Zipcode Zipcode String 255 0 0 USER_homeStatus homeStatus String 255 0 0 USER_Lat Lat Double 8 38 8 USER_Long Long Double 8 38 8 house_id house_id String 255 0 0 detailUrl detailUrl String 255 0 0 unformattedPrice unformattedPrice String 255 0 0 address address String 255 0 0 addressCity addressCity String 255 0 0 addressState addressState String 255 0 0 beds beds String 255 0 0 nassauEditing.NASSAUADMIN.Realtor.area nassauEditing.NASSAUADMIN.Realtor.area String 255 0 0 bathrooms bathrooms String 255 0 0 latitude latitude String 255 0 0 longitude longitude String 255 0 0 Zipcode Zipcode String 255 0 0 homeStatus homeStatus String 255 0 0 Lat Lat Double 8 38 8 Long Long Double 8 38 8 20220420 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD25/uH 6UtMlbamfcCn0AFJsXduwM+tNf7yYPOelPoAhuN3lEKOvXHWlWMKuer7cYNQechnJkfAU8DtSrMr TmQHCkbfqaAIGuJnYo0YwvUCrJuGiVd6FfanwR/KXYfMxz0qViAMtjHvQAKwdQw6GloooAO2D0oI xRQDxzQAd6KUikPWgAooooAjVgZDk89hUlMdFYcgdaXYOfWgB1MQcFu5pOZAMjGOtSUAFFFFABSn rSUrdaAEooooAKKKMjOM0AMc5xjBIPQ1BcymKPJcEnjbS3BBby0Ulz19qY8CcfKuB155oAIbQNiW bLOecelPvFH2Zj6dKkhYlmXO5RjBxUN/IFg2d2pgZdFFFMAooooAKKKKANm4bainGfmH86mqFw0i YZcfMDwevNPeRU6nn0HJqQEKEzh88AYp59KM56CmneGG0KR3JNAFeW0Z0OG+bt6UyG0kDYkwEHoe tXqZMhkhZQcEigBwxjiqEnnTSGM8gHPFRW0rRzBWYhQeRWoAM7gOfWmA2IMIwG6in0UUgCk70tJ0 NAEcl1FCSHY5HbaTTo5458mNsj6EUrnCk7S2OwqBLrc4XyZVGccrxQBZooz7U1ZFckKwJHpQAp6g UtNLL5gBODinUAFFFFABRRRQAUp7Gm5oyegH50ALTS21hkcHvR8/qPpSHe2QQPzoAhknIdxnAUAj HenFirruIBxQLfLMXbcCMYx0qOeNE2s2XPfJoAllRs74z82OnqKYmGYOVwAcfT61GpmVgm8A9V75 Hpmlt5PNuW+nNAFysq/fdcY/ujFajEKpJ6CsOR98jN6nNNANooopgFFFFABRRRQBttjGB607cp6s KF7/AFp1SAm5fUUZHrS0m0egoAXNIwypHqKNq+g/KjavoPyoAyI7eSSQrjocEntWlDB5Q+8T/Kpd q+go2igBaKawwMgmnUAFFFFACYx9KUAH+lNfOw461BJItvGsgLkMwXGCc5OKAJpBkqO2eaVkDEHk EdxVWyvotQaZ4lbbE5jyR1I64q5QncBnl9csST60qPuHUZHUU6msit1FADuKOPWqKJLPcsTujgTK 7WHJPqParHkmPmM8991AE1FM81cDrzzT+tAEck8ULASOqkjIyaIbiGYkRyK/HODmnMoYYIB+opEj VGyABQAoYnpSjOOaQKVJp3bigBMnPTimvGHIJGcUoO78OtKeAaAKSwgQy8HzB78inWaqoQofvLlq lnjV489GxwwqpYSFJPLPRulMCTUJtqiIHryfpWdU10++5c+hxUNABRRRTAKKKKACiiigDeXv9aWm fxcZ680+pAjeZEJXOWHang5AOMVWmtN8nmKTu64p6TlYsyqVOcfWgCemluDt5I7UkkixqGboabEA sZKqRnnB60AR4lFwMuSAMn0p0dyJX2qpwOpp0IIUhiC3enRxJHnaMZOTQA48kClpByxPpxS0AFHa ijrQAwlyzBccdzUcvmxxKIYxISwDAtjA7mpI+GcHk5zmkjiKSyuZXYOQQrdF4xgUAQ2axWenLujW 3UDcwLZ2nvk96dLewQwPM0ilEAZtpycHpTvLkd5lmKPC4AVNvI9c+tNjsLWKHykgQIQARjrjpS16 ATowdFYdCMilqOWJZYWiJYKy7flOCPpTkXYiryQBjJOTTAitLVbSDyld3+YsWdskknNT0UUANWNV JI7+tNI8ttw+6eo9PepKQ88UAR/aI/71Ne6UE4GQO9SiNB/CPypwRc7tooAQMGAYdxTC3oOKb5Um 3argAeg60wyuqgbCWUfNkUASZKcjvQzkID0yfyqu0u187WQHjJIOPwqJvOOdtwHwQNuwUAXWx5R7 7eapWQMlyXx8q5x+NOnndYGTynBIwTUdjdLEzRSDaCeGNMCvLxK+f7xplWLxQLgspBVuRiq9MAoo ooAKKKKACiiigDeH3iPxpaQfeNLUgFMeNZCCwzjpT884ooARlDDBpEQIu0Zx7mnUUAMSMR5x0Pan 0UjfdoAF6fWlpqOrjg06gAPSjtSUN90/SgCpLatcSrMtzLE6nAKHgjI4IPB6daLzU7WwDm4d12KH bbGzcE47D1q1H/q14xxTZVlLRmJ1VQ2XBXOVx0Hp2pegDkcSIrr91gCOMcVyXiXXktNds7Qv5flf vTuY7XzwAQoz+ddfWZqFhbX88Y86OO4Q7gNqknHTIPNKabWgEGmmWWyaaxnUvLIHYShmRf723ofz raqnHaSfbPtDuisPl+Rfvr2Bz7+lWPN/0kw7H+5u34+Xr0z60LQB7A7TtwGxxmmQiXyV88oZMfNs GFz7ZqSiqATFLiiigApf4aSlHQigBKKKKAIJlCxyOwd1AJKKMk/SqNpe215MYoyn2iEDehbDJnoC BWrXC3fhUWOrXF5G06JMxke6D7iuTyuz096mUmtkB2qRZyZACc54JxVS7txLuljIOPvCmQ30CtDa RTZZ1+TJ6gd81n69cX1npt7JbHO2MksF+7gdcmqv1AswXGk3VlPdW94rRQZErBvuEdcjtUKukiB4 23Iwyp9RXn1lPeXNnqmqTtJCLqEQPJEQFdgQAQvQkgEcV30CCOCNB0VQP0qac+YZJRRRWggooooA KKKKAN0EBmyR1psquy4jbafWiSMPwe9RMskA+RiVPZucVIEihYiNzfMevPWlaVVcLgkn0qMCRpMO FwRnOKRJo1fbsIJOM44oAnd9g6E/QU4ciiigBhTMgfPQYxSt1xTqQckmgCtBEWlaY5A7Cp0fczj+ 6cfpTidqk+lMhjMe4lsljk0AP5ozniloHWgBifKWT05FPqK4fyUM2x32AkqgySPYVUja6mvWkRjH ECmY3wcrgnIA+6cnv6UrgaFVf7OtPt4vvIT7UF2iXHOPSrVJ3pgZ76e82oyTzXMjQFVCwA4CkHOa 0eoxiiq7rNCzyRbpjI6/Iz4CDgHH86VrAT9T6VEyTea5EwEZTCjbyp9anPIzSUwGRKyRKrvvYDls YzT6TGelNkz5bLv2MQQGxnB9aAH0DrVNftUU4aSdHt0h5AT52buf/rVx9x4/tkkWWxsZ/MuG8oG6 JQbx229vrxUuaW4HWtrWnJq40o3SfbSMiEZzjrVS51qHSb2Kyn81zKSVkZl6nJxiq/h6Eak7a5e2 sKX7ExgqvKKOMZyc/WuT1+wn8Raoy3UEttqNujmGOFMhwSAhd+3Xt2qHJ2uhnUxa3LrN+LS3DWcc eJJTLw5Xg4A6D8ag1zUpnmjubbEtrBksoZhvIOCCMVj6fpmpajBL9mvYRaiVIXRN3zbAFbJP8Oc8 d+KguvEmo3+uvpOkmG1igDRBmwyHHUnr2FQ5u2oGzDc2UV/cagLkthEiNunJjYnsPxq54l1SPT9F cXCRuJ0bCvn5mGDtwK5XQG023gnaz1BLu+Lh7gohcpjrtBHzc10N1FJrurx2F1bE2UcP2gTMMHef l28+xzVJtx0A4zTtsusuhSWO1vpx9ljH3VCEMcg9PSvQ65K30Oy03xjaRWt7LcSRW7yS72BAz8ox jpnrXW1VFWTuDCiiithBRRRQAUUUUAbpV8j5hx/s0fP6Kf0p1GakCNpdrAMACfelJ3Yyh9e1PwDR QA3ePRvyo3r3OPqKdRQA3zFxww/OlX7opoUOSWGR2p9ABRRRQAUUUUABqCGKNHlkWNRIflZgOWx0 /nU5qu/mi1keFd8pyVUtgE9qAHWsz3FskrwSQM2cxyYyOfapTVfyJ2sPINywm2484KM59cdKmiRo 4kRnLsoALHqfekgHFgFLc8elUhqLPZPcx2N221gBGUCuw45AJHHNT3TTpEGtoVlk3AFWbbx3OabL HdtdwmOWNLdeZFKksx9B6ChgZ13rKW1jF9ruI7WaaUR5V1zFnkZDd8dRV15JJJbeS2vYTE4+4yZ3 j1BBFYfiDQbJpYrlhI0wl8xIIY1Jdu5wepxWsJZIHiinhSaXYzRMAFP+6B64qdb6gaW/OQMcdRQc 46CsewY30l3Fe2BtpwylipPzgdDuGK1XBYqgOAeTVJ3AUg9QB+FYGu+F7LXpoJrgFZoDmM44znPI BGfzrfMSnpkfQ1HJG/G0kjvQ0nowG20MVrAIbaIKvJ46Z71XvlTUBJp/mvBOUEgdDyMHg8dRkdM1 ogAKABjFRMjNJnOB2PpRboBhSW8c9/LBHfXa3VuC0gwyowdcYHbHGeDwa8wstAvbsX979oKywMVf cpR3QdTu7+le0HLQhs464J7emawp9Dub3WheNeyxqkCqfJACyHnI61lUp3sNM53wxYRWUyPbNaR3 DRKxuEjyzKf4DuPB9wOa6rVLOa7064RZQJpIyoyDjp7VLDYworTMiGZsEvtBbI7mrLgSwrLFjzDl cPyAT3NXCHLGwjgfCLSDUr6GKJobZAA0R2sFkHHDgZYcHr+vWuvrmdAtr/S9Wk027ZvLSJjGNpCk +YTkevWumoo/ANhRRRWogooooAKKKKAN5W3KG9RS0UVIBRRRQAUUUUANUbWK9uopqzowY5ICnBzT mXPI4I6Gm7VkjKkdev1oAk4oxSAYAGc0tABimuxVcqu4+gp1JmgCtJcShSPs7jPGQRUsE8c28Jn9 22w5GOafJxGx74qMXMAm+z+agmAB2Z55zj+RoAlpc0VXuDdKQbdI3GDkOSDntQBYpRxzTUyVG4AH HOO1JJKiKzMwARdzew9aAI0tlQNlmcliwZjkrn09KzdSWezSxeHfNHFNiTJ+bae/vVi7vrJlgt5Z HAuxiJlVsHPTkdKqrorXd352oyCTAwscZIUY6E88moeuiALK5/tDVXnguJ1jiXy3heMqCeu4ZrZC 85JyahitIoZWkRcOwCk+w6VPVJWAKKiebaxGOlMWRncAnA9qYFgZwaRc45peimmqeg/GgBjQoxPJ APUA8GoxvjLxomcnIPYVOeSPWmPEZP4ivrjrQBGYxHGoAyc/McVHNbOoJg6E5xUxhbytm7IA6mgs fK5yADg4NAHNy2d/e6wt9cCJI7QssZDHcyMBnI9iKuVdu7YrmZDlG6j0qmQQcGhKwCUUUVQBRRRQ AUUUUAb9FFFSAUUUUAFFIfajPtQAtMj5BPqadkUkf3PrzQA6iiigAwKAMUUUAU9RvEs7aSaXPlou 58Ak49qrDV9IuI4roTRy4mEKMqFiJCOgwPQ1NfWsF7DLBcOUjl/dnnBOewotNG0+xKm3twmxi6jc SFJGDgZ44qXe+gF+iio5pDFHvWJ5CCPlTrVASHjj1qvJY20s4meFTKCDu75GcfzNSTymKEyeW7kf woMk0xvPNwmwoIdp3gg7s8Yx+tJgRMUF4IZZBIznfChj4jwOef8AGrYGPrQAFHFLTACR+dFMcg8d xSqxJ9u9AETQlnLMeD6U5YWUnjPoaVpDk4PFNySRzQAr7hgHNNzyKfLIVIHP86Yu2VcqSMHtQA9S Nw+lP7mmxj5cnBz3pWAI64NADqYq7SwHQ8ioBcMFKnBYdDUscqtjnqKAGoo+zsnJ7HI6VUv4kj2b FAJ64qzvPmOqruDc8Hmq94fMt0b0YimBRooopgFFFFABRRRQBv0UUmakBaKTIo5oAB1NLRRQAhGR g0kf3APTinVGTsfPO0/oaAJKKKKACiiigCqzRtJEs0ZdpGyvy5Ckd/arVMjP3h2Bp2c9KAFpqyxm Rog6mRRkrnkCmTiQwOI/vkYBzjFUba0lt7tpgm6SRVV2eTJwPwpAaRPYdaAMCgDFLTADntSYPrS0 gINADCpDZHNI/HCnr1qYVB60ARFZOfnH5URFhNsdgRjOelSUjxh4zk4PYigCZBxVZ5lgnIU7y55U dqgmEsMZIlJB4NMa1cKHRtxpgXrNy8RBxgE4HpSTFpHKx5JXqao28xgkHr396tLK8Z2nYMkksWzQ AwjK7TlueQR0pM+WQx6nsB2qTEjN5iyKMjHSmSRvbjzN2/jkNQBLbyb5SOwHftVW65LqrDYDkAd6 li2SN5cYYbuXJ9PSpZLSIkvjAA6CgDKooPU0UwCiiigAooooA36MYooqQCiiigAooooAKQ88UZpa AGBWHG/j6c0hjDc5Y+5NPPSl7UAMCFfusR7HmkIfB+YY9hzUlI33TQAioFUAU2BJI4gssvmvk/Nt A78cCpKQnsOtABnJwOtAGCaUDaPc0UAFFBOKYWOcDigB9NHBJpNxPANMHXNAEpJAP0qHPOakLZSo 8H0oAXilGNp5pNrelVZZbqJipWHBPHzHOPyoAsPGrrhsEVFbH9zjOcEiovOuShP7jbjnDHI/SnWp VIeWGSaAJ2RXGGUGq01kTJ8jDHvVzbzjIpevB/CgBgG1QB2GKU5ZCOvcUiqw60vNACoF3qVUDI5x RIxEbg9cU35lChQM84LdOlUTeSncrGHP1b/CgCtRUMc+59rYz7ZqaqAKKKKACiiigDfoooqQCiig 0AHSk60Y9aWgAoooxmgBrHkClDDB5qmlnIsxLEFM5HzHNPNhESflbBOfvGgC1SN900RxLEm0Zx9c 0OflOBQAEnoOtNdJdo8kqGzyWGc08cClBPWgCKFbgZ85kP8AuipePWkooAXj0prgbvu8UtDZxkDN AEO70AoyTSN8v1pili3tQBMWYIBnvTck96P4fpUbN5eWIyPagBLiYQp79hVJLmTzgxOe2KkuUJQS nnPTHYVXicJIGIyBTA02hjkwxX5u9OESqflA5pEbIDKetOPqO9IBAMEClHWgE5FGTmgAPU0lPfIO RTcmgAUA5B71G88cW0SOASKlBJPWo5YlljXcSO+RxQBkPLGZiqsCSeKWpJ4FhmYAk55yxzUdUAUU UUAFFFFAG1b3S3KFlyMHBBqbJ9aKKkAyfWjOetFFAEcsAkIPmOuP7rYpI4BGwPmytgdGbIoooAlz 7UhYniiigAxQemKKKAEHB+tDfdNFFAC0v8P1oooATFJRRQAjuEXJGfao/tP+z+tFFAASCc880ceh oooAUYwaTjHSiigBiQBo5EycZwAe1UJrV4i38SjuKKKYElrcYxG34GrwI6HpRRQwA8HpStjPAoop ASlgwHGOKaVUmiigBkinGF4zxTZZBFHuZjtHtmiigDMubmCeUeXKGbHIxUVFFNAFFFFMAooooA// 2Q==