Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58 | 58 | 4749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.805773032263296 | -122.41826116482599 | (37.8057730322633, -122.418261164826) | ||
| 670 | 670 | 13108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.80087277869679 | -122.427090735634 | (37.8008727786968, -122.427090735634) | |||
| 1261 | 1261 | 122608 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1214 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987092.2626 | 2106978.1702 | 37.7646150951119 | -122.487870979055 | (37.7646150951119, -122.487870979055) | |||
| 1523 | 1523 | 142666 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2310 MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6008911.1908 | 2121214.7045 | 37.8049537680909 | -122.413411770849 | (37.8049537680909, -122.413411770849) | |||
| 1682 | 1682 | 120803 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 711 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 2ft | 5989721.4593400005 | 2110495.24706 | 37.774425041585296 | -122.479034671677 | (37.7744250415853, -122.479034671677) | ||
| 1814 | 1814 | 105384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2853 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x3 | 5999429.08796 | 2117689.0147700002 | 37.794736216656794 | -122.445971784396 | (37.7947362166568, -122.445971784396) | |||
| 2081 | 2081 | 252873 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Broderick St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
| 2107 | 2107 | 250672 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5986349.68151 | 2114864.86182 | 37.786226371002705 | -122.491019750162 | (37.7862263710027, -122.491019750162) | |||
| 2120 | 2120 | 110253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6000252.5201 | 2113528.9926 | 37.783360865552396 | -122.442823740221 | (37.7833608655524, -122.442823740221) | |||
| 2121 | 2121 | 79286 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2001 12:00:00 AM | 15 | 3x3 | 6000254.8822 | 2113507.7337 | 37.7833026287552 | -122.442814041263 | (37.7833026287552, -122.442814041263) | ||
| 2194 | 2194 | 23455 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6005973.83981 | 2118127.35599 | 37.796311335142995 | -122.423357203778 | (37.796311335143, -122.423357203778) | |||
| 2211 | 2211 | 188595 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/05/2017 12:00:00 AM | 3 | Width 7ft | 6011997.611930001 | 2102271.8897 | 37.7531139870419 | -122.401398733477 | (37.7531139870419, -122.401398733477) | ||
| 2239 | 2239 | 203945 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2579 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991715.80084 | 2097896.7211700003 | 37.7399484158804 | -122.471217847832 | (37.7399484158804, -122.471217847832) | |||
| 2248 | 2248 | 125016 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3399X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001832.0 | 2119600.0 | 37.800120199825 | -122.437794333712 | (37.800120199825, -122.437794333712) | |||
| 2354 | 2354 | 18870 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003913.0 | 2115924.0 | 37.790144955549394 | -122.430330857904 | (37.7901449555494, -122.430330857904) | |||
| 2379 | 2379 | 17840 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2017 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004165.4355 | 2115291.4590000003 | 37.7884224532463 | -122.429412324105 | (37.7884224532463, -122.429412324105) | |||
| 2463 | 2463 | 106683 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 125 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6x300 | 5996555.44655 | 2115800.39633 | 37.789386070660704 | -122.45577832652201 | (37.7893860706607, -122.455778326522) | |||
| 2746 | 2746 | 181806 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5986469.7425 | 2099569.8124 | 37.7442374331929 | -122.489479287744 | (37.7442374331929, -122.489479287744) | |||
| 2777 | 2777 | 253179 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 201x Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||||
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2895 | 2895 | 114573 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997465.48926 | 2115720.33673 | 37.7892184334409 | -122.452623918478 | (37.7892184334409, -122.452623918478) | |||
| 2994 | 2994 | 142170 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1477 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000804.7229 | 2110664.0211 | 37.7755258488103 | -122.440707770392 | (37.7755258488103, -122.440707770392) | |||
| 3360 | 3360 | 124968 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2822 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2017 12:00:00 AM | 3 | Width 3ft | 6001569.39846 | 2118152.80963 | 37.7961316595979 | -122.438599283427 | (37.7961316595979, -122.438599283427) | ||
| 3621 | 3621 | 249566 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005942.163819999 | 2114329.62673 | 37.7858819315591 | -122.42319672154899 | (37.7858819315591, -122.423196721549) | |||
| 3689 | 3689 | 252876 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Baker St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000422.0 | 2113928.0 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | ||||
| 3694 | 3694 | 252874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
| 3756 | 3756 | 252875 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Post St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000387.0 | 2114050.0 | 37.784799083264396 | -122.44239591065 | (37.7847990832644, -122.44239591065) | ||||
| 3817 | 3817 | 253560 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5992829.16774 | 2099990.2564 | 37.7457610706327 | -122.46752052447701 | (37.7457610706327, -122.467520524477) | ||||
| 3851 | 3851 | 252871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2557 Sutter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5999847.0 | 2113975.0 | 37.7845623594454 | -122.444258736096 | (37.7845623594454, -122.444258736096) | |||||
| 3860 | 3860 | 30022 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1659 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2016 10:15:00 AM | 3 | 3x3 | 5998115.9942 | 2108549.9942 | 37.76956778996521 | -122.449856300055 | (37.7695677899652, -122.449856300055) | ||
| 3914 | 3914 | 23457 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6005866.883230001 | 2118164.3475 | 37.7964068674367 | -122.42372992781901 | (37.7964068674367, -122.423729927819) | |||
| 4010 | 4010 | 253604 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5997729.0 | 2098564.0 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | ||||
| 4105 | 4105 | 253605 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 301 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5997753.0 | 2098469.0 | 37.741867117319 | -122.45038506263799 | (37.741867117319, -122.450385062638) | ||||
| 4264 | 4264 | 107589 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000110.02976 | 2118059.62225 | 37.7957926664564 | -122.443642277677 | (37.7957926664564, -122.443642277677) | |||
| 4480 | 4480 | 220292 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X 21st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6007965.909 | 2103878.5060799997 | 37.757299618008396 | -122.415454932923 | (37.7572996180084, -122.415454932923) | |||
| 4510 | 4510 | 220293 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6008143.26275 | 2103888.31143 | 37.757336508186896 | -122.41484226615201 | (37.7573365081869, -122.414842266152) | |||
| 4534 | 4534 | 141427 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 306 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6005914.5406 | 2110724.5553 | 37.7759817285641 | -122.423035961371 | (37.7759817285641, -122.423035961371) | ||||
| 5136 | 5136 | 119617 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3536 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2016 12:00:00 AM | 3 | 3x10 | 5999214.99092 | 2121000.37655 | 37.8038161003064 | -122.446950987796 | (37.8038161003064, -122.446950987796) | ||
| 5181 | 5181 | 253819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100x Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001057.0 | 2086858.0 | 37.71017450293179 | -122.43812937571998 | (37.7101745029318, -122.43812937572) | |||||
| 5759 | 5759 | 114574 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5997452.80117 | 2115716.84337 | 37.7892081146058 | -122.45266756527201 | (37.7892081146058, -122.452667565272) | |||
| 5765 | 5765 | 23561 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | |||
| 5827 | 5827 | 120505 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5999789.0039 | 2116358.84365 | 37.7911044628415 | -122.44463077918199 | (37.7911044628415, -122.444630779182) | |||
| 6067 | 6067 | 114090 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2835 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001183.088719999 | 2115909.2328 | 37.7899493996846 | -122.43977505527701 | (37.7899493996846, -122.439775055277) | ||||
| 6287 | 6287 | 102623 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.80420514282329 | -122.40911005673401 | (37.8042051428233, -122.409110056734) | |||
| 6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
| 6449 | 6449 | 7072 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1652 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999508.2617 | 2109836.0506 | 37.7731785369509 | -122.44513298700899 | (37.7731785369509, -122.445132987009) | |||
| 6476 | 6476 | 13064 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6009534.3118 | 2120532.6199 | 37.8031159000828 | -122.411207170734 | (37.8031159000828, -122.411207170734) | |||
| 6550 | 6550 | 114575 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3621 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997436.353519999 | 2115714.9226900004 | 37.789201898491704 | -122.452724333156 | (37.7892018984917, -122.452724333156) | |||
| 6625 | 6625 | 9932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005031.67767 | 2117702.0644 | 37.795090373265296 | -122.42658698402501 | (37.7950903732653, -122.426586984025) | |||
| 6667 | 6667 | 17874 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2158 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003619.9977 | 2115267.4707 | 37.7883256917387 | -122.4312977384 | (37.7883256917387, -122.4312977384) | |||
| 7234 | 7234 | 113746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009590.33174 | 2118455.97825 | 37.7974170965836 | -122.410866557642 | (37.7974170965836, -122.410866557642) | ||||
| 7235 | 7235 | 120506 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3001X Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999798.014359999 | 2116362.9569200003 | 37.791116270957 | -122.444599899165 | (37.791116270957, -122.444599899165) | |||
| 7274 | 7274 | 112384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3080 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 6x6 | 5999474.64167 | 2116368.74438 | 37.791113704275 | -122.445719170201 | (37.791113704275, -122.445719170201) | |||
| 7305 | 7305 | 7157 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6003511.3637 | 2110856.3338 | 37.776207657227204 | -122.431358584421 | (37.7762076572272, -122.431358584421) | |||
| 7499 | 7499 | 104699 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6011357.95285 | 2118999.80647 | 37.7990092725121 | -122.40478840238801 | (37.7990092725121, -122.404788402388) | |||
| 7508 | 7508 | 100204 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2237 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 5x5 | 6001902.2596 | 2114280.466 | 37.7855181330415 | -122.437170124873 | (37.7855181330415, -122.437170124873) | |||
| 7705 | 7705 | 104698 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6011319.973040001 | 2118997.1094299997 | 37.7989997441925 | -122.40491963593901 | (37.7989997441925, -122.404919635939) | |||
| 7745 | 7745 | 13062 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.41132460578899 | (37.8031495768645, -122.411324605789) | ||
| 7853 | 7853 | 114578 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3610 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 5997431.80475 | 2115758.42968 | 37.789321096433504 | -122.45274321263099 | (37.7893210964335, -122.452743212631) | |||
| 7973 | 7973 | 107590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000109.34681 | 2118076.29285 | 37.7958384005634 | -122.443645838983 | (37.7958384005634, -122.443645838983) | |||
| 8154 | 8154 | 104700 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011383.62949 | 2119002.34589 | 37.7990176802704 | -122.40469973101801 | (37.7990176802704, -122.404699731018) | |||
| 8478 | 8478 | 23520 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2725 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6005647.500080001 | 2119771.5564099997 | 37.800807467849395 | -122.424603426707 | (37.8008074678494, -122.424603426707) | |||
| 8500 | 8500 | 104697 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 455 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011289.75094 | 2118992.82516 | 37.798986291241796 | -122.40502391323099 | (37.7989862912418, -122.405023913231) | |||
| 8551 | 8551 | 112044 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2418 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6002377.10471 | 2117102.71936 | 37.793294297651 | -122.435729294977 | (37.793294297651, -122.435729294977) | |||
| 8940 | 8940 | 9931 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005032.8646599995 | 2117688.63241 | 37.7950535595338 | -122.426581919932 | (37.7950535595338, -122.426581919932) | |||
| 9241 | 9241 | 27374 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1702 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999207.4594 | 2109789.3959999997 | 37.773033261646496 | -122.44617014115101 | (37.7730332616465, -122.446170141151) | |||
| 9391 | 9391 | 24148 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x4 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | |||
| 9677 | 9677 | 114154 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200x JUNIPERO SERRA BLVD | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9853 | 9853 | 173717 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 614 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004584.0 | 2110624.0 | 37.775630457098295 | -122.427631485331 | (37.7756304570983, -122.427631485331) | ||||
| 9957 | 9957 | 173686 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2211 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 3 | 6011691.0 | 2097676.0 | 37.740477553883096 | -122.402135979323 | (37.7404775538831, -122.402135979323) | |||
| 9962 | 9962 | 173753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1140 Lawton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990653.0 | 2104548.0 | 37.7581495573033 | -122.475378025252 | (37.7581495573033, -122.475378025252) | |||||
| 9996 | 9996 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10124 | 10124 | 173862 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999618.0 | 2107794.0 | 37.7675778447629 | -122.444606591258 | (37.7675778447629, -122.444606591258) | ||||
| 10162 | 10162 | 173888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Vasquez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995783.0 | 2100209.0 | 37.7465317821399 | -122.457322486502 | (37.7465317821399, -122.457322486502) | |||||
| 10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
| 10422 | 10422 | 100386 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989668.805 | 2104235.219 | 37.7572336462205 | -122.478758883384 | (37.7572336462205, -122.478758883384) | |||
| 10531 | 10531 | 120538 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002576.6751 | 2087720.0510900002 | 37.7126278178947 | -122.43293862581999 | (37.7126278178947, -122.43293862582) | |||
| 10808 | 10808 | 100387 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1630 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989667.3817 | 2104248.5033 | 37.75727003871479 | -122.47876477719299 | (37.7572700387148, -122.478764777193) | |||
| 10853 | 10853 | 102802 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1245 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5987672.179 | 2106793.3292 | 37.764141382947706 | -122.485851660773 | (37.7641413829477, -122.485851660773) | |||
| 10888 | 10888 | 113348 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 36 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 15x6 | 6000512.8548 | 2088435.33913 | 37.7144745622345 | -122.440123079431 | (37.7144745622345, -122.440123079431) | |||
| 10984 | 10984 | 105220 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1443 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5987410.3461 | 2105455.8349 | 37.760453729777396 | -122.48665903725299 | (37.7604537297774, -122.486659037253) | |||
| 11006 | 11006 | 120949 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2750 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5985472.8534 | 2102314.8398 | 37.7517162845821 | -122.493128443109 | (37.7517162845821, -122.493128443109) | |||
| 11670 | 11670 | 102444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.715798995606704 | -122.436645469419 | (37.7157989956067, -122.436645469419) | |||
| 12444 | 12444 | 27070 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 801 Silver Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2000 12:00:00 AM | 6 | 4x15 | 6006926.95376 | 2093626.2596599997 | 37.7290907946921 | -122.41832116401699 | (37.7290907946921, -122.418321164017) | ||
| 12564 | 12564 | 115359 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | 5x6 | 6001770.67381 | 2087944.68785 | 37.7131988712114 | -122.43574047716001 | (37.7131988712114, -122.43574047716) | |||
| 13306 | 13306 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3x3 | 5991666.0 | 2101424.0 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | ||||
| 13458 | 13458 | 24144 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.38463593799999 | (37.7338509755474, -122.384635938) | |||
| 13466 | 13466 | 104640 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.778855505921605 | -122.410667371323 | (37.7788555059216, -122.410667371323) | |||
| 13509 | 13509 | 106317 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1133 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 4x4 | 6012240.80146 | 2103138.9754 | 37.7555083807236 | -122.400618637234 | (37.7555083807236, -122.400618637234) | |||
| 13761 | 13761 | 6553 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x8 | 6017462.04156 | 2097126.1556099998 | 37.7392882208803 | -122.382143528109 | (37.7392882208803, -122.382143528109) | |||
| 14058 | 14058 | 6836 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | ||
| 14181 | 14181 | 24141 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.733728630852795 | -122.38459886076001 | (37.7337286308528, -122.38459886076) | |||
| 14724 | 14724 | 28654 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | 3 | 6x3 | 6017442.42343 | 2097139.5251799999 | 37.739323847514 | -122.38221228939 | (37.739323847514, -122.38221228939) | ||
| 15459 | 15459 | 6794 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.458330001 | 2097207.3634599997 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | ||
| 15924 | 15924 | 122795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 241 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014055.37556 | 2105891.1297 | 37.7631662338691 | -122.39453593861 | (37.7631662338691, -122.39453593861) | |||
| 15970 | 15970 | 104641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009525.15876 | 2111682.0778200002 | 37.7788139428406 | -122.410613470452 | (37.7788139428406, -122.410613470452) | |||
| 17458 | 17458 | 10319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | |||
| 17561 | 17561 | 22565 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 231 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6001358.74635 | 2097645.7360799997 | 37.7398123322633 | -122.437858639569 | (37.7398123322633, -122.437858639569) | |||
| 17865 | 17865 | 99661 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1365 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | |||||
| 18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 |
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");