Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 89406 | 89406 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 443X ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 5988110.0 | 2090275.0 | 37.718811899837206 | -122.483126550771 | (37.7188118998372, -122.483126550771) | ||||
| 108061 | 108061 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5989494.0 | 2090180.0 | 37.7186314952818 | -122.47833572411999 | (37.7186314952818, -122.47833572412) | |||||
| 98469 | 98469 | 107308 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 190 EUCALYPTUS DR | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | ||||
| 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) | ||||
| 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) | |||
| 43615 | 43615 | 203878 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 5991362.957719999 | 2095918.0215900003 | 37.7344949935417 | -122.472293616873 | (37.7344949935417, -122.472293616873) | |||
| 151090 | 151090 | 203880 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 5991364.836759999 | 2095904.51613 | 37.7344580197106 | -122.472286136294 | (37.7344580197106, -122.472286136294) | |||
| 66124 | 66124 | 203879 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 5991366.58351 | 2095910.40405 | 37.7344742875433 | -122.472280526329 | (37.7344742875433, -122.472280526329) | |||
| 68073 | 68073 | 203881 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 5991366.8063199995 | 2095895.3177900002 | 37.734432877380705 | -122.472278656638 | (37.7344328773807, -122.472278656638) | |||
| 74508 | 74508 | 203882 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 5991371.09776 | 2095893.6112900001 | 37.7344284401265 | -122.47226369551001 | (37.7344284401265, -122.47226369551) | |||
| 131261 | 131261 | 217836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5991394.92255 | 2095812.4335599998 | 37.7342069253901 | -122.472175410894 | (37.7342069253901, -122.472175410894) | ||||
| 66072 | 66072 | 217842 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991425.94511 | 2095892.37177 | 37.734428210798995 | -122.47207398173799 | (37.734428210799, -122.472073981738) | ||||
| 68265 | 68265 | 217845 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5991433.42379 | 2095847.21705 | 37.7343046601167 | -122.47204483559999 | (37.7343046601167, -122.4720448356) | ||||
| 150742 | 150742 | 217844 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Cranleigh Dr | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5991434.00834 | 2095858.9575900002 | 37.7343369305015 | -122.472043670098 | (37.7343369305015, -122.472043670098) | ||||
| 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) | ||||
| 156682 | 156682 | 175042 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 98 San Diego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | ||||
| 62545 | 62545 | 203698 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1696 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 6ft | 5993434.49176 | 2103973.54477 | 37.7567330891842 | -122.46571676863 | (37.7567330891842, -122.46571676863) | |||
| 78929 | 78929 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1325 Portola Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | |||||
| 25522 | 25522 | 175043 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 199 Shakespeare St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 5993498.29454 | 2086678.39145 | 37.709248559547504 | -122.464240538697 | (37.7092485595475, -122.464240538697) | |||
| 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) | ||||
| 121713 | 121713 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | ||||
| 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) | ||||
| 102829 | 102829 | 98542 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 105359 | 105359 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 178371 | 178371 | 94602 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2939 Vallejo St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/07/2010 12:00:00 AM | 9 | Permit Number 53770 | 5999468.945859999 | 2117347.95354 | 37.7938020288031 | -122.445809330858 | (37.7938020288031, -122.445809330858) | ||
| 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) | ||||
| 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) | ||||
| 148824 | 148824 | 249687 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Baker St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 5999715.024 | 2117348.66269 | 37.793818023244796 | -122.444957931866 | (37.7938180232448, -122.444957931866) | ||||
| 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) | |||||
| 101578 | 101578 | 117527 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099x WALLER ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000071.0 | 2108311.0 | 37.769023235971 | -122.44307686155001 | (37.769023235971, -122.44307686155) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 72948 | 72948 | 221378 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 190 Storrie St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000803.23299 | 2105309.21717 | 37.7608228056365 | -122.440328815537 | (37.7608228056365, -122.440328815537) | |||
| 80060 | 80060 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 11 Hiliritas Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | ||||
| 83174 | 83174 | 111552 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 30 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 141167 | 141167 | 111532 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 10 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 143355 | 143355 | 111556 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900x BOSWORTH ST | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 77934 | 77934 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 102846 | 102846 | 105415 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 105444 | 105444 | 105416 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X McAllister St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002220.7882900005 | 2111575.67932 | 37.7781095739995 | -122.43587451144501 | (37.7781095739995, -122.435874511445) | |||||
| 143490 | 143490 | 111510 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 800x BOSWORTH ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 20 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 66538 | 66538 | 220278 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3925 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6002292.19971 | 2103528.34865 | 37.7560176344239 | -122.435051775442 | (37.7560176344239, -122.435051775442) | ||||
| 52850 | 52850 | 220146 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003150.7799 | 2095211.43274 | 37.7332300323227 | -122.431488808967 | (37.7332300323227, -122.431488808967) | ||||
| 176044 | 176044 | 220145 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003154.048330001 | 2095235.16031 | 37.73329536808561 | -122.431479202413 | (37.7332953680856, -122.431479202413) | ||||
| 89630 | 89630 | 220144 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 450 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6003159.40524 | 2095238.92343 | 37.733306004372295 | -122.43146095066002 | (37.7333060043723, -122.43146095066) | ||||
| 170910 | 170910 | 220201 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6003510.43036 | 2095660.01539 | 37.734482116158105 | -122.430277392481 | (37.7344821161581, -122.430277392481) | |||
| 160587 | 160587 | 220200 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6003513.54179 | 2095663.72893 | 37.7344924889333 | -122.430266900093 | (37.7344924889333, -122.430266900093) | |||
| 38042 | 38042 | 220199 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6003519.67627 | 2095667.91857 | 37.73450434019979 | -122.43024598997499 | (37.7345043401998, -122.430245989975) | |||
| 168847 | 168847 | 221369 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6003690.30976 | 2103870.989 | 37.7570377318327 | -122.430241091376 | (37.7570377318327, -122.430241091376) | |||
| 42488 | 42488 | 220198 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 5ft | 6003524.19467 | 2095672.0219999999 | 37.7345158632135 | -122.430230661025 | (37.7345158632135, -122.430230661025) | |||
| 73216 | 73216 | 220197 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 69 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 5ft | 6003530.33086 | 2095674.11312 | 37.734521952510796 | -122.43020959532 | (37.7345219525108, -122.43020959532) | |||
| 76034 | 76034 | 220196 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 68 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 5ft | 6003535.06176 | 2095676.5512700002 | 37.7345289150748 | -122.43019341291401 | (37.7345289150748, -122.430193412914) | |||
| 65971 | 65971 | 220202 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6003538.0871 | 2095667.4408599997 | 37.7345040713105 | -122.430182303581 | (37.7345040713105, -122.430182303581) | ||||
| 38062 | 38062 | 220195 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 67 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 6003539.74229 | 2095678.61576 | 37.734534848798205 | -122.43017737800301 | (37.7345348487982, -122.430177378003) | |||
| 49122 | 49122 | 221368 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 755 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6003710.38169 | 2103854.76962 | 37.7569943341355 | -122.43017051796998 | (37.7569943341355, -122.43017051797) | |||
| 147959 | 147959 | 220194 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 5ft | 6003545.8031 | 2095679.42322 | 37.7345374091774 | -122.430156481356 | (37.7345374091774, -122.430156481356) | |||
| 177243 | 177243 | 220193 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 5ft | 6003549.85445 | 2095682.63787 | 37.734546465338504 | -122.43014270374901 | (37.7345464653385, -122.430142703749) | |||
| 138114 | 138114 | 220192 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 5ft | 6003556.22665 | 2095685.5144599997 | 37.7345547247094 | -122.430120878078 | (37.7345547247094, -122.430120878078) | |||
| 184990 | 184990 | 221388 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 671 Church St | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 3ft | 6004298.752230001 | 2105308.1718200003 | 37.7610183389455 | -122.428239289531 | (37.7610183389455, -122.428239289531) | |||
| 57106 | 57106 | 220148 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004123.55506 | 2095814.8430700002 | 37.7349419476051 | -122.428168647787 | (37.7349419476051, -122.428168647787) | ||||
| 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) | ||||
| 169528 | 169528 | 221387 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 701 Church St | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 3ft | 6004318.365019999 | 2104792.37844 | 37.7596032026492 | -122.428134698373 | (37.7596032026492, -122.428134698373) | |||
| 113891 | 113891 | 220147 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004138.65271 | 2095814.5319700001 | 37.7349419476117 | -122.42811642772699 | (37.7349419476117, -122.428116427727) | ||||
| 173924 | 173924 | 220153 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 9ft | 6004145.42049 | 2095858.4508 | 37.735062921705996 | -122.428096157927 | (37.735062921706, -122.428096157927) | |||
| 73296 | 73296 | 220154 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6004158.18023 | 2095867.64857 | 37.735088898617896 | -122.428052698177 | (37.7350888986179, -122.428052698177) | ||||
| 55386 | 55386 | 220155 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004171.837169999 | 2095877.8468099998 | 37.735117673337705 | -122.428006207723 | (37.7351176733377, -122.428006207723) | ||||
| 70806 | 70806 | 220156 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 64 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004516.6061 | 2096115.66582 | 37.7357901701732 | -122.426831148142 | (37.7357901701732, -122.426831148142) | ||||
| 50471 | 50471 | 220157 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004526.08475 | 2096117.80265 | 37.7357965733541 | -122.426798528853 | (37.7357965733541, -122.426798528853) | ||||
| 47311 | 47311 | 220158 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004531.65878 | 2096118.78837 | 37.735799595073104 | -122.426779327416 | (37.7357995950731, -122.426779327416) | ||||
| 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) | ||||
| 50359 | 50359 | 220161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004865.4895 | 2096506.1527200001 | 37.736882079352895 | -122.42565270441001 | (37.7368820793529, -122.42565270441) | ||||
| 182719 | 182719 | 220160 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004872.2864 | 2096465.4493 | 37.73677070099679 | -122.42562630840901 | (37.7367707009968, -122.425626308409) | ||||
| 181452 | 181452 | 220191 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6004894.80738 | 2096532.47755 | 37.7369560180099 | -122.425553212433 | (37.7369560180099, -122.425553212433) | ||||
| 53208 | 53208 | 220190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004897.78998 | 2096535.50608 | 37.73696450219779 | -122.425543115723 | (37.7369645021978, -122.425543115723) | ||||
| 178188 | 178188 | 220188 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004898.43848 | 2096540.4001099998 | 37.736977976744 | -122.425541221768 | (37.736977976744, -122.425541221768) | ||||
| 146508 | 146508 | 220189 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6004903.37501 | 2096531.93768 | 37.7369550197456 | -122.425523551887 | (37.7369550197456, -122.425523551887) | ||||
| 171906 | 171906 | 220186 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004903.97159 | 2096543.19438 | 37.736985961816295 | -122.42552229012699 | (37.7369859618163, -122.425522290127) | ||||
| 143289 | 143289 | 220162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | 6004904.25494 | 2096495.99975 | 37.7368563920029 | -122.42551795268999 | (37.7368563920029, -122.42551795269) | ||||
| 182151 | 182151 | 220187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004907.90324 | 2096539.115 | 37.736974982905295 | -122.42550840641 | (37.7369749829053, -122.42550840641) | ||||
| 158439 | 158439 | 220185 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004909.032430001 | 2096549.6336299998 | 37.7370039284954 | -122.42550525066002 | (37.7370039284954, -122.42550525066) | ||||
| 46233 | 46233 | 220163 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004924.61859 | 2096505.26609 | 37.736882985860795 | -122.42544820577 | (37.7368829858608, -122.42544820577) | ||||
| 173065 | 173065 | 220183 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 71 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6004926.20278 | 2096562.8505 | 37.7370411891885 | -122.425446825336 | (37.7370411891885, -122.425446825336) | ||||
| 165475 | 165475 | 220184 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004926.8696 | 2096549.97699 | 37.737005879105396 | -122.425443603957 | (37.7370058791054, -122.425443603957) | ||||
| 69509 | 69509 | 220166 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004931.1825 | 2096526.6539599998 | 37.7369420829968 | -122.425427033027 | (37.7369420829968, -122.425427033027) | ||||
| 59590 | 59590 | 220164 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004931.31387 | 2096515.53098 | 37.7369115492209 | -122.425425787491 | (37.7369115492209, -122.425425787491) | ||||
| 175220 | 175220 | 220170 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004937.56248 | 2096542.42817 | 37.736985755890395 | -122.42540609680701 | (37.7369857558904, -122.425406096807) | ||||
| 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) | ||||
| 61532 | 61532 | 220171 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004943.37646 | 2096556.00352 | 37.7370233592275 | -122.425386961047 | (37.7370233592275, -122.425386961047) | ||||
| 162956 | 162956 | 220167 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004945.26232 | 2096528.1578 | 37.7369470076993 | -122.425378459774 | (37.7369470076993, -122.425378459774) | ||||
| 67345 | 67345 | 220168 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004945.7660300005 | 2096533.5746 | 37.7369619094711 | -122.42537710358499 | (37.7369619094711, -122.425377103585) | ||||
| 77142 | 77142 | 220169 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6004952.51664 | 2096535.6068900002 | 37.7369678710776 | -122.42535390827801 | (37.7369678710776, -122.425353908278) | ||||
| 67096 | 67096 | 220180 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004956.4511400005 | 2096571.71335 | 37.7370672335752 | -122.425342873587 | (37.7370672335752, -122.425342873587) | ||||
| 152969 | 152969 | 220172 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004959.708880001 | 2096542.8076799999 | 37.7369880491675 | -122.425329553743 | (37.7369880491675, -122.425329553743) | ||||
| 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) | ||||
| 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) | ||||
| 57145 | 57145 | 220174 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6004973.16585 | 2096557.19919 | 37.7370283252818 | -122.425284050737 | (37.7370283252818, -122.425284050737) | ||||
| 164299 | 164299 | 220175 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004976.12829 | 2096559.96941 | 37.7370360990465 | -122.425274005312 | (37.7370360990465, -122.425274005312) | ||||
| 166213 | 166213 | 220177 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6004978.16757 | 2096563.63573 | 37.737046281145204 | -122.42526721541401 | (37.7370462811452, -122.425267215414) |
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");