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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | 74 | 188665 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 37 | 6011669.71313 | 2097723.45025 | 37.740606653987705 | -122.402212916691 | (37.7406066539877, -122.402212916691) | ||||
| 940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
| 3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 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) | ||||
| 7251 | 7251 | 67295 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2021 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2015 12:00:00 AM | 3 | Permit Number 775844 | 5999878.81667 | 2115908.61359 | 37.7898733737087 | -122.444287662668 | (37.7898733737087, -122.444287662668) | ||
| 8469 | 8469 | 46251 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2683 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 7 | Permit Number 777339 | 6000247.41446 | 2117804.02133 | 37.7950986884031 | -122.44314853640101 | (37.7950986884031, -122.443148536401) | ||
| 8491 | 8491 | 67001 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 840X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/1992 12:00:00 AM | 3 | Permit Number 30356 | 6009653.005480001 | 2118469.06923 | 37.7974565552432 | -122.410650614256 | (37.7974565552432, -122.410650614256) | ||
| 9667 | 9667 | 11795 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 10203 | 10203 | 106598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001X SAN JOSE AVE | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 11073 | 11073 | 30310 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
| 14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
| 14140 | 14140 | 6797 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 6016896.75135 | 2097199.75019 | 37.7394590596789 | -122.384103192232 | (37.7394590596789, -122.384103192232) | |||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 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 | ||||||||||
| 18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
| 19122 | 19122 | 103382 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3199X JACKSON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999158.0 | 2116301.0 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | |||||
| 19654 | 19654 | 104292 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999485.4 | 2120797.2 | 37.8032736772553 | -122.446000602494 | (37.8032736772553, -122.446000602494) | |||||
| 19684 | 19684 | 50106 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672002 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | ||
| 20617 | 20617 | 87007 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 7070 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878.0 | 2113896.0 | 37.7835385880022 | -122.49258024231199 | (37.7835385880022, -122.492580242312) | |||
| 22305 | 22305 | 68937 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 518 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/2017 12:00:00 AM | 3 | Permit Number 779489 | 5992539.41235 | 2111890.04765 | 37.7784180283155 | -122.46938847408998 | (37.7784180283155, -122.46938847409) | |
| 23331 | 23331 | 5163 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 288 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6001824.579 | 2109378.5545 | 37.7720543041481 | -122.437087794368 | (37.7720543041481, -122.437087794368) | ||||
| 23343 | 23343 | 18087 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2996 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 5999641.9923 | 2114716.1155 | 37.7865855715731 | -122.44502128728998 | (37.7865855715731, -122.44502128729) | ||||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 23512 | 23512 | 49013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2450 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2002 12:00:00 AM | 12 | Permit Number 46199 | 5999595.37201 | 2119840.2569999998 | 37.8006524480994 | -122.44555118855601 | (37.8006524480994, -122.445551188556) | ||
| 23878 | 23878 | 106648 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1293 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5987685.171 | 2106501.0088 | 37.763339508501396 | -122.48578526928301 | (37.7633395085014, -122.485785269283) | ||||
| 23882 | 23882 | 125253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Reed St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008205.34429 | 2117069.05453 | 37.793531190756205 | -122.41556074355101 | (37.7935311907562, -122.415560743551) | ||||
| 23976 | 23976 | 68013 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2245 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1993 12:00:00 AM | 21 | Permit Number 770742 | 5999478.9581699995 | 2120820.4060400003 | 37.803337026932894 | -122.446024564694 | (37.8033370269329, -122.446024564694) | ||
| 24305 | 24305 | 187754 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6018045.40924 | 2093280.41562 | 37.728760777668 | -122.37985934635799 | (37.728760777668, -122.379859346358) | ||||
| 24760 | 24760 | 188680 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Middle Point Rd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6018245.47476 | 2096448.1212400002 | 37.7374697107694 | -122.37938765012501 | (37.7374697107694, -122.379387650125) | ||||
| 24958 | 24958 | 102800 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 708 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5995062.7103 | 2110691.85511 | 37.7752736059254 | -122.460572652238 | (37.7752736059254, -122.460572652238) | ||||
| 25663 | 25663 | 188593 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921004 | -122.40514986509899 | (37.759594070921, -122.405149865099) | ||||
| 26417 | 26417 | 247936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1149 Esmeralda Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010249.43041 | 2098747.94631 | 37.7433403177918 | -122.40719593154101 | (37.7433403177918, -122.407195931541) | ||||
| 26454 | 26454 | 188657 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 123 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6016750.167669999 | 2099204.87087 | 37.744956608177205 | -122.38474966268801 | (37.7449566081772, -122.384749662688) | ||||
| 26973 | 26973 | 188567 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 500 24th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | ||||
| 27189 | 27189 | 220159 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 67 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004532.29415 | 2096115.9287299998 | 37.73579177907 | -122.426776927106 | (37.73579177907, -122.426776927106) | ||||
| 27654 | 27654 | 30297 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2734 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1956 12:00:00 AM | 9 | Permit Number 140 | 6003569.97515 | 2117774.33074 | 37.7952060548567 | -122.43164985595 | (37.7952060548567, -122.43164985595) | ||
| 28111 | 28111 | 217843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5991434.2347099995 | 2095869.6985099998 | 37.7343664354551 | -122.472043670093 | (37.7343664354551, -122.472043670093) | ||||
| 28294 | 28294 | 188658 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | ||||
| 29568 | 29568 | 247533 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Waller St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6000119.08328 | 2108491.6907099998 | 37.769522108775 | -122.44292352241501 | (37.769522108775, -122.442923522415) | ||||
| 29742 | 29742 | 203269 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 61 Burnside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6001195.67234 | 2095721.17604 | 37.7345186646045 | -122.438284639447 | (37.7345186646045, -122.438284639447) | ||||
| 30134 | 30134 | 34162 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1321 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1997 12:00:00 AM | Permit Number 37995 | 6002005.24557776 | 2100252.01136141 | 37.747005294912896 | -122.435809748575 | (37.7470052949129, -122.435809748575) | |||
| 30436 | 30436 | 203829 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 41 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5993865.8273 | 2096513.9581 | 37.7362758229773 | -122.463683673072 | (37.7362758229773, -122.463683673072) | ||||
| 30471 | 30471 | 188564 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Vermont St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | 6011131.87643 | 2106822.77201 | 37.7655613532939 | -122.404712987912 | (37.7655613532939, -122.404712987912) | ||||
| 30738 | 30738 | 187755 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018042.26935 | 2093273.64193 | 37.7287420052256 | -122.379869730822 | (37.7287420052256, -122.379869730822) | ||||
| 30922 | 30922 | 203824 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 270 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5996325.39401 | 2095129.7454900001 | 37.732616529229 | -122.455079988546 | (37.732616529229, -122.455079988546) | ||||
| 31496 | 31496 | 220151 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005128.65815 | 2096758.77235 | 37.7375905832326 | -122.42476077930901 | (37.7375905832326, -122.424760779309) | ||||
| 31743 | 31743 | 249705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Baker St | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 5999691.230359999 | 2117200.88619 | 37.793410910039896 | -122.44502963123101 | (37.7934109100399, -122.445029631231) | ||||
| 32122 | 32122 | 101420 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6000374.3516 | 2116185.0207 | 37.7906605745677 | -122.442593016179 | (37.7906605745677, -122.442593016179) | ||||
| 32587 | 32587 | 220165 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004939.36103 | 2096521.46367 | 37.736928293710896 | -122.425398386937 | (37.7369282937109, -122.425398386937) | ||||
| 33086 | 33086 | 59887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 21 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 23 | Permit Number 19353 | 5998815.1407 | 2110971.0405 | 37.776255342115604 | -122.447612291383 | (37.7762553421156, -122.447612291383) | |
| 33152 | 33152 | 187750 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018189.80767 | 2093163.42935 | 37.728447520437705 | -122.379352023493 | (37.7284475204377, -122.379352023493) | ||||
| 33614 | 33614 | 188708 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Bridgeview Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6014073.74253 | 2095336.92691 | 37.734187650237395 | -122.393733643518 | (37.7341876502374, -122.393733643518) | ||||
| 33836 | 33836 | 246868 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3090x Market St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 5999955.5697 | 2105338.29244 | 37.760854339489 | -122.443262585704 | (37.760854339489, -122.443262585704) | ||||
| 34140 | 34140 | 106242 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | |||
| 34603 | 34603 | 249714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 5999388.9274 | 2116973.5904200003 | 37.7927695576174 | -122.446059261445 | (37.7927695576174, -122.446059261445) | ||||
| 35242 | 35242 | 249713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5999382.51554 | 2116973.87968 | 37.792769985700296 | -122.446081467494 | (37.7927699857003, -122.446081467494) | ||||
| 35303 | 35303 | 249715 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2975 Broadway | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5999395.51836 | 2116974.38878 | 37.7927721260745 | -122.44603651397 | (37.7927721260745, -122.44603651397) | ||||
| 35488 | 35488 | 249706 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Baker St | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5999689.68932 | 2117193.0957299997 | 37.7933894315405 | -122.445034403012 | (37.7933894315405, -122.445034403012) | ||||
| 35636 | 35636 | 187736 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6016350.44721 | 2096194.4230400003 | 37.7366684157019 | -122.38592203240101 | (37.7366684157019, -122.385922032401) | ||||
| 36058 | 36058 | 101422 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6000369.95559 | 2116208.8257400002 | 37.790725686401 | -122.44260993601802 | (37.790725686401, -122.442609936018) | ||||
| 36188 | 36188 | 201372 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6018490.42115 | 2095382.8253 | 37.734558123266204 | -122.378466804612 | (37.7345581232662, -122.378466804612) | ||||
| 36388 | 36388 | 87087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | ||
| 36572 | 36572 | 125283 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1022 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6008553.3357 | 2118652.52979 | 37.797898577410706 | -122.414468760628 | (37.7978985774107, -122.414468760628) | ||||
| 36731 | 36731 | 220173 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6004965.33197 | 2096549.91203 | 37.737007873798596 | -122.42531061759199 | (37.7370078737986, -122.425310617592) | ||||
| 36819 | 36819 | 220279 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Bemis St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6003936.6638400005 | 2097030.2765099998 | 37.738268675662 | -122.42890142078998 | (37.738268675662, -122.42890142079) | ||||
| 37011 | 37011 | 187739 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 301x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016069.71075 | 2096081.9732700002 | 37.736344111196 | -122.38688482859399 | (37.736344111196, -122.386884828594) | ||||
| 37409 | 37409 | 123163 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 515 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5992793.60446 | 2111925.06409 | 37.7785288602389 | -122.468511684261 | (37.7785288602389, -122.468511684261) | ||||
| 37447 | 37447 | 220241 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 10x Benton Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004791.23434 | 2095030.3631099998 | 37.7328256962469 | -122.425804423654 | (37.7328256962469, -122.425804423654) | ||||
| 37667 | 37667 | 101423 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6000367.44733 | 2116221.15803 | 37.7907594046669 | -122.44261950028401 | (37.7907594046669, -122.442619500284) | ||||
| 38645 | 38645 | 32303 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 750 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 36880 | 5990706.9497 | 2110266.1077900003 | 37.773853068141605 | -122.47560897417699 | (37.7738530681416, -122.475608974177) | |||
| 39068 | 39068 | 203273 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Burnside Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001158.4895 | 2095751.0037900002 | 37.7345984497666 | -122.43841532891001 | (37.7345984497666, -122.43841532891) | ||||
| 39721 | 39721 | 49030 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2763 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | 5 | Permit Number 46206 | 5999822.18303 | 2117741.39677 | 37.7949024824292 | -122.444615393602 | (37.7949024824292, -122.444615393602) | ||
| 39815 | 39815 | 38562 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1620 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40527 | 6015255.0701 | 2096054.7136 | 37.736224122234205 | -122.389699501807 | (37.7362241222342, -122.389699501807) | |
| 40274 | 40274 | 30342 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 27 | 6001955.9140099995 | 2121688.85818 | 37.8058626973628 | -122.437515213673 | (37.8058626973628, -122.437515213673) | |||
| 40979 | 40979 | 106249 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770844 | 6012059.457280001 | 2105702.6288 | 37.7625374908356 | -122.401425945147 | (37.7625374908356, -122.401425945147) | |||
| 41066 | 41066 | 49029 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2763 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | 6 | Permit Number 46206 | 5999835.8174 | 2117744.2115599997 | 37.7949109890951 | -122.444568419294 | (37.7949109890951, -122.444568419294) | ||
| 41597 | 41597 | 102629 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | |||
| 41603 | 41603 | 99560 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1142 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6011556.95658 | 2119287.39483 | 37.7998100414445 | -122.404120029814 | (37.7998100414445, -122.404120029814) | ||||
| 41904 | 41904 | 188655 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6017659.9469 | 2098420.67777 | 37.7428536469791 | -122.38154925430099 | (37.7428536469791, -122.381549254301) | ||||
| 42043 | 42043 | 188631 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6010953.30174 | 2096155.7818599998 | 37.7362621559727 | -122.404579676927 | (37.7362621559727, -122.404579676927) | ||||
| 42123 | 42123 | 220179 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6004963.5382900005 | 2096567.90345 | 37.7370571728501 | -122.42531809906001 | (37.7370571728501, -122.42531809906) | ||||
| 42983 | 42983 | 30852 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | |||
| 43180 | 43180 | 40179 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1724 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1999 12:00:00 AM | 24 | Permit Number 41370 | 6002078.2803 | 2114497.9921 | 37.786125408317396 | -122.43657672143499 | (37.7861254083174, -122.436576721435) | ||
| 43203 | 43203 | 54713 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 14 | Permit Number 11467 | 6001165.76206 | 2116883.2589 | 37.7926228359235 | -122.43990487063999 | (37.7926228359235, -122.43990487064) | ||
| 43530 | 43530 | 220149 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6004123.90367 | 2095822.3562900003 | 37.734962596934 | -122.428167977786 | (37.734962596934, -122.428167977786) | ||||
| 44107 | 44107 | 188705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1998 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013030.362000001 | 2095929.4873 | 37.7357566623473 | -122.397382506903 | (37.7357566623473, -122.397382506903) | ||||
| 44175 | 44175 | 99145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 302X Pacheco St | 29 | Median : Cutout 11 | Tree 1 | Private 1 | 9 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
| 44332 | 44332 | 188644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Cargo Way | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | ||||
| 44612 | 44612 | 125280 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6006711.337180001 | 2119778.11421 | 37.80088549662629 | -122.420922564536 | (37.8008854966263, -122.420922564536) | ||||
| 44722 | 44722 | 188706 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1798 Revere Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6014089.91477 | 2095172.94813 | 37.7337382967731 | -122.393666257286 | (37.7337382967731, -122.393666257286) | ||||
| 45050 | 45050 | 51789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1238 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2005 12:00:00 AM | 13 | Permit Number 48038 | 5987411.1576 | 2106813.4078 | 37.7641812994666 | -122.486755921101 | (37.7641812994666, -122.486755921101) | ||
| 45398 | 45398 | 58302 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3233 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1978 12:00:00 AM | 16 | Permit Number 17321 | 5998757.69678 | 2116224.86065 | 37.7906776778817 | -122.44818940014 | (37.7906776778817, -122.44818940014) | ||
| 45504 | 45504 | 188636 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Helena St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6011012.07501 | 2096193.39606 | 37.7363687211334 | -122.404379119099 | (37.7363687211334, -122.404379119099) | ||||
| 46008 | 46008 | 187764 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 91 Kiska Rd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6019412.692980001 | 2093581.83976 | 37.729663759061 | -122.37515338563 | (37.729663759061, -122.37515338563) | ||||
| 46213 | 46213 | 125279 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200 Greenwich St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006714.731269999 | 2119776.90963 | 37.8008823804688 | -122.42091073396001 | (37.8008823804688, -122.42091073396) |
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");