Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 188116 | 188116 | 222897 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2771 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009509.00989 | 2103333.0296099996 | 37.7558884746751 | -122.41007975427 | (37.7558884746751, -122.41007975427) | |||
| 185909 | 185909 | 57320 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2728 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 15 | Permit Number 16145 | 5999531.6355 | 2114001.5838 | 37.7846173544843 | -122.445351698652 | (37.7846173544843, -122.445351698652) | ||
| 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) | |||
| 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) | |||
| 184467 | 184467 | 140578 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 949 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003397.0361 | 2111670.2009 | 37.778435854356104 | -122.431812198827 | (37.7784358543561, -122.431812198827) | |||
| 184225 | 184225 | 222889 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 81 Webster St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6004268.7476699995 | 2108942.84192 | 37.7709965706599 | -122.428602156987 | (37.7709965706599, -122.428602156987) | |||
| 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) | |||
| 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) | |||
| 182826 | 182826 | 225078 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6009189.802619999 | 2103948.11037 | 37.7575594510339 | -122.41122712912599 | (37.7575594510339, -122.411227129126) | |||
| 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) | |||
| 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) | |||
| 180519 | 180519 | 225100 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 75 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6006056.75092 | 2109200.3154 | 37.7718045566698 | -122.422435689168 | (37.7718045566698, -122.422435689168) | |||
| 179431 | 179431 | 189853 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.742069463331106 | -122.382594511142 | (37.7420694633311, -122.382594511142) | |||
| 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) | |||
| 179078 | 179078 | 222900 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005413.47026 | 2104278.82733 | 37.758255010975105 | -122.424310747749 | (37.7582550109751, -122.424310747749) | |||
| 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) | |||
| 178399 | 178399 | 222892 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2751 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6009588.6552 | 2103924.1994 | 37.757516157658294 | -122.40984604206899 | (37.7575161576583, -122.409846042069) | |||
| 178393 | 178393 | 225075 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3334 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007507.05129 | 2101513.0888099996 | 37.750778919809 | -122.416874263658 | (37.750778919809, -122.416874263658) | |||
| 178093 | 178093 | 189926 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013338.6063 | 2116192.95214 | 37.7914128215027 | -122.39773764826799 | (37.7914128215027, -122.397737648268) | |||
| 177476 | 177476 | 32581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1314 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37055 | 5985876.1437 | 2106257.7648 | 37.762566049362704 | -122.492024105228 | (37.7625660493627, -122.492024105228) | |
| 177140 | 177140 | 225077 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2862 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6009020.65891 | 2103938.13075 | 37.7575225617285 | -122.411811393486 | (37.7575225617285, -122.411811393486) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 175928 | 175928 | 125977 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008401.628880001 | 2121444.29683 | 37.8055555474172 | -122.415191434251 | (37.8055555474172, -122.415191434251) | |||
| 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) | |||
| 174828 | 174828 | 125988 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008319.39655 | 2121673.00017 | 37.806178887323 | -122.41549221341101 | (37.806178887323, -122.415492213411) | |||
| 174686 | 174686 | 199696 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | |||
| 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) | |||
| 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) | |||
| 174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
| 174264 | 174264 | 115842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6003573.215530001 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | |||
| 170749 | 170749 | 189944 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014676.15778 | 2116259.76194 | 37.791670658917106 | -122.393114386531 | (37.7916706589171, -122.393114386531) | |||
| 170271 | 170271 | 225047 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 971 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6009431.366330001 | 2103539.27108 | 37.7564504151646 | -122.410362833886 | (37.7564504151646, -122.410362833886) | |||
| 169707 | 169707 | 57317 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.44509387174801 | (37.7846624482509, -122.445093871748) | ||
| 169467 | 169467 | 189954 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 145 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | |||
| 169210 | 169210 | 52724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 160@ HOWARD Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 7 | Permit Number 48777 | 6014638.31432 | 2116297.63809 | 37.791772555711 | -122.393247977227 | (37.791772555711, -122.393247977227) | ||
| 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) | |||
| 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) | |||
| 166502 | 166502 | 61685 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.730421490047604 | -122.39436277503201 | (37.7304214900476, -122.394362775032) | |
| 165480 | 165480 | 189901 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6016452.46192 | 2098385.2163400003 | 37.742689535099395 | -122.385721967406 | (37.7426895350994, -122.385721967406) | |||
| 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) | |||
| 165346 | 165346 | 85254 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 49553 | 6013520.55509 | 2116003.76772 | 37.7909034958536 | -122.39709483357201 | (37.7909034958536, -122.397094833572) | |||
| 164903 | 164903 | 201371 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Hare St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6018297.03999 | 2095334.9344400002 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) | ||||
| 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) | |||
| 163980 | 163980 | 222890 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009529.18788 | 2103922.9580599996 | 37.757509416346004 | -122.4100516172 | (37.757509416346, -122.4100516172) | |||
| 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) | |||
| 162374 | 162374 | 222904 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004715.38798 | 2109818.79814 | 37.7734270001802 | -122.427119616485 | (37.7734270001802, -122.427119616485) | |||
| 161723 | 161723 | 222917 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 88 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6004303.69708 | 2109018.65394 | 37.7712067098536 | -122.42848667052799 | (37.7712067098536, -122.428486670528) | |||
| 158717 | 158717 | 61724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.39430169937599 | (37.7307052783181, -122.394301699376) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 155166 | 155166 | 40183 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 298X Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1999 12:00:00 AM | 11 | Permit Number 41371 | 6013446.24914 | 2105734.66956 | 37.7627027466551 | -122.39663174926001 | (37.7627027466551, -122.39663174926) | ||
| 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) | |||
| 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) | |||
| 154115 | 154115 | 32473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 144 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 9 | Permit Number 36981 | 6000263.910540001 | 2106227.11632 | 37.763312407875205 | -122.442259981907 | (37.7633124078752, -122.442259981907) | |
| 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) | |||
| 153632 | 153632 | 189965 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 185 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009800.496830001 | 2111495.15523 | 37.77831613031871 | -122.40964776673701 | (37.7783161303187, -122.409647766737) | |||
| 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) | |||
| 150575 | 150575 | 56925 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | ||
| 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) | |||
| 149127 | 149127 | 222891 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2759 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009566.16928 | 2103923.0216900003 | 37.7575116637409 | -122.40992372461399 | (37.7575116637409, -122.409923724614) | |||
| 145872 | 145872 | 63270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23827 | 6007494.42657363 | 2099465.13084364 | 37.7451549781049 | -122.41677284932 | (37.7451549781049, -122.41677284932) | ||
| 145698 | 145698 | 106032 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||||
| 145409 | 145409 | 60263 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/1984 12:00:00 AM | Permit Number 19819 | 6009497.44754454 | 2103916.17692673 | 37.757489017835496 | -122.410160909746 | (37.7574890178355, -122.410160909746) | ||
| 144535 | 144535 | 63125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 80 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23639 | 6007006.19001516 | 2099063.67894521 | 37.744025207978 | -122.418432630519 | (37.744025207978, -122.418432630519) | ||
| 144112 | 144112 | 113692 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6006814.0 | 2098928.0 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | |||
| 143717 | 143717 | 63120 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 46 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23631 | 6007008.06371762 | 2099307.94192573 | 37.7446960047915 | -122.418443468102 | (37.7446960047915, -122.418443468102) | ||
| 143125 | 143125 | 201373 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018334.732369999 | 2095383.1099099999 | 37.7345503216464 | -122.379005098324 | (37.7345503216464, -122.379005098324) | ||||
| 142476 | 142476 | 68375 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 175 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32198 | 5997884.42699251 | 2106160.35589629 | 37.76299319850379 | -122.45048498278999 | (37.7629931985038, -122.45048498279) | ||
| 142139 | 142139 | 33711 | 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 | Permit Number 37779 | 6003691.57039211 | 2108804.29883955 | 37.7705834843276 | -122.430588742236 | (37.7705834843276, -122.430588742236) | |||
| 141489 | 141489 | 96123 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767774 | 6004920.8 | 2095965.5 | 37.735400693790204 | -122.42542300740601 | (37.7354006937902, -122.425423007406) | |
| 140677 | 140677 | 56842 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 910 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | 3 | Permit Number 30536 | 5998759.08975741 | 2106864.1829233 | 37.76497575295679 | -122.447510501506 | (37.7649757529568, -122.447510501506) | |
| 140595 | 140595 | 61796 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 60 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/1985 12:00:00 AM | Permit Number 21819 | 6002883.06164476 | 2108748.24537279 | 37.7703837393735 | -122.43338137366399 | (37.7703837393735, -122.433381373664) | ||
| 140440 | 140440 | 34010 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 123 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1997 12:00:00 AM | Permit Number 37945 | 6002886.66979468 | 2107551.69377695 | 37.7670985064042 | -122.43328338001899 | (37.7670985064042, -122.433283380019) | |||
| 140142 | 140142 | 2505 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1501 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067003 | 37.743747386445996 | -122.384952066789 | (37.743747386446, -122.384952066789) | |||
| 138765 | 138765 | 16490 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | |||
| 138411 | 138411 | 63122 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 42 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1993 12:00:00 AM | Permit Number 32290 | 6007020.23858667 | 2099330.24637666 | 37.7447579331798 | -122.41840295087499 | (37.7447579331798, -122.418402950875) | ||
| 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) | |||
| 137538 | 137538 | 222914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6004276.58953 | 2109191.75922 | 37.7716804808011 | -122.428592777936 | (37.7716804808011, -122.428592777936) | |||
| 137523 | 137523 | 65609 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 259 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 12 | Permit Number 28514 | 6005079.93888 | 2093817.0268700002 | 37.7295104552453 | -122.42472001303801 | (37.7295104552453, -122.424720013038) | |
| 137044 | 137044 | 125972 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006913.21617 | 2121857.59743 | 37.806606605779294 | -122.42037165782601 | (37.8066066057793, -122.420371657826) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 132365 | 132365 | 189887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.742489792067104 | -122.384133016442 | (37.7424897920671, -122.384133016442) | |||
| 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) | |||
| 132013 | 132013 | 189839 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.38356026519699 | (37.7422631836031, -122.383560265197) | |||
| 131650 | 131650 | 32421 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 12 | Permit Number 36948 | 6000917.26502 | 2096711.2312599998 | 37.7372212865363 | -122.439318125938 | (37.7372212865363, -122.439318125938) | ||
| 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) | |||
| 130879 | 130879 | 225068 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 900 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009114.1902 | 2103856.87983 | 37.757304711760604 | -122.41148218316299 | (37.7573047117606, -122.411482183163) | |||
| 130030 | 130030 | 222903 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 164 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009951.59256 | 2100103.1565099997 | 37.747044755713205 | -122.408321349458 | (37.7470447557132, -122.408321349458) | |||
| 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) | |||
| 129421 | 129421 | 47061 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 114 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 3x3 | Permit Number 45048 | 6004275.94265243 | 2109216.94695979 | 37.7717496035942 | -122.428596811267 | (37.7717496035942, -122.428596811267) |
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");