Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1160 | 1160 | 18860 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004055.90045 | 2116026.39415 | 37.7904341972353 | -122.429843740294 | (37.7904341972353, -122.429843740294) | |||
| 1249 | 1249 | 237914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 5997227.0 | 2107052.0 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | |||
| 1440 | 1440 | 222893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | |||
| 3206 | 3206 | 189833 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 2 | : 4 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | ||
| 3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
| 3418 | 3418 | 18865 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2230 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003863.26827 | 2115999.97726 | 37.7903507527417 | -122.43050834919501 | (37.7903507527417, -122.430508349195) | |||
| 6028 | 6028 | 11179 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6006893.591019999 | 2121789.4662 | 37.8064184289444 | -122.42043473540001 | (37.8064184289444, -122.4204347354) | |||
| 6403 | 6403 | 11181 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6006890.68476 | 2121823.94924 | 37.8065129467732 | -122.42044724225599 | (37.8065129467732, -122.420447242256) | |||
| 6620 | 6620 | 18859 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2212 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/1992 12:00:00 AM | 12 | 3X3 | 6004082.46062 | 2116030.31556 | 37.7904464684691 | -122.429752123658 | (37.7904464684691, -122.429752123658) | ||
| 7418 | 7418 | 11180 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006892.18437 | 2121805.14198 | 37.806461391357004 | -122.420440716763 | (37.806461391357, -122.420440716763) | |||
| 7949 | 7949 | 14640 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 600X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6006169.26455 | 2112150.7692 | 37.779912136471 | -122.422256155719 | (37.779912136471, -122.422256155719) | |||
| 11938 | 11938 | 19762 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 100 STAIRWAY16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 11951 | 11951 | 19967 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 100 STAIRWAY41 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 13413 | 13413 | 17446 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6012949.4647699995 | 2096727.20845 | 37.737942533829106 | -122.397718137505 | (37.7379425338291, -122.397718137505) | |||
| 13486 | 13486 | 2517 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016481.64243 | 2098901.45238 | 37.7441086284068 | -122.385657039951 | (37.7441086284068, -122.385657039951) | |||
| 13503 | 13503 | 16543 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016084.8488 | 2098009.98397 | 37.74163887514379 | -122.38696691508999 | (37.7416388751438, -122.38696691509) | ||
| 13899 | 13899 | 16527 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016370.17243 | 2098292.39049 | 37.7424301004582 | -122.386000034169 | (37.7424301004582, -122.386000034169) | |||
| 13990 | 13990 | 16545 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:31:00 PM | 3 | 3x3 | 6016063.42274 | 2097976.36799 | 37.7415453861211 | -122.38703865582701 | (37.7415453861211, -122.387038655827) | ||
| 14034 | 14034 | 78331 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014103.033559999 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | |
| 14232 | 14232 | 2518 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016498.61775 | 2098890.1921900003 | 37.7440786495081 | -122.38559755790399 | (37.7440786495081, -122.385597557904) | |||
| 14244 | 14244 | 2501 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016709.08958 | 2098828.16093 | 37.7439199677279 | -122.38486546568599 | (37.7439199677279, -122.384865465686) | |||
| 14264 | 14264 | 2516 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016465.84234 | 2098914.75953 | 37.7441442928392 | -122.38571260096 | (37.7441442928392, -122.38571260096) | |||
| 14293 | 14293 | 17415 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.73659758599771 | -122.395366549732 | (37.7365975859977, -122.395366549732) | |||
| 14317 | 14317 | 2533 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016180.33193 | 2099126.3075599996 | 37.7447093575531 | -122.386714591425 | (37.7447093575531, -122.386714591425) | |||
| 14483 | 14483 | 7418 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010342.8854 | 2110986.7114 | 37.77695044101711 | -122.407735574616 | (37.7769504410171, -122.407735574616) | |||
| 14807 | 14807 | 2520 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016533.26 | 2098864.45764 | 37.744009904432 | -122.385475978555 | (37.744009904432, -122.385475978555) | |||
| 14851 | 14851 | 2534 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016196.15475 | 2099115.85615 | 37.744681536129896 | -122.38665915001499 | (37.7446815361299, -122.386659150015) | |||
| 14926 | 14926 | 17432 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1899 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013304.38665 | 2096386.76437 | 37.7370275033033 | -122.39646713286899 | (37.7370275033033, -122.396467132869) | |||
| 14957 | 14957 | 2540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016367.14673 | 2098986.82897 | 37.7443367189812 | -122.386058894813 | (37.7443367189812, -122.386058894813) | |||
| 15046 | 15046 | 17433 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1900 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6013265.7394 | 2096489.52235 | 37.7373075045406 | -122.396607955902 | (37.7373075045406, -122.396607955902) | |||
| 15063 | 15063 | 16523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016311.2033400005 | 2098218.94031 | 37.742225157565606 | -122.386198814044 | (37.7422251575656, -122.386198814044) | |||
| 15110 | 15110 | 7417 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1090 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2003 12:00:00 AM | 6 | 3X3 | 6010360.058999999 | 2111002.9309 | 37.7769959373466 | -122.40767730948099 | (37.7769959373466, -122.407677309481) | ||
| 15226 | 15226 | 16522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016298.51131 | 2098203.0123900003 | 37.7421807202532 | -122.386241589372 | (37.7421807202532, -122.386241589372) | |||
| 15281 | 15281 | 2535 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016210.73833 | 2099105.1228400003 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | |||
| 15374 | 15374 | 16525 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016336.5971099995 | 2098251.27907 | 37.7423153586798 | -122.38611326331801 | (37.7423153586798, -122.386113263318) | |||
| 15444 | 15444 | 2521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016567.75907 | 2098840.9849799997 | 37.743947361995794 | -122.38535505210501 | (37.7439473619958, -122.385355052105) | |||
| 15447 | 15447 | 2513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016387.5124699995 | 2098972.29453 | 37.7442979375022 | -122.385987460765 | (37.7442979375022, -122.385987460765) | |||
| 15529 | 15529 | 78325 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014082.074630001 | 2094268.0058099998 | 37.731253074258596 | -122.393630047885 | (37.7312530742586, -122.393630047885) | |
| 15570 | 15570 | 2499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016750.97009 | 2098814.51662 | 37.7438848195436 | -122.384719700863 | (37.7438848195436, -122.384719700863) | |||
| 15581 | 15581 | 2519 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016516.51157 | 2098877.59586 | 37.7440450526322 | -122.38553480681101 | (37.7440450526322, -122.385534806811) | |||
| 15597 | 15597 | 16524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016323.686869999 | 2098236.56346 | 37.7422742380775 | -122.386156877755 | (37.7422742380775, -122.386156877755) | |||
| 15614 | 15614 | 17378 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1600 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6014792.92868 | 2095354.29337 | 37.7342752738796 | -122.391248382303 | (37.7342752738796, -122.391248382303) | |||
| 15657 | 15657 | 2514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016429.25086 | 2098939.95078 | 37.7442114380124 | -122.385840882964 | (37.7442114380124, -122.385840882964) | |||
| 15689 | 15689 | 2500 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016728.12134 | 2098825.14197 | 37.7439127309012 | -122.384799447345 | (37.7439127309012, -122.384799447345) | |||
| 15763 | 15763 | 2504 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | |||
| 15943 | 15943 | 2515 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | |||
| 15961 | 15961 | 17437 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1919 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6013108.75457 | 2096537.612 | 37.7374308105776 | -122.397154099803 | (37.7374308105776, -122.397154099803) | |||
| 16090 | 16090 | 2536 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016262.668930001 | 2099065.69559 | 37.744547487686 | -122.38642565812 | (37.744547487686, -122.38642565812) | |||
| 16099 | 16099 | 16541 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | |||
| 16103 | 16103 | 17387 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6014551.02447 | 2095461.0111900002 | 37.7345548713079 | -122.39209219010901 | (37.7345548713079, -122.392092190109) | |||
| 16423 | 16423 | 2503 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016672.43224 | 2098847.72364 | 37.743971655361705 | -122.384993582204 | (37.7439716553617, -122.384993582204) | |||
| 16483 | 16483 | 16521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016284.3157 | 2098184.69928 | 37.742129650455205 | -122.38628939735099 | (37.7421296504552, -122.386289397351) | |||
| 16723 | 16723 | 2498 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016761.82696 | 2098799.8032400003 | 37.7438450200413 | -122.384681135251 | (37.7438450200413, -122.384681135251) | |||
| 16790 | 16790 | 16509 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016661.92107 | 2098301.48789 | 37.742471221974 | -122.384991878867 | (37.742471221974, -122.384991878867) | ||
| 16852 | 16852 | 16499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016428.13466 | 2098327.93774 | 37.7425309135822 | -122.385802093385 | (37.7425309135822, -122.385802093385) | |||
| 16898 | 16898 | 2502 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016691.633780001 | 2098834.3481 | 37.743935990943996 | -122.38492625536001 | (37.743935990944, -122.38492625536) | |||
| 16981 | 16981 | 16634 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 158 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002846.26234 | 2107315.61995 | 37.7664480128774 | -122.43340627149901 | (37.7664480128774, -122.433406271499) | |||
| 17478 | 17478 | 5658 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.74795200168529 | -122.42464442051 | (37.7479520016853, -122.42464442051) | |||
| 18731 | 18731 | 5529 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 895 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 6005093.86648 | 2103161.8218799997 | 37.7551699235695 | -122.425336590916 | (37.7551699235695, -122.425336590916) | |||
| 19409 | 19409 | 16623 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | |||
| 20318 | 20318 | 5479 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 695 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 8 | 6005031.79334 | 2104320.1538400003 | 37.758346924379 | -122.42563369543801 | (37.758346924379, -122.425633695438) | |||
| 21055 | 21055 | 5523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 865 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6005084.41522 | 2103351.40166 | 37.755689931362795 | -122.425382766602 | (37.7556899313628, -122.425382766602) | |||
| 23044 | 23044 | 16540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 0 | 6016126.25571 | 2098060.8881 | 37.741780940152296 | -122.386827291768 | (37.7417809401523, -122.386827291768) | |||
| 23049 | 23049 | 14686 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 775 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 4X4 | 6005447.7824 | 2111997.5051 | 37.779450588232706 | -122.424741179621 | (37.7794505882327, -122.424741179621) | |||
| 23084 | 23084 | 16626 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | ||
| 26487 | 26487 | 189910 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.742244189916704 | -122.386410241063 | (37.7422441899167, -122.386410241063) | |||
| 35881 | 35881 | 225050 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | |||
| 50159 | 50159 | 27616 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 775 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6005483.48508 | 2112000.60744 | 37.7794611228941 | -122.424617889559 | (37.7794611228941, -122.424617889559) | |||
| 51434 | 51434 | 16506 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
| 55275 | 55275 | 189902 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | |||
| 67563 | 67563 | 14916 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017173.30591 | 2098243.5594200003 | 37.7423404352704 | -122.38321961360701 | (37.7423404352704, -122.383219613607) | |||
| 67565 | 67565 | 14919 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
| 78541 | 78541 | 14928 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
| 78897 | 78897 | 20969 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2002X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 79162 | 79162 | 20965 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2002X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 79625 | 79625 | 14913 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017225.13937 | 2098220.80076 | 37.7422808088462 | -122.383038803855 | (37.7422808088462, -122.383038803855) | |||
| 79676 | 79676 | 4925 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
| 79948 | 79948 | 16484 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 81285 | 81285 | 16511 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016438.273030001 | 2098384.37308 | 37.7426864345304 | -122.385770970205 | (37.7426864345304, -122.385770970205) | |||
| 82357 | 82357 | 2507 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
| 82455 | 82455 | 14908 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
| 82964 | 82964 | 13332 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 145 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011384.17484 | 2090567.17856 | 37.7209410845847 | -122.402697063866 | (37.7209410845847, -122.402697063866) | |||
| 83106 | 83106 | 16498 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016898.459480001 | 2098256.16023 | 37.7423598423185 | -122.38417083560499 | (37.7423598423185, -122.384170835605) | |||
| 86724 | 86724 | 14925 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
| 87292 | 87292 | 16507 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016604.68474 | 2098314.9336900003 | 37.7425049753024 | -122.385190723599 | (37.7425049753024, -122.385190723599) | |||
| 88469 | 88469 | 96756 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013661.38712 | 2096183.48051 | 37.736489188553 | -122.395218577377 | (37.736489188553, -122.395218577377) | |||
| 89283 | 89283 | 16514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016343.322430001 | 2098341.01182 | 37.7425621187056 | -122.386096262995 | (37.7425621187056, -122.386096262995) | |||
| 89437 | 89437 | 16489 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
| 89537 | 89537 | 21785 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008161.90241 | 2121549.7946200003 | 37.8058317424248 | -122.41602851933997 | (37.8058317424248, -122.41602851934) | |||
| 90964 | 90964 | 16503 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
| 91297 | 91297 | 15123 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 300 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2X2 | 6013765.88916 | 2116013.74101 | 37.7909445343765 | -122.396246681474 | (37.7909445343765, -122.396246681474) | |||
| 91802 | 91802 | 14926 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
| 92151 | 92151 | 2522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.0270005 | 2099019.0971083 | 37.744424041089395 | -122.386141087772 | (37.7444240410894, -122.386141087772) | |||
| 92209 | 92209 | 14930 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
| 92651 | 92651 | 6652 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
| 93430 | 93430 | 14909 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | |||
| 93500 | 93500 | 15124 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 300 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 2X2 | 6013752.67684 | 2116000.07901 | 37.7909062865319 | -122.396291437927 | (37.7909062865319, -122.396291437927) | |||
| 94061 | 94061 | 94895 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 94554 | 94554 | 2524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 BURKE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 12 | 3X3 | 6016449.0 | 2099041.0 | 37.7444899913278 | -122.38577963578699 | (37.7444899913278, -122.385779635787) | ||
| 94704 | 94704 | 94894 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
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");