Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63634 | 63634 | 182440 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1530 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985926.0511 | 2104791.6519 | 37.7585434265078 | -122.49174356193998 | (37.7585434265078, -122.49174356194) | |||
148086 | 148086 | 182304 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2531 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986925.2797 | 2105029.7497 | 37.759255527351606 | -122.488305322992 | (37.7592555273516, -122.488305322992) | |||
134064 | 134064 | 206001 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1830 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5990646.261940001 | 2102911.1762200003 | 37.7536548815855 | -122.47528182930701 | (37.7536548815855, -122.475281829307) | |||
122019 | 122019 | 205987 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | |||
171108 | 171108 | 206012 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990870.16608 | 2097736.47672 | 37.739459475161794 | -122.474129983014 | (37.7394594751618, -122.474129983014) | |||
45525 | 45525 | 206011 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990881.65673 | 2097736.82059 | 37.739461084972206 | -122.47409027886299 | (37.7394610849722, -122.474090278863) | |||
172191 | 172191 | 206010 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.47400476141199 | (37.7394635005399, -122.474004761412) | |||
164290 | 164290 | 206009 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990946.443519999 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | |||
44285 | 44285 | 206008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990990.06403 | 2097739.22497 | 37.7394739659536 | -122.47371563298701 | (37.7394739659536, -122.473715632987) | |||
74726 | 74726 | 206007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991032.21326 | 2097741.2680200003 | 37.739482016692904 | -122.473570049822 | (37.7394820166929, -122.473570049822) | |||
150091 | 150091 | 206006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | |||
157059 | 157059 | 206005 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553001 | (37.7394900683054, -122.47345704553) | |||
101854 | 101854 | 114592 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 70 LOMITA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5991433.0 | 2104626.0 | 37.7584089066312 | -122.472686161822 | (37.7584089066312, -122.472686161822) | |||
126890 | 126890 | 206004 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | |||
121279 | 121279 | 112815 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10 LOMITA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991472.0 | 2104830.0 | 37.7589712942358 | -122.472566156736 | (37.7589712942358, -122.472566156736) | ||||
186595 | 186595 | 206002 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1593 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991725.37276 | 2104496.31776 | 37.758069753342205 | -122.47166556633199 | (37.7580697533422, -122.471665566332) | |||
34084 | 34084 | 206003 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1593 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991725.497880001 | 2104502.2556 | 37.7580860643266 | -122.471665566325 | (37.7580860643266, -122.471665566325) | |||
33051 | 33051 | 123914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 389 09th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993078.53663 | 2112857.8084299997 | 37.7811063777719 | -122.467593853963 | (37.7811063777719, -122.467593853963) | |||
132092 | 132092 | 206014 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | |||
54347 | 54347 | 206013 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992845.13508 | 2095810.8192900002 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | |||
187567 | 187567 | 218314 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) | |||
60183 | 60183 | 218315 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 437 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5993144.55141 | 2099923.03964 | 37.7455947140337 | -122.46642509806401 | (37.7455947140337, -122.466425098064) | |||
168692 | 168692 | 205988 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1469 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993333.43827 | 2105504.18267 | 37.7609299931406 | -122.46617747513099 | (37.7609299931406, -122.466177475131) | |||
65825 | 65825 | 205992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993371.398019999 | 2093686.3141400001 | 37.728483309840996 | -122.46518778469299 | (37.728483309841, -122.465187784693) | |||
45186 | 45186 | 205991 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993388.91946 | 2093682.37508 | 37.72847350453279 | -122.465126926677 | (37.7284735045328, -122.465126926677) | |||
73260 | 73260 | 205990 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993405.09676 | 2093676.5167599998 | 37.7284583518695 | -122.46507057606001 | (37.7284583518695, -122.46507057606) | |||
69557 | 69557 | 205989 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.46305702188499 | (37.744370734026, -122.463057021885) | |||
176560 | 176560 | 205994 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 334 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994253.11993 | 2101023.44894 | 37.7486800649323 | -122.462671676761 | (37.7486800649323, -122.462671676761) | |||
154445 | 154445 | 205993 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 334 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5994259.77922 | 2101011.29176 | 37.7486470679175 | -122.46264776740401 | (37.7486470679175, -122.462647767404) | |||
119338 | 119338 | 113383 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 146 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5994461.0 | 2101055.0 | 37.7487786662853 | -122.46195512222401 | (37.7487786662853, -122.461955122224) | |||
34571 | 34571 | 206020 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.46188794817499 | (37.7487957447457, -122.461887948175) | |||
66533 | 66533 | 206019 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994816.51833 | 2099704.78199 | 37.745091768175605 | -122.460627918846 | (37.7450917681756, -122.460627918846) | |||
43855 | 43855 | 206018 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | |||
32711 | 32711 | 124322 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5996192.87314 | 2113669.7360400003 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | |||
51566 | 51566 | 124321 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Jordan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5996193.40211 | 2113658.2283900003 | 37.783483467186706 | -122.45687595100901 | (37.7834834671867, -122.456875951009) | |||
43464 | 43464 | 206016 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.45650193453899 | (37.7299087874515, -122.456501934539) | |||
67325 | 67325 | 206015 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.45639483786199 | (37.7296789783055, -122.456394837862) | |||
151522 | 151522 | 206017 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 59 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5996580.0039099995 | 2094034.75678 | 37.72962455671671 | -122.454120687124 | (37.7296245567167, -122.454120687124) | |||
43510 | 43510 | 225058 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996870.764690001 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | |||
55625 | 55625 | 225059 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 245 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5997024.32382 | 2107012.23049 | 37.7652829636624 | -122.453521279988 | (37.7652829636624, -122.453521279988) | |||
162230 | 162230 | 225060 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 243 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997087.67897 | 2106671.87912 | 37.76435207719771 | -122.453277577199 | (37.7643520771977, -122.453277577199) | |||
129912 | 129912 | 225061 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 5997502.5049 | 2105021.0962900002 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | |||
31832 | 31832 | 222918 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997702.832359999 | 2107152.93734 | 37.7657081802151 | -122.451184638974 | (37.7657081802151, -122.451184638974) | |||
53992 | 53992 | 222919 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.765662537824895 | -122.45056955843701 | (37.7656625378249, -122.450569558437) | |||
68238 | 68238 | 222920 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 957 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998076.5165 | 2106905.9783799998 | 37.765051481758 | -122.449874352843 | (37.765051481758, -122.449874352843) | |||
177491 | 177491 | 222921 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 957 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5998078.46928 | 2106885.24351 | 37.7649946607859 | -122.44986610424601 | (37.7649946607859, -122.449866104246) | |||
59009 | 59009 | 206021 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | |||
71127 | 71127 | 222923 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 88 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998162.74598 | 2106870.63901 | 37.764959382183704 | -122.449573561064 | (37.7649593821837, -122.449573561064) | |||
35330 | 35330 | 125967 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3440 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 5998347.68841 | 2115559.3339299997 | 37.7888268704136 | -122.449560024485 | (37.7888268704136, -122.449560024485) | |||
42030 | 42030 | 206000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997987.32263 | 2094070.28162 | 37.729802697139604 | -122.44925801953801 | (37.7298026971396, -122.449258019538) | ||||
27876 | 27876 | 222922 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998725.13711 | 2107078.63003 | 37.7655626303238 | -122.44764337315 | (37.7655626303238, -122.44764337315) | |||
35726 | 35726 | 222928 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 912 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998758.16977 | 2106859.07637 | 37.764961679071796 | -122.447513315894 | (37.7649616790718, -122.447513315894) | |||
133409 | 133409 | 222927 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 912 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998760.527480001 | 2106841.60616 | 37.764913845009 | -122.44750390358 | (37.764913845009, -122.44750390358) | |||
174584 | 174584 | 222924 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998822.080680001 | 2106365.6721900003 | 37.763610567293 | -122.447256751019 | (37.763610567293, -122.447256751019) | |||
23379 | 23379 | 222925 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.763562478748604 | -122.44724507779499 | (37.7635624787486, -122.447245077795) | |||
174435 | 174435 | 222926 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998842.04298 | 2106555.36385 | 37.7641325536076 | -122.447201360861 | (37.7641325536076, -122.447201360861) | |||
163059 | 163059 | 225062 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998883.5307 | 2107364.0663900003 | 37.76635541778779 | -122.44711607094601 | (37.7663554177878, -122.447116070946) | |||
167323 | 167323 | 225063 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 247 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998979.478759999 | 2106681.18548 | 37.7644858801306 | -122.44673506598998 | (37.7644858801306, -122.44673506599) | |||
185355 | 185355 | 225064 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 253 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998981.0777900005 | 2106664.05961 | 37.7644389481338 | -122.446728303069 | (37.7644389481338, -122.446728303069) | |||
174545 | 174545 | 205998 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998781.20203 | 2096512.5772400002 | 37.736554040821204 | -122.446689155601 | (37.7365540408212, -122.446689155601) | |||
57071 | 57071 | 205997 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5998801.07075 | 2096511.7970599998 | 37.736553033585295 | -122.446620405109 | (37.7365530335853, -122.446620405109) | |||
45915 | 45915 | 205996 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998822.4881 | 2096514.65172 | 37.736562095172296 | -122.446546561796 | (37.7365620951723, -122.446546561796) | |||
157892 | 157892 | 205995 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998862.6525 | 2096533.61775 | 37.7366164654663 | -122.446409060855 | (37.7366164654663, -122.446409060855) | |||
161602 | 161602 | 225042 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 979 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5999193.16537 | 2106656.55415 | 37.764430453131105 | -122.44599421345801 | (37.7644304531311, -122.445994213458) | |||
155584 | 155584 | 138737 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2945 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999415.669 | 2114277.6236 | 37.7853686673978 | -122.44577276106199 | (37.7853686673978, -122.445772761062) | |||
135516 | 135516 | 247504 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.44514278745399 | (37.7703040400286, -122.445142787454) | |||
65703 | 65703 | 138239 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999639.177 | 2114119.037 | 37.784945988756 | -122.444988088871 | (37.784945988756, -122.444988088871) | |||
65381 | 65381 | 138240 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999643.6372 | 2114098.2225 | 37.7848890921049 | -122.444971161243 | (37.7848890921049, -122.444971161243) | |||
47133 | 47133 | 138241 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999646.1152 | 2114082.8594 | 37.784847050450104 | -122.444961483404 | (37.7848470504501, -122.444961483404) | |||
25551 | 25551 | 138242 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999647.1063 | 2114070.9654 | 37.7848144491807 | -122.444957199215 | (37.7848144491807, -122.444957199215) | |||
53751 | 53751 | 138243 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1509 Lyon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999648.5931 | 2114056.0979 | 37.7847737117432 | -122.44495098624701 | (37.7847737117432, -122.444950986247) | |||
38805 | 38805 | 139008 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | |||
175276 | 175276 | 139007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999691.7088 | 2114071.461 | 37.78481835543629 | -122.444802925313 | (37.7848183554363, -122.444802925313) | |||
134055 | 134055 | 139006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | |||
89436 | 89436 | 110184 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
95567 | 95567 | 110183 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
97353 | 97353 | 110185 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
53354 | 53354 | 139055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2693 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999732.7035 | 2113978.0164 | 37.784564120210796 | -122.444654378813 | (37.7845641202108, -122.444654378813) | |||
175525 | 175525 | 139056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2693 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999748.2433 | 2113980.0087 | 37.7845704772917 | -122.44460075979201 | (37.7845704772917, -122.444600759792) | |||
4380 | 4380 | 106727 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000017.8025 | 2114366.8285 | 37.785647962066996 | -122.443695977864 | (37.785647962067, -122.443695977864) | |||
56567 | 56567 | 139360 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000048.0331 | 2114373.2711 | 37.7856673759403 | -122.443591852007 | (37.7856673759403, -122.443591852007) | |||
174977 | 174977 | 225091 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | |||
188391 | 188391 | 225051 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.752498802180796 | -122.439839555559 | (37.7524988021808, -122.439839555559) | |||
71217 | 71217 | 125968 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2810 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001336.417830001 | 2115647.62359 | 37.7892398148051 | -122.43922579254101 | (37.7892398148051, -122.439225792541) | |||
154480 | 154480 | 225052 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000953.83658 | 2096674.2134099999 | 37.737121725291296 | -122.439189029173 | (37.7371217252913, -122.439189029173) | |||
37675 | 37675 | 225057 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | |||
65489 | 65489 | 225056 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901044995 | -122.43874836315399 | (37.737188901045, -122.438748363154) | |||
178420 | 178420 | 225055 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 348 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001114.83392 | 2096694.1461 | 37.7371856158122 | -122.438633817409 | (37.7371856158122, -122.438633817409) | |||
184149 | 184149 | 225054 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6001139.36381 | 2096693.2959599998 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | |||
32281 | 32281 | 225053 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6001218.80684 | 2096592.16387 | 37.736911510559295 | -122.438267032523 | (37.7369115105593, -122.438267032523) | |||
71848 | 71848 | 125969 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2672 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002023.76351 | 2115741.9503 | 37.7895379005066 | -122.43685441882 | (37.7895379005066, -122.43685441882) | |||
42068 | 42068 | 205999 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001682.52176 | 2095686.8275900001 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | |||
38071 | 38071 | 125966 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | |||
32238 | 32238 | 175841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 407 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002201.57312 | 2091201.22242 | 37.7221650589433 | -122.434483841864 | (37.7221650589433, -122.434483841864) | |||
134756 | 134756 | 225092 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002638.752309999 | 2108633.09345 | 37.770053697148796 | -122.434218205527 | (37.7700536971488, -122.434218205527) | |||
74103 | 74103 | 225093 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283004 | -122.43408300774901 | (37.770617436283, -122.434083007749) | |||
72741 | 72741 | 175840 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) | |||
5182 | 5182 | 225094 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | |
59003 | 59003 | 225090 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 188 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002851.63466 | 2107200.7798599997 | 37.7661329947706 | -122.433379482476 | (37.7661329947706, -122.433379482476) | |||
35683 | 35683 | 225082 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 543 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002779.31526 | 2103257.0391599997 | 37.7553003306644 | -122.433347783174 | (37.7553003306644, -122.433347783174) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");