Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187769 | 187769 | 122180 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 100 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5991527.0848 | 2114155.02215 | 37.784578471021 | -122.47305567737601 | (37.784578471021, -122.473055677376) | |||
| 187763 | 187763 | 224197 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005251.17489 | 2097047.32393 | 37.738389799949104 | -122.424357697761 | (37.7383897999491, -122.424357697761) | ||||
| 187524 | 187524 | 224449 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1201 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004503.55801 | 2096138.79869 | 37.73585295005579 | -122.426877907491 | (37.7358529500558, -122.426877907491) | ||||
| 185691 | 185691 | 217802 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5991046.80022 | 2095992.48375 | 37.734681145124505 | -122.47339209648001 | (37.7346811451245, -122.47339209648) | ||||
| 185034 | 185034 | 176332 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 40 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009122.37089 | 2089940.9339 | 37.7190950046208 | -122.410471276831 | (37.7190950046208, -122.410471276831) | |||
| 184493 | 184493 | 176301 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011617.09806 | 2090687.60598 | 37.7212847557703 | -122.40190037442899 | (37.7212847557703, -122.401900374429) | |||
| 184281 | 184281 | 199402 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016663.61896 | 2095979.5906099998 | 37.736095855134394 | -122.384824290234 | (37.7360958551344, -122.384824290234) | ||||
| 183209 | 183209 | 176298 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6011748.91192 | 2090731.5823400002 | 37.7214128614948 | -122.40144781756399 | (37.7214128614948, -122.401447817564) | |||
| 182619 | 182619 | 187037 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984959.5362 | 2097794.0341 | 37.7392733453171 | -122.49457029390899 | (37.7392733453171, -122.494570293909) | |||
| 182451 | 182451 | 247096 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2301 Castro St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6002729.450119999 | 2098626.9887200003 | 37.7425844735833 | -122.433189422459 | (37.7425844735833, -122.433189422459) | ||||
| 182351 | 182351 | 181588 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1227 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5984569.5881 | 2106811.9615 | 37.764011258359105 | -122.496583837339 | (37.7640112583591, -122.496583837339) | |||
| 180472 | 180472 | 199409 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 822 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6015943.979280001 | 2096692.6549900002 | 37.738013957089 | -122.387362125771 | (37.738013957089, -122.387362125771) | |||
| 179665 | 179665 | 139099 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2600 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999616.6518 | 2113666.4004 | 37.7837018805543 | -122.44503346736401 | (37.7837018805543, -122.445033467364) | |||
| 178932 | 178932 | 176320 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6009693.65645 | 2090109.67926 | 37.7195903547889 | -122.408508450717 | (37.7195903547889, -122.408508450717) | |||
| 178126 | 178126 | 224454 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 4090 20th St | 6 | : Yard 23 | Tree 1 | Private 1 | 12 | Width 3ft | 6003124.6046 | 2104168.08557 | 37.7578214298263 | -122.432218730236 | (37.7578214298263, -122.432218730236) | |||
| 177574 | 177574 | 191717 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 554 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 6ft | 6011757.49983 | 2105782.3491 | 37.762739532526005 | -122.40247591803801 | (37.762739532526, -122.402475918038) | |||
| 177490 | 177490 | 176319 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6009753.29629 | 2090123.38013 | 37.7196313144016 | -122.40830326229602 | (37.7196313144016, -122.408303262296) | |||
| 175024 | 175024 | 224211 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005190.349119999 | 2097382.93272 | 37.739307871065996 | -122.424591870417 | (37.739307871066, -122.424591870417) | ||||
| 174476 | 174476 | 176315 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | Width 0ft | 6010056.94301 | 2090202.23729 | 37.7198648386596 | -122.40725921596399 | (37.7198648386596, -122.407259215964) | |||
| 170536 | 170536 | 32593 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.158172799 | 2105866.8789552 | 37.7614725555795 | -122.49319192882099 | (37.7614725555795, -122.493191928821) | |
| 169095 | 169095 | 199401 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6016684.16305 | 2095970.28806 | 37.7360714484387 | -122.38475261246799 | (37.7360714484387, -122.384752612468) | ||||
| 166853 | 166853 | 176331 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 6009160.31915 | 2089943.1989099998 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | |||
| 166595 | 166595 | 224209 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) | ||||
| 166378 | 166378 | 224204 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003450.74753 | 2095594.0107 | 37.734297501527294 | -122.430479027684 | (37.7342975015273, -122.430479027684) | ||||
| 166229 | 166229 | 183716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1231 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5984571.0948 | 2106790.8677 | 37.7639534289968 | -122.49657706948 | (37.7639534289968, -122.49657706948) | |||
| 166075 | 166075 | 113501 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3x3 | 6011166.56458 | 2090559.11661 | 37.720906795881795 | -122.403448714702 | (37.7209067958818, -122.403448714702) | |||
| 165999 | 165999 | 199400 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 299 Cashmere St | 16 | : 4 | Tree 1 | Private 1 | 38 | 6016698.52819 | 2095954.85127 | 37.7360298565815 | -122.384701870897 | (37.7360298565815, -122.384701870897) | ||||
| 165342 | 165342 | 62644 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1255 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50627 | 5983022.3246657 | 2106594.48040873 | 37.763323345885404 | -122.50191918393699 | (37.7633233458854, -122.501919183937) | |
| 164248 | 164248 | 122943 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 300 09th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5993109.61739 | 2113257.70524 | 37.7822061800557 | -122.467515420271 | (37.7822061800557, -122.467515420271) | |||
| 162770 | 162770 | 176300 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011702.065830001 | 2090731.87272 | 37.7214110448664 | -122.401609772869 | (37.7214110448664, -122.401609772869) | |||
| 161898 | 161898 | 199408 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 5 Cashmere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6017196.63462 | 2095827.84715 | 37.7357086637323 | -122.38297086303801 | (37.7357086637323, -122.382970863038) | |||
| 161690 | 161690 | 199406 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301x Cashmere St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016219.39095 | 2096203.7669400002 | 37.7366868185504 | -122.38637580600599 | (37.7366868185504, -122.386375806006) | ||||
| 161444 | 161444 | 176333 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 12x Canyon Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6002752.1139 | 2086168.71447 | 37.708378134509296 | -122.43222153339899 | (37.7083781345093, -122.432221533399) | |||
| 161257 | 161257 | 176304 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6011109.46654 | 2090529.17456 | 37.7208213917675 | -122.403643980895 | (37.7208213917675, -122.403643980895) | |||
| 160277 | 160277 | 66846 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 25 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 14 | Permit Number 30150 | 5998189.80412132 | 2110576.56755949 | 37.7751364632784 | -122.449747058625 | (37.7751364632784, -122.449747058625) | |
| 159855 | 159855 | 224200 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6003533.27125 | 2095632.5118900002 | 37.7344078915187 | -122.430196462512 | (37.7344078915187, -122.430196462512) | ||||
| 159794 | 159794 | 218792 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1259 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995767.3383 | 2106956.01161 | 37.7650564658073 | -122.457864799536 | (37.7650564658073, -122.457864799536) | |||
| 159148 | 159148 | 224215 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005165.86979 | 2097298.42463 | 37.739074448424 | -122.424670499065 | (37.739074448424, -122.424670499065) | ||||
| 158945 | 158945 | 176305 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6010925.6651800005 | 2090483.18833 | 37.7206848540134 | -122.404276094583 | (37.7206848540134, -122.404276094583) | |||
| 158228 | 158228 | 176328 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009200.77281 | 2089956.05158 | 37.7191409096134 | -122.41020133724899 | (37.7191409096134, -122.410201337249) | |||
| 158093 | 158093 | 224205 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005328.89296 | 2097313.9887099997 | 37.7391263896815 | -122.424107945232 | (37.7391263896815, -122.424107945232) | ||||
| 156780 | 156780 | 199403 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016641.57283 | 2096000.10584 | 37.7361509664773 | -122.384901942178 | (37.7361509664773, -122.384901942178) | ||||
| 156596 | 156596 | 176329 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009197.90265 | 2089964.9760099999 | 37.719165253359 | -122.41021188808399 | (37.719165253359, -122.410211888084) | |||
| 156289 | 156289 | 54758 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 324 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1972 12:00:00 AM | 8 | Permit Number 10607 | 6012398.45595 | 2086740.4083099999 | 37.710490116783 | -122.39892252845699 | (37.710490116783, -122.398922528457) | ||
| 153553 | 153553 | 176310 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6010469.51848 | 2090335.25755 | 37.720253166839704 | -122.40584244467199 | (37.7202531668397, -122.405842444672) | |||
| 152213 | 152213 | 176314 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | Width 0ft | 6010185.666130001 | 2090251.18564 | 37.720006444117296 | -122.406817710885 | (37.7200064441173, -122.406817710885) | |||
| 152160 | 152160 | 51577 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2005 12:00:00 AM | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | |
| 152100 | 152100 | 176311 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6010356.570719999 | 2090296.4274 | 37.7201402299675 | -122.40623013522499 | (37.7201402299675, -122.406230135225) | |||
| 151415 | 151415 | 224206 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6005333.6743 | 2097319.7623400004 | 37.739142512726396 | -122.424091823995 | (37.7391425127264, -122.424091823995) | ||||
| 147712 | 147712 | 224218 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 60 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6007258.1885 | 2099113.30571 | 37.744175654874894 | -122.417564790989 | (37.7441756548749, -122.417564790989) | |||
| 147460 | 147460 | 217803 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5991018.47185 | 2095992.29774 | 37.734678993934494 | -122.473490022742 | (37.7346789939345, -122.473490022742) | ||||
| 146203 | 146203 | 17258 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 21 Osceola Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017303.8717551 | 2094261.0040323 | 37.731412347585 | -122.382491114922 | (37.731412347585, -122.382491114922) | |||
| 146098 | 146098 | 11297 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 146070 | 146070 | 121081 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 5 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
| 145561 | 145561 | 105665 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 317X DORADO TER | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 24 | 5994307.4 | 2093021.4 | 37.7267115488018 | -122.461903806308 | (37.7267115488018, -122.461903806308) | ||||
| 145422 | 145422 | 61359 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | ||
| 145362 | 145362 | 12002 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 145237 | 145237 | 65550 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 292 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1990 12:00:00 AM | Permit Number 28449 | 5995404.07668865 | 2097513.82279858 | 37.7391097231572 | -122.458437696075 | (37.7391097231572, -122.458437696075) | ||
| 145223 | 145223 | 9286 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 13X George Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017208.549763201 | 2094048.0250586998 | 37.7308222832509 | -122.38280584856301 | (37.7308222832509, -122.382805848563) | |||
| 144910 | 144910 | 113889 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 90 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 144684 | 144684 | 99975 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2295 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||||
| 144616 | 144616 | 11301 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 144607 | 144607 | 17283 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 85 OSCEOLA LN | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016889.0 | 2094526.0 | 37.7321170477455 | -122.383943863813 | (37.7321170477455, -122.383943863813) | |||
| 144476 | 144476 | 64980 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 50 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/1989 12:00:00 AM | Permit Number 26018 | 6005559.62367556 | 2099364.11059581 | 37.744768585112 | -122.42345589064699 | (37.744768585112, -122.423455890647) | ||
| 144319 | 144319 | 63123 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 44 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1986 12:00:00 AM | Permit Number 23636 | 6007712.34207152 | 2099218.71581656 | 37.7444906318459 | -122.416001886054 | (37.7444906318459, -122.416001886054) | ||
| 143876 | 143876 | 111238 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 48X OAKHURST LN | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994967.0 | 2104000.0 | 37.7568940069608 | -122.460418748436 | (37.7568940069608, -122.460418748436) | ||||
| 143754 | 143754 | 26776 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 800X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 143608 | 143608 | 94382 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
| 143548 | 143548 | 53071 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 530@ CAPITOL Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | ||
| 143481 | 143481 | 11367 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 143352 | 143352 | 32991 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 143010 | 143010 | 112970 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1409 MCKINNON AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016184.0 | 2095282.0 | 37.734153872922896 | -122.386433919032 | (37.7341538729229, -122.386433919032) | |||||
| 142936 | 142936 | 55768 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 64 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2006 12:00:00 AM | Permit Number 48893 | 6004070.72244185 | 2102685.02755706 | 37.7538029009663 | -122.428840933443 | (37.7538029009663, -122.428840933443) | ||
| 142893 | 142893 | 32990 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 142804 | 142804 | 32992 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 142725 | 142725 | 112581 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 274X SAN MARCOS AVE | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 3x20 | 5993121.0 | 2100271.0 | 37.7465487656332 | -122.46653182115801 | (37.7465487656332, -122.466531821158) | ||||
| 142547 | 142547 | 11333 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1279 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
| 142109 | 142109 | 110178 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 321 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | ||||
| 141990 | 141990 | 61657 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 162 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21649 | 5993073.36079419 | 2114411.6730158003 | 37.785372566948 | -122.467724802862 | (37.785372566948, -122.467724802862) | ||
| 141942 | 141942 | 10770 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1120X Hudson Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 141939 | 141939 | 12073 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1225X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.38243353641701 | (37.7317765554235, -122.382433536417) | |||
| 141868 | 141868 | 106586 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 141855 | 141855 | 10769 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1120X Hudson Ave | 41 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 141625 | 141625 | 17271 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 50 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017109.92307 | 2094398.1173900003 | 37.7317781181305 | -122.383171178612 | (37.7317781181305, -122.383171178612) | |||
| 141529 | 141529 | 11270 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/1990 12:00:00 AM | 24 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 141235 | 141235 | 17284 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 90 Osceola Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016930.7708615 | 2094565.5402988999 | 37.7322279266876 | -122.383802203384 | (37.7322279266876, -122.383802203384) | |||
| 141186 | 141186 | 61435 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 327 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | 26 | Permit Number 21367 | 5999764.1184147 | 2104644.81954389 | 37.7589393153031 | -122.44387490382499 | (37.7589393153031, -122.443874903825) | |
| 141175 | 141175 | 61115 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1106 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | Permit Number 20962 | 6007608.55332469 | 2103202.26724843 | 37.7554227286129 | -122.416642908427 | (37.7554227286129, -122.416642908427) | ||
| 140949 | 140949 | 107852 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 150 APTOS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | ||||
| 140923 | 140923 | 11637 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 499X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 140915 | 140915 | 109851 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3250x 22ND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6006518.0 | 2103190.0 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | |||
| 140881 | 140881 | 107539 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 198X JENNINGS ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6018784.0 | 2097136.0 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | |||||
| 140807 | 140807 | 65605 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 138 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | Permit Number 28509 | 6004309.62922812 | 2093740.61229591 | 37.7292571013758 | -122.427377609436 | (37.7292571013758, -122.427377609436) | ||
| 140157 | 140157 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 140115 | 140115 | 11346 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 139868 | 139868 | 52193 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2050x Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1982 12:00:00 AM | 14 | Permit Number 48383 | 6003893.10220549 | 2115458.97047215 | 37.788866975157205 | -122.430366510079 | (37.7888669751572, -122.430366510079) | |
| 139769 | 139769 | 63699 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1536 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1987 12:00:00 AM | Permit Number 24357 | 5993400.20760956 | 2105023.79114259 | 37.7596148153145 | -122.465911644507 | (37.7596148153145, -122.465911644507) | ||
| 139722 | 139722 | 68255 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 235 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32060 | 6009537.98073102 | 2093299.04188101 | 37.7283389564803 | -122.409271515047 | (37.7283389564803, -122.409271515047) | ||
| 139675 | 139675 | 24063 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
| 139637 | 139637 | 11293 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) |
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");