trees

Custom SQL query returning 25 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
154248 18380 1 53 756 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree 1     40 3X3   6010387.2722525 2104782.2318449 37.7599168463595 -122.407144570806 (37.7599168463595, -122.407144570806) 10 4 8 28859 19
158152 6829 7 53 1450X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
158929 101720 4 53 560 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
161591 21959 1 53 2525 03RD ST 3 Sidewalk: Curb side : Cutout Tree 1     12 4x6   6015860.3 2103824.9 37.7575929852339 -122.388149048897 (37.7575929852339, -122.388149048897) 10 3 8 28856 29
163580 116126 4 53 2500X Keith St 2 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
163969 18370 1 53 635 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree 1     25 4x4   6010438.67568 2105328.38433 37.7614193346753 -122.407005286068 (37.7614193346753, -122.407005286068) 10 4 8 28859 19
166186 112407 4 53 300x 15TH ST 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
168880 112409 4 53 300x 15TH ST 7 Sidewalk: Curb side : Cutout Tree 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
169319 101719 4 53 560 Wisconsin St 5 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
169622 6721 1 53 1200X Fairfax Ave 18 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
170902 18297 1 53 35X Potrero Ave 1 Sidewalk: Curb side : Cutout Tree 1     35 3X3   6010274.737783 2108072.9305947 37.7689460585554 -122.407765812226 (37.7689460585554, -122.407765812226) 8 4 8 28853 19
174144 116127 4 53 2500X Keith St 3 Sidewalk: Curb side : Cutout Tree 5           6014198.52795 2092093.45262 37.7252886606488 -122.393075349238 (37.7252886606488, -122.393075349238) 10 3 8 58 1
176915 101718 4 53 560 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
178024 173876 1 53 250 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6009764 2087931 37.7136120890563 -122.408111727364 (37.7136120890563, -122.408111727364) 9 7 8 309 39
179093 21930 1 53 2347 03rd St 2 Sidewalk: Curb side : Cutout Tree 1     12 3x5   6015939.39473 2104425.48438 37.7592464441674 -122.38791741203 (37.7592464441674, -122.38791741203) 10 3 8 28856 29
179159 101726 4 53 560 Wisconsin St 12 Sidewalk: Curb side : Cutout Tree 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
182806 112161 7 53 1324 18th St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6013680.97327942 2105726.70860795 37.7626939483281 -122.39581935837 (37.7626939483281, -122.39581935837) 14 3 8 28856 29
183113 18328 1 53 269 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree 1     40 3X3   6010332.3440196 2107072.4168362 37.7662021013824 -122.407496007113 (37.7662021013824, -122.407496007113) 8 4 8 28853 19
188021 6788 1 53 1390 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 1     18 3x3   6016787.1910829 2097353.9213772 37.7398763247169 -122.384492742853 (37.7398763247169, -122.384492742853) 10 3 8 58 1
188136 120939 4 53 485 Carolina St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
188909 6818 7 53 1400X Fairfax Ave 10 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
190734 6815 7 53 1400X Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree 16     12 3X3   6016560.8212721 2097522.8211505 37.7403275687029 -122.385287208511 (37.7403275687029, -122.385287208511) 10 3 8 58 1
150567 25558 1 53 50X Industrial St 3 Sidewalk: Curb side : Cutout Tree 1   01/23/2001 12:00:00 AM 8 4X4   6012204.29417 2097469.52586 37.7399392564551 -122.400346698766 (37.7399392564551, -122.400346698766) 10 3 8 58 1
135125 45390 7 53 1501-1555 Mariposa St 9 Sidewalk: Curb side : Cutout Tree 2   07/10/2001 12:00:00 AM     Permit Number 44202 6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
143054 57622 7 53 1401 18th St 1 Sidewalk: Curb side : Cutout Tree 2   11/15/1976 12:00:00 AM     Permit Number 16516 6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29