trees

Custom SQL query returning 19 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
9765 222852 1 79 649 Anderson St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6007802.40089 2095893.19782 37.7353645561353 -122.415455091188 (37.7353645561353, -122.415455091188) 2 7 7 28859 2
32922 188440 1 79 900 Marin St 4 : Tree 2     2 Width 4ft   6016353.67764 2100743.44065 37.7491592669079 -122.3862279089 (37.7491592669079, -122.3862279089) 10 3 8 58 1
34570 222848 1 79 2070 Folsom St 7 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6008058.5906 2106381.50911 37.7641774972273 -122.415311589056 (37.7641774972273, -122.415311589056) 8 4 7 28859 19
36055 188441 1 79 1075 Jamestown Ave 1 Sidewalk: Curb side : Yard Tree 2     2     6013593.18256 2089903.25055 37.7192411588259 -122.39501465042 (37.7192411588259, -122.39501465042) 10 3 8 58 1
40844 188439 1 79 900 Marin St 2 : Tree 2     3 Width 4ft   6016416.33259 2100747.09096 37.7491727576269 -122.386011499647 (37.7491727576269, -122.386011499647) 10 3 8 58 1
42012 222846 1 79 3561 21st St 3 Sidewalk: Curb side : Cutout Tree 2     2 Width 4ft   6004563.86343 2103647.46019 37.7564734144392 -122.427204088022 (37.7564734144392, -122.427204088022) 2 4 5 28862 22
61896 188437 1 79 1465 Rhode Island St 2 Sidewalk: Curb side : Yard Tree 2     8     6012048.22997 2101554.20026 37.7511461921502 -122.40117325816 (37.7511461921502, -122.40117325816) 10 3 8 28856 29
64039 222850 1 79 273 Shotwell St 4 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6007793.11648 2106436.26322 37.7643129153438 -122.416233668472 (37.7643129153438, -122.416233668472) 8 4 7 28859 19
75391 35886 1 79 75 Elmira St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/24/1998 12:00:00 AM 4   Permit Number 39086 6011194.17734 2096389.63188 37.7369177176839 -122.403763315527 (37.7369177176839, -122.403763315527) 10 3 8 58 1
89381 188436 1 79 1310 Indiana St 3 : Yard Tree 2     3     6014947.70455 2102543.51938 37.7540239822338 -122.391215632613 (37.7540239822338, -122.391215632613) 10 3 8 28856 29
97193 222772 1 79 536 Anderson St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6007815.82632 2096357.10873 37.7366391086093 -122.415441506922 (37.7366391086093, -122.415441506922) 2 7 7 28859 2
101501 222853 1 79 2080 17th St 4 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6007942.40284 2106221.49613 37.7637316079458 -122.415702119659 (37.7637316079458, -122.415702119659) 8 4 7 28859 19
114805 188438 1 79 1745 20th St 2 Sidewalk: Curb side : Yard Tree 2     22 Width 3ft   6012749.716 2104689.9757 37.7597954579003 -122.398967497246 (37.7597954579003, -122.398967497246) 10 3 8 28856 29
145305 175824 1 79 513 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 2ft   6003279.46186 2090380.81794 37.7199735379163 -122.430699328333 (37.7199735379163, -122.430699328333) 9 7 6 28861 5
150759 222773 1 79 814 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6010409.50553 2104382.37345 37.7588201692277 -122.407039491788 (37.7588201692277, -122.407039491788) 10 4 7 28859 19
151978 109060 1 79 766 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6012895.08532 2112551.84478 37.7813904807355 -122.399016555269 (37.7813904807355, -122.399016555269) 6 2 9 28856 34
157904 35884 1 79 65 Elmira St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/24/1998 12:00:00 AM 3   Permit Number 39085 6011192.13952 2096439.01345 37.737053195154 -122.403773834904 (37.737053195154, -122.403773834904) 10 3 8 58 1
167591 222849 1 79 275 Shotwell St 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6007803.87297 2106259.20967 37.7638273722537 -122.416183924266 (37.7638273722537, -122.416183924266) 8 4 7 28859 19
191083 222851 1 79 586 Duncan St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6002830.3384 2099791.36235 37.7457872948532 -122.43292374744 (37.7457872948532, -122.43292374744) 2 7 5 63 22