Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 35568 | 35568 | 225084 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.43192775097401 | (37.7547027131682, -122.431927750974) | |||
| 37728 | 37728 | 225083 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3782 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003229.02977 | 2103031.88331 | 37.7547076090931 | -122.431776461616 | (37.7547076090931, -122.431776461616) | |||
| 3024 | 3024 | 225099 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 109 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 14 | Width 3ft | Permit Number 37779 | 6003663.75485 | 2108815.27117 | 37.770612035853404 | -122.43068573955401 | (37.7706120358534, -122.430685739554) | |
| 28883 | 28883 | 225087 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3901 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003680.66693 | 2104762.3511799998 | 37.759484654009704 | -122.43033803379299 | (37.7594846540097, -122.430338033793) | |||
| 41526 | 41526 | 225088 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3899 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003725.04695 | 2104766.8360099997 | 37.7594994820291 | -122.43018486576099 | (37.7594994820291, -122.430184865761) | |||
| 25477 | 25477 | 225086 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.756311078698296 | -122.429732966312 | (37.7563110786983, -122.429732966312) | |||
| 182071 | 182071 | 222886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Webster St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | |||
| 64492 | 64492 | 222913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004271.62218 | 2109232.3150299997 | 37.771791556066 | -122.428612851729 | (37.771791556066, -122.428612851729) | |||
| 43924 | 43924 | 225098 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6004313.032319999 | 2109116.83696 | 37.7714768248189 | -122.42846137891199 | (37.7714768248189, -122.428461378912) | |||
| 30270 | 30270 | 225097 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6004333.63591 | 2109116.4123400003 | 37.7714768248196 | -122.42839007973998 | (37.7714768248196, -122.42839007974) | |||
| 131148 | 131148 | 225096 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004357.77926 | 2109121.0465599997 | 37.7714909154158 | -122.428306896964 | (37.7714909154158, -122.428306896964) | |||
| 74525 | 74525 | 225089 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.16009 | 2104019.9015 | 37.757482039184204 | -122.428087274435 | (37.7574820391842, -122.428087274435) | |||
| 41360 | 41360 | 225095 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | |||
| 26761 | 26761 | 175842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 234 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004274.97667 | 2092050.6197400002 | 37.724614796925 | -122.427377064513 | (37.724614796925, -122.427377064513) | |||
| 176670 | 176670 | 175843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 154 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004555.98826 | 2092507.33419 | 37.7258847232758 | -122.42643814711501 | (37.7258847232758, -122.426438147115) | |||
| 154109 | 154109 | 225081 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004907.37106 | 2095955.144 | 37.7353714997996 | -122.42546869953199 | (37.7353714997996, -122.425468699532) | |||
| 37517 | 37517 | 246517 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 41 Waller St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005417.73549 | 2109222.5624700002 | 37.771829573112605 | -122.424647671566 | (37.7718295731126, -122.424647671566) | |||
| 564 | 564 | 222895 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.0940099997 | 37.765017648370105 | -122.42151112584801 | (37.7650176483701, -122.421511125848) | ||
| 568 | 568 | 222894 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.42142962480301 | (37.765028210007, -122.421429624803) | |
| 58420 | 58420 | 125975 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007035.474780001 | 2121873.14157 | 37.806656174619704 | -122.41994966175601 | (37.8066561746197, -122.419949661756) | |||
| 182201 | 182201 | 125976 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | |||
| 60186 | 60186 | 248270 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | |||
| 167049 | 167049 | 248271 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | |||
| 50402 | 50402 | 248264 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006711.60121 | 2098736.3727599997 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | |||
| 68659 | 68659 | 248263 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.743141812234505 | -122.41940912783899 | (37.7431418122345, -122.419409127839) | |||
| 45389 | 45389 | 248262 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | |||
| 104259 | 104259 | 248261 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | |||
| 165360 | 165360 | 248260 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | |||
| 135232 | 135232 | 248274 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006747.61558 | 2098750.1570099997 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | |||
| 46452 | 46452 | 248275 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006752.53211 | 2098758.7700799997 | 37.743173713897 | -122.41928809889299 | (37.743173713897, -122.419288098893) | |||
| 183547 | 183547 | 248276 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.41927801298401 | (37.7431956465585, -122.419278012984) | |||
| 66722 | 66722 | 248258 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006769.1868199995 | 2098841.93634 | 37.7434030077589 | -122.41923640944201 | (37.7434030077589, -122.419236409442) | |||
| 179238 | 179238 | 248257 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.41920489088899 | (37.7434438819296, -122.419204890889) | |||
| 156357 | 156357 | 248255 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | |||
| 45296 | 45296 | 248254 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | |||
| 176531 | 176531 | 248253 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006804.331590001 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | |||
| 33356 | 33356 | 248279 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | |||
| 65181 | 65181 | 248195 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006895.3062 | 2099022.5140400003 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | |||
| 32338 | 32338 | 248196 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 99 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006902.26536 | 2099037.70953 | 37.7439480508589 | -122.41879013796101 | (37.7439480508589, -122.418790137961) | |||
| 152658 | 152658 | 248198 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006917.65895 | 2099068.8782900004 | 37.744034500003295 | -122.418739120308 | (37.7440345000033, -122.418739120308) | |||
| 184060 | 184060 | 248231 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 80 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006921.48329 | 2099128.86154 | 37.74419941586729 | -122.41873014957599 | (37.7441994158673, -122.418730149576) | |||
| 181222 | 181222 | 248199 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698121999 | (37.7440974516285, -122.41868698122) | |||
| 185308 | 185308 | 248230 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 74 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006935.57349 | 2099151.82262 | 37.7442632551522 | -122.418683056597 | (37.7442632551522, -122.418683056597) | |||
| 55143 | 55143 | 248200 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006940.782319999 | 2099105.37762 | 37.744136020872205 | -122.418661752548 | (37.7441360208722, -122.418661752548) | |||
| 149673 | 149673 | 248229 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 72 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006943.33301 | 2099166.5172900003 | 37.7443040402894 | -122.41865726764401 | (37.7443040402894, -122.418657267644) | |||
| 65155 | 65155 | 248201 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.41863372066601 | (37.7441794671077, -122.418633720666) | |||
| 40106 | 40106 | 248228 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692775995 | -122.41861802300501 | (37.744353692776, -122.418618023005) | |||
| 176629 | 176629 | 248202 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 51 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006954.7875 | 2099136.48348 | 37.7442222190818 | -122.418615530989 | (37.7442222190818, -122.418615530989) | |||
| 137669 | 137669 | 248203 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | |||
| 149968 | 149968 | 248204 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 47 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006982.897919999 | 2099182.4975099997 | 37.744350145854796 | -122.418521593214 | (37.7443501458548, -122.418521593214) | |||
| 75887 | 75887 | 225065 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006960.17815 | 2097772.4528099997 | 37.740477199257704 | -122.418500188445 | (37.7404771992577, -122.418500188445) |
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");