trees

Custom SQL query returning 30 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
164683 112815 4 5 10 LOMITA AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5991472 2104830 37.7589712942358 -122.472566156736 (37.7589712942358, -122.472566156736) 1 8 4 56 12
161171 113383 4 5 146 CASTENADA AVE 2 Sidewalk: Curb side : Cutout Tree 2     7 3x3   5994461 2101055 37.7487786662853 -122.461955122224 (37.7487786662853, -122.461955122224) 1 8 4 29491 40
110855 114592 4 5 70 LOMITA AVE 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3   5991433 2104626 37.7584089066312 -122.472686161822 (37.7584089066312, -122.472686161822) 1 8 4 56 12
116296 182304 1 5 2531 Kirkham St 4 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   5986925.2797 2105029.7497 37.7592555273516 -122.488305322992 (37.7592555273516, -122.488305322992) 1 8 3 56 35
42305 182440 1 5 1530 33rd Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   5985926.0511 2104791.6519 37.7585434265078 -122.49174356194 (37.7585434265078, -122.49174356194) 1 8 3 56 35
239 205987 1 5 1639 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541) 1 8 4 56 12
129163 205988 1 5 1469 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   5993333.43827 2105504.18267 37.7609299931406 -122.466177475131 (37.7609299931406, -122.466177475131) 1 8 4 56 12
76986 205989 1 5 566 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree 2     5 Width 6ft   5994108.82044 2099457.01961 37.744370734026 -122.463057021885 (37.744370734026, -122.463057021885) 1 8 4 29491 40
159563 205993 1 5 334 Pacheco St 1 Sidewalk: Curb side : Yard Tree 2     10 Width 3ft   5994259.77922 2101011.29176 37.7486470679175 -122.462647767404 (37.7486470679175, -122.462647767404) 1 8 4 29491 40
91647 205994 1 5 334 Pacheco St 2 Sidewalk: Curb side : Yard Tree 2     9 Width 3ft   5994253.11993 2101023.44894 37.7486800649323 -122.462671676761 (37.7486800649323, -122.462671676761) 1 8 4 29491 40
149591 206002 1 5 1593 15th Ave 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5991725.37276 2104496.31776 37.7580697533422 -122.471665566332 (37.7580697533422, -122.471665566332) 1 8 4 56 12
191561 206003 1 5 1593 15th Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5991725.49788 2104502.2556 37.7580860643266 -122.471665566325 (37.7580860643266, -122.471665566325) 1 8 4 56 12
75171 206004 1 5 10 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5991469.80126 2104851.05791 37.7590289864229 -122.472575296214 (37.7590289864229, -122.472575296214) 1 8 4 56 12
50124 206005 1 5 600 Vicente St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5991064.94409 2097743.51009 37.7394900683054 -122.47345704553 (37.7394900683054, -122.47345704553) 1 8 4 29491 40
21860 206006 1 5 600 Vicente St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5991049.3393 2097743.54574 37.7394892625221 -122.473511002145 (37.7394892625221, -122.473511002145) 1 8 4 29491 40
33818 206007 1 5 600 Vicente St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5991032.21326 2097741.26802 37.7394820166929 -122.473570049822 (37.7394820166929, -122.473570049822) 1 8 4 29491 40
170609 206008 1 5 600 Vicente St 5 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5990990.06403 2097739.22497 37.7394739659536 -122.473715632987 (37.7394739659536, -122.473715632987) 1 8 4 29491 40
164831 206009 1 5 650 Vicente St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5990946.44352 2097737.21302 37.7394659152092 -122.47386630538 (37.7394659152092, -122.47386630538) 1 8 4 29491 40
145696 206010 1 5 650 Vicente St 3 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   5990906.39798 2097737.17838 37.7394635005399 -122.474004761412 (37.7394635005399, -122.474004761412) 1 8 4 29491 40
176911 206011 1 5 650 Vicente St 4 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5990881.65673 2097736.82059 37.7394610849722 -122.474090278863 (37.7394610849722, -122.474090278863) 1 8 4 29491 40
182568 206012 1 5 650 Vicente St 5 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   5990870.16608 2097736.47672 37.7394594751618 -122.474129983014 (37.7394594751618, -122.474129983014) 1 8 4 29491 40
11562 206018 1 5 99 Merced Ave 3 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   5994828.29695 2099714.01169 37.7451177882671 -122.460587859436 (37.7451177882671, -122.460587859436) 1 8 4 59 40
111983 206019 1 5 99 Merced Ave 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5994816.51833 2099704.78199 37.7450917681756 -122.460627918846 (37.7450917681756, -122.460627918846) 1 8 4 59 40
120839 206020 1 5 146 Castenada Ave 1 Sidewalk: Curb side : Yard Tree 2     6 Width 3ft   5994480.54768 2101060.81011 37.7487957447457 -122.461887948175 (37.7487957447457, -122.461887948175) 1 8 4 29491 40
51567 20965 1 5 2002X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
124717 20967 1 5 2002X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
55015 20969 1 5 2002X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
188809 218314 1 5 437 Castenada Ave 2 Sidewalk: Curb side : Yard Tree 2     7 Width 0ft   5993129.70143 2099920.62697 37.7455872325622 -122.466476271275 (37.7455872325622, -122.466476271275) 1 8 4 29491 40
47941 218315 1 5 437 Castenada Ave 1 Sidewalk: Curb side : Yard Tree 2     7 Width 0ft   5993144.55141 2099923.03964 37.7455947140337 -122.466425098064 (37.7455947140337, -122.466425098064) 1 8 4 29491 40
142864 32581 1 5 1314 33rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/22/1996 12:00:00 AM 4   Permit Number 37055 5985876.1437 2106257.7648 37.7625660493627 -122.492024105228 (37.7625660493627, -122.492024105228) 1 8 3 56 35