trees

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
27880 438 1 5 792X Dolores St 2 Sidewalk: Curb side : Cutout Tree 1     80 6   6004975.0011312 2103729.1085203 37.7567208435744 -122.425788038834 (37.7567208435744, -122.425788038834) 2 4 5 28862 3
48763 225089 1 5 838 Church St 1 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6004316.16009 2104019.9015 37.7574820391842 -122.428087274435 (37.7574820391842, -122.428087274435) 2 4 5 28862 3
54428 50386 7 5 296 Liberty St 5 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
77339 225088 1 5 3899 19th St 3 Sidewalk: Property side : Yard Tree 2     11 Width 3ft   6003725.04695 2104766.83601 37.7594994820291 -122.430184865761 (37.7594994820291, -122.430184865761) 2 4 5 28862 3
85099 225087 1 5 3901 19th St 3 Sidewalk: Property side : Yard Tree 2     11 Width 3ft   6003680.66693 2104762.35118 37.7594846540097 -122.430338033793 (37.7594846540097, -122.430338033793) 2 4 5 28862 3
99119 50383 7 5 296 Liberty St 2 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
103441 50384 7 5 296 Liberty St 7 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
130611 50385 7 5 296 Liberty St 6 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
131762 50388 7 5 296 Liberty St 3 Sidewalk: Curb side : Cutout Tree 2   10/01/2003 12:00:00 AM     Permit Number 47041 6004379.7762802 2103977.8532584 37.7573701836913 -122.427864268021 (37.7573701836913, -122.427864268021) 2 4 5 28862 3
2297 16623 1 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
18931 16634 1 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
47329 16647 1 5 178 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   09/04/2015 12:00:00 AM 14 4x4   6002850.60519 2107244.6681 37.7662534427777 -122.433386179722 (37.7662534427777, -122.433386179722) 15 5 5 28862 3
48301 225091 1 5 169 Lower Ter 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6000007.70524 2106202.33536 37.7632297601708 -122.443144329371 (37.7632297601708, -122.443144329371) 15 5 5 28862 3
54510 225090 1 5 188 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6002851.63466 2107200.77986 37.7661329947706 -122.433379482476 (37.7661329947706, -122.433379482476) 15 5 5 28862 3
62764 16626 1 5 138 Noe St 1 Sidewalk: Curb side : Cutout Tree 1   02/02/2001 12:00:00 AM 21 3X3   6002836.08721 2107485.6498 37.7669142960875 -122.43345361721 (37.7669142960875, -122.43345361721) 15 5 5 28862 3
66656 16644 1 5 170 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 4X4   6002849.24717 2107272.65524 37.7663302115978 -122.433392876987 (37.7663302115978, -122.433392876987) 15 5 5 28862 3
74388 16650 7 5 190 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6002855.60879 2107200.17785 37.7661315672606 -122.433365693732 (37.7661315672606, -122.433365693732) 15 5 5 28862 3
134226 16641 7 5 161 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6002897.9493228 2107328.6416625 37.7664866995789 -122.433228426337 (37.7664866995789, -122.433228426337) 15 5 5 28862 3
134432 32473 1 5 144 Lower Ter 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/10/1996 12:00:00 AM 9   Permit Number 36981 6000263.91054 2106227.11632 37.7633124078752 -122.442259981907 (37.7633124078752, -122.442259981907) 15 5 5 28862 3
146708 116858 1 5 180 NOE ST 1 Sidewalk: Curb side : Cutout Tree 1     14 3x3   6002788 2107242 37.7662425648461 -122.433602528192 (37.7662425648461, -122.433602528192) 15 5 5 28862 3
172953 34010 7 5 123 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   04/28/1997 12:00:00 AM     Permit Number 37945 6002886.66979468 2107551.69377695 37.7670985064042 -122.433283380019 (37.7670985064042, -122.433283380019) 15 5 5 28862 3