Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104195 | 104195 | 105930 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 971 Florida St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009455.0 | 2103552.4 | 37.7564877890416 | -122.410282026926 | (37.7564877890416, -122.410282026926) | |||||
4791 | 4791 | 188467 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008105.3532300005 | 2108904.54782 | 37.77110780062 | -122.415328472924 | (37.77110780062, -122.415328472924) | |||
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) | |
9911 | 9911 | 173732 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015419.0 | 2098106.0 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | ||||
13493 | 13493 | 107151 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 215 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6013483.16907 | 2106058.28155 | 37.7635933686511 | -122.396526740817 | (37.7635933686511, -122.396526740817) | |||
14523 | 14523 | 107150 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6013483.53646 | 2106027.96623 | 37.7635101499066 | -122.396523344982 | (37.7635101499066, -122.396523344982) | |||
24342 | 24342 | 225069 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 892 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009108.56559 | 2103972.85995 | 37.75762285142989 | -122.41150982923 | (37.7576228514299, -122.41150982923) | |||
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) | |||
25692 | 25692 | 222915 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6004287.81752 | 2109130.32918 | 37.7715124442731 | -122.42854956011999 | (37.7715124442731, -122.42854956012) | |||
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) | |||
26990 | 26990 | 222896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6006441.81181 | 2107164.43854 | 37.76623623692421 | -122.420959163358 | (37.7662362369242, -122.420959163358) | |||
27662 | 27662 | 225079 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009325.524119999 | 2103958.77383 | 37.7575963412133 | -122.410758500511 | (37.7575963412133, -122.410758500511) | |||
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) | |||
28082 | 28082 | 225072 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.757351081704606 | -122.41057400910299 | (37.7573510817046, -122.410574009103) | |||
28582 | 28582 | 222901 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2500 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010350.927680001 | 2105070.60578 | 37.760706622229705 | -122.407290598708 | (37.7607066222297, -122.407290598708) | |||
30049 | 30049 | 222884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006058.1722800005 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | |||
30923 | 30923 | 188479 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010817.79084 | 2106032.71885 | 37.763374486260204 | -122.40574369103201 | (37.7633744862602, -122.405743691032) | |||
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) | |||
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) | |||
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) | |||
32351 | 32351 | 189916 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1771 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6013954.80906 | 2095907.8137599998 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | |||
32636 | 32636 | 222888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 109 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004218.0 | 2109157.0 | 37.771581724556604 | -122.428792964354 | (37.7715817245566, -122.428792964354) | |||
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) | |||
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) | |||
33594 | 33594 | 244469 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 665 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003415.8306 | 2109638.0930000003 | 37.7728572538387 | -122.43160206502701 | (37.7728572538387, -122.431602065027) | |||
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) | |||
34241 | 34241 | 125971 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6008148.4886 | 2112831.1491900003 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | |||
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) | |||
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) | |||
35349 | 35349 | 189956 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 572 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.773349868946205 | -122.403749639528 | (37.7733498689462, -122.403749639528) | |||
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) | |||
37108 | 37108 | 225085 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6004142.31119 | 2101495.14459 | 37.7505398125629 | -122.42850855554701 | (37.7505398125629, -122.428508555547) | |||
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) | |||
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) | |||
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) | |||
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) | |||
38614 | 38614 | 225070 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009108.93583 | 2103990.9837700003 | 37.757672636103 | -122.411509829221 | (37.757672636103, -122.411509829221) | |||
39568 | 39568 | 125980 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008387.31056 | 2121533.89692 | 37.8058007619722 | -122.415247331605 | (37.8058007619722, -122.415247331605) | |||
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) | |||
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) | |||
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) | |||
43078 | 43078 | 248232 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 86 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006910.04538 | 2099108.75258 | 37.744143557179896 | -122.41876827364901 | (37.7441435571799, -122.418768273649) | |||
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) | |||
45627 | 45627 | 225076 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3328 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007533.56344 | 2101516.4180900003 | 37.7507895524966 | -122.41678281788602 | (37.7507895524966, -122.416782817886) | |||
46091 | 46091 | 244452 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 411 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003668.1352 | 2109738.0991 | 37.7731461435953 | -122.430736452264 | (37.7731461435953, -122.430736452264) | |||
46617 | 46617 | 189864 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015974.53489 | 2097767.4819400003 | 37.7409669053009 | -122.387331434622 | (37.7409669053009, -122.387331434622) | |||
47121 | 47121 | 189917 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 338 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6013829.87851 | 2116068.4816 | 37.791098399616104 | -122.39602911715299 | (37.7910983996161, -122.396029117153) | |||
48972 | 48972 | 222916 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6004301.92294 | 2109033.13825 | 37.7712463798496 | -122.42849383993601 | (37.7712463798496, -122.428493839936) | |||
49414 | 49414 | 115847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003582.67693 | 2120834.7351599997 | 37.80360985246121 | -122.431824529496 | (37.8036098524612, -122.431824529496) | |||
51934 | 51934 | 225074 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3354 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007335.7626 | 2101504.20622 | 37.750744893976204 | -122.417465967185 | (37.7507448939762, -122.417465967185) | |||
52899 | 52899 | 189933 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013208.14765 | 2116234.45684 | 37.791519517964396 | -122.398191948892 | (37.7915195179644, -122.398191948892) | |||
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) | |||
53695 | 53695 | 188483 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016580.588769999 | 2098830.3730200003 | 37.7439189335051 | -122.38530995020399 | (37.7439189335051, -122.385309950204) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
60413 | 60413 | 125996 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558001 | (37.8055637294392, -122.41688295558) | |||
61155 | 61155 | 111886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | |||
62337 | 62337 | 199691 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841001 | (37.7276897308085, -122.38666058841) | |||
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) | |||
64383 | 64383 | 248208 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 37 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007034.71089 | 2099281.8609599997 | 37.744625892375396 | -122.41834947827101 | (37.7446258923754, -122.418349478271) | |||
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) | |||
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) | |||
65182 | 65182 | 222899 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6005393.47694 | 2104277.7089299997 | 37.7582508111316 | -122.424379813902 | (37.7582508111316, -122.424379813902) | |||
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) | |||
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) | |||
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) | |||
67512 | 67512 | 225043 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 463 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008911.67409 | 2096164.66425 | 37.7361722309519 | -122.411639081583 | (37.7361722309519, -122.411639081583) | |||
67983 | 67983 | 225046 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 901 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009412.500080001 | 2103884.6672799997 | 37.757397737644204 | -122.41045246843001 | (37.7573977376442, -122.41045246843) | |||
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) | |||
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) | |||
68963 | 68963 | 199693 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016099.1110000005 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | |||
69332 | 69332 | 225073 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 904 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009377.25257 | 2103854.7897900003 | 37.757313724754795 | -122.410572259011 | (37.7573137247548, -122.410572259011) | |||
70040 | 70040 | 248206 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 39 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007021.99675 | 2099262.74695 | 37.744572693881395 | -122.41839208633999 | (37.7445726938814, -122.41839208634) | |||
71480 | 71480 | 125970 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2301 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6003734.22562 | 2115934.13704 | 37.7901626613254 | -122.430950126753 | (37.7901626613254, -122.430950126753) | |||
71841 | 71841 | 225048 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2823 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009293.07164 | 2103911.54746 | 37.757464848636204 | -122.410867399417 | (37.7574648486362, -122.410867399417) | |||
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) | |||
72501 | 72501 | 225044 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007468.43971 | 2099454.94472 | 37.7451255476034 | -122.4168619861 | (37.7451255476034, -122.4168619861) | |||
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) | |||
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) | |||
73397 | 73397 | 246510 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | |||
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) | |||
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) | |||
75782 | 75782 | 189964 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 287 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010268.27805 | 2111003.99646 | 37.7769937249279 | -122.407994884783 | (37.7769937249279, -122.407994884783) | |||
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) | |||
76853 | 76853 | 225071 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009374.803830001 | 2103883.5621599997 | 37.7573925899019 | -122.410582759505 | (37.7573925899019, -122.410582759505) | |||
79181 | 79181 | 115360 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 205 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 6012944.0 | 2106057.0 | 37.763559829435295 | -122.39839147938801 | (37.7635598294353, -122.398391479388) | ||||
81394 | 81394 | 103339 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
91314 | 91314 | 104633 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 850 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6009360.0 | 2104224.0 | 37.7583265252915 | -122.41065799814301 | (37.7583265252915, -122.410657998143) | |||
92531 | 92531 | 105449 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | |||||
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) | ||||
100325 | 100325 | 189958 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 562 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010386.6969099995 | 2108550.07878 | 37.7702624648584 | -122.407412194212 | (37.7702624648584, -122.407412194212) | |||
100386 | 100386 | 115557 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2500x 19TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010357.0 | 2105131.0 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | ||||
102430 | 102430 | 96852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1x Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007194.0 | 2097789.0 | 37.7405357947447 | -122.417692894396 | (37.7405357947447, -122.417692894396) | |||
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) |
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");