trees
3,965 rows where qSpecies_id = 70 sorted by qSiteInfo
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135252 | 254189 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 187x Stonecrest Dr | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5990830 | 2093201 | 37.7270038779971 | -122.473938047356 | (37.7270038779971, -122.473938047356) | 9 | 8 | 4 | 64 | 40 | |||||
179210 | 112417 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 98X BROADMOOR DR | 1 | Front Yard : Cutout | Tree | Private 2 | 28 | 3x3 | 5990934 | 2093194 | 37.7269906812088 | -122.47357801435 | (37.7269906812088, -122.47357801435) | 9 | 8 | 4 | 64 | 40 | |||
177 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Lopez Ave | 4 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994049 | 2100330 | 37.746764271907 | -122.463327202712 | (37.746764271907, -122.463327202712) | 1 | 8 | 4 | 29491 | 40 | ||||
1805 | 203698 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1696 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | Width 6ft | 5993434.49176 | 2103973.54477 | 37.7567330891842 | -122.46571676863 | (37.7567330891842, -122.46571676863) | 1 | 8 | 4 | 56 | 12 | |||
3682 | 261986 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Bancroft Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | |||||
3798 | 262575 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 141 Topaz Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001722 | 2097902 | 37.7405366227001 | -122.436621002014 | (37.7405366227001, -122.436621002014) | 2 | 7 | 5 | 63 | 7 | |||||
6421 | 220173 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 37 | Front Yard : Yard | Tree | Private 2 | 16 | 6004965.33197 | 2096549.91203 | 37.7370078737986 | -122.425310617592 | (37.7370078737986, -122.425310617592) | 2 | 7 | 5 | 28859 | 2 | ||||
7786 | 220170 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 34 | Front Yard : Yard | Tree | Private 2 | 13 | 6004937.56248 | 2096542.42817 | 37.7369857558904 | -122.425406096807 | (37.7369857558904, -122.425406096807) | 2 | 7 | 5 | 28859 | 2 | ||||
8060 | 220192 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 64 | Front Yard : Yard | Tree | Private 2 | 12 | Width 5ft | 6003556.22665 | 2095685.51446 | 37.7345547247094 | -122.430120878078 | (37.7345547247094, -122.430120878078) | 2 | 7 | 5 | 63 | 7 | |||
9517 | 246826 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400 Franconia St | 3 | Front Yard : Yard | Tree | Private 2 | 1 | 6009973.79808 | 2098728.47143 | 37.7432714144464 | -122.408147628312 | (37.7432714144464, -122.408147628312) | 10 | 7 | 7 | 28859 | 2 | ||||
14836 | 221387 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 701 Church St | 38 | Front Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6004318.36502 | 2104792.37844 | 37.7596032026492 | -122.428134698373 | (37.7596032026492, -122.428134698373) | 2 | 4 | 5 | 28862 | 3 | |||
23415 | 125278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 16 | 6006716.82854 | 2119779.13638 | 37.8008886127761 | -122.420903634692 | (37.8008886127761, -122.420903634692) | 5 | 1 | 1 | 28858 | 32 | ||||
25027 | 188574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 24 | Front Yard : Yard | Tree | Private 2 | 1 | 6014321.12378 | 2106534.34369 | 37.7649471289393 | -122.39366181916 | (37.7649471289393, -122.39366181916) | 14 | 3 | 8 | 310 | 29 | ||||
25090 | 220149 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 3 | Front Yard : Yard | Tree | Private 2 | 10 | 6004123.90367 | 2095822.35629 | 37.734962596934 | -122.428167977786 | (37.734962596934, -122.428167977786) | 2 | 7 | 5 | 28861 | 2 | ||||
25108 | 97979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 9 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.99719 | 37.730741330332 | -122.412724380735 | (37.730741330332, -122.412724380735) | 9 | 3 | 7 | 309 | 28 | ||
25538 | 97980 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 10 | Front Yard : Yard | Tree | Private 2 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | |||
25606 | 220176 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 41 | Front Yard : Yard | Tree | Private 2 | 7 | 6004978.26443 | 2096560.74559 | 37.7370383509436 | -122.425266674926 | (37.7370383509436, -122.425266674926) | 2 | 7 | 5 | 28859 | 2 | ||||
26650 | 220155 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 8 | 6004171.83717 | 2095877.84681 | 37.7351176733377 | -122.428006207723 | (37.7351176733377, -122.428006207723) | 2 | 7 | 5 | 28861 | 2 | ||||
28393 | 175015 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 5 | Front Yard : Yard | Tree | Private 2 | 22 | Width 8ft | 6013189.92411 | 2087076.36729 | 37.7114566649583 | -122.39621055537 | (37.7114566649583, -122.39621055537) | 10 | 3 | 8 | 309 | 1 | |||
28632 | 188571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 19 | Front Yard : Yard | Tree | Private 2 | 1 | 6014323.12928 | 2106506.58009 | 37.764871007621 | -122.393652939236 | (37.764871007621, -122.393652939236) | 14 | 3 | 8 | 310 | 29 | ||||
28670 | 125286 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 941 Vallejo St | 6 | Front Yard : Yard | Tree | Private 2 | 11 | 6008909.00848 | 2118677.12072 | 37.7979860724672 | -122.413239767796 | (37.7979860724672, -122.413239767796) | 3 | 1 | 10 | 308 | 21 | ||||
30617 | 220175 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 40 | Front Yard : Yard | Tree | Private 2 | 17 | 6004976.12829 | 2096559.96941 | 37.7370360990465 | -122.425274005312 | (37.7370360990465, -122.425274005312) | 2 | 7 | 5 | 28859 | 2 | ||||
32776 | 252873 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Broderick St | 7 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000422 | 2113928 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | 15 | 6 | 11 | 29490 | 13 | ||||
33137 | 220158 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 9 | 6004531.65878 | 2096118.78837 | 37.7357995950731 | -122.426779327416 | (37.7357995950731, -122.426779327416) | 2 | 7 | 5 | 28861 | 2 | ||||
33246 | 220147 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 1 | Front Yard : Yard | Tree | Private 2 | 23 | 6004138.65271 | 2095814.53197 | 37.7349419476117 | -122.428116427727 | (37.7349419476117, -122.428116427727) | 2 | 7 | 5 | 28861 | 2 | ||||
34055 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 3 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
35847 | 249706 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 38 | Front Yard : Yard | Tree | Private 2 | 10 | 5999689.68932 | 2117193.09573 | 37.7933894315405 | -122.445034403012 | (37.7933894315405, -122.445034403012) | 13 | 9 | 1 | 57 | 27 | ||||
35884 | 220200 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 8 | Width 5ft | 6003513.54179 | 2095663.72893 | 37.7344924889333 | -122.430266900093 | (37.7344924889333, -122.430266900093) | 2 | 7 | 5 | 63 | 7 | |||
37172 | 188573 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 23 | Front Yard : Yard | Tree | Private 2 | 2 | 6014313.95748 | 2106525.31857 | 37.7649219497227 | -122.393685974041 | (37.7649219497227, -122.393685974041) | 14 | 3 | 8 | 310 | 29 | ||||
39635 | 175016 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 6 | Front Yard : Yard | Tree | Private 2 | 12 | Width 8ft | 6013191.1859 | 2087080.9939 | 37.7114694389303 | -122.396206518314 | (37.7114694389303, -122.396206518314) | 10 | 3 | 8 | 309 | 1 | |||
39911 | 97975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.7306665633988 | -122.412698416414 | (37.7306665633988, -122.412698416414) | 9 | 3 | 7 | 309 | 28 | ||
40734 | 220146 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450 Bosworth St | 3 | Front Yard : Yard | Tree | Private 2 | 27 | 6003150.7799 | 2095211.43274 | 37.7332300323227 | -122.431488808967 | (37.7332300323227, -122.431488808967) | 2 | 7 | 5 | 28861 | 25 | ||||
41779 | 246827 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400 Franconia St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6009974.41819 | 2098730.47702 | 37.7432769560816 | -122.408145625541 | (37.7432769560816, -122.408145625541) | 10 | 7 | 7 | 28859 | 2 | ||||
42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
46939 | 220174 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 8 | 6004973.16585 | 2096557.19919 | 37.7370283252818 | -122.425284050737 | (37.7370283252818, -122.425284050737) | 2 | 7 | 5 | 28859 | 2 | ||||
46991 | 203881 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 17 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 5991366.80632 | 2095895.31779 | 37.7344328773807 | -122.472278656638 | (37.7344328773807, -122.472278656638) | 1 | 8 | 4 | 64 | 40 | |||
47940 | 97971 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 3x105 | 6008579.18793 | 2094106.30305 | 37.7305017590298 | -122.412643160269 | (37.7305017590298, -122.412643160269) | 9 | 3 | 7 | 309 | 28 | |||
49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
51559 | 249687 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 19 | Front Yard : Yard | Tree | Private 2 | 37 | 5999715.024 | 2117348.66269 | 37.7938180232448 | -122.444957931866 | (37.7938180232448, -122.444957931866) | 13 | 9 | 1 | 57 | 27 | ||||
51614 | 111552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 30 | Front Yard : Yard | Tree | DPW 1 | 6 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
52773 | 220201 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 7 | Width 5ft | 6003510.43036 | 2095660.01539 | 37.7344821161581 | -122.430277392481 | (37.7344821161581, -122.430277392481) | 2 | 7 | 5 | 63 | 7 | |||
52837 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 3 | Front Yard : Yard | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
53791 | 220198 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6003524.19467 | 2095672.022 | 37.7345158632135 | -122.430230661025 | (37.7345158632135, -122.430230661025) | 2 | 7 | 5 | 63 | 7 | |||
54519 | 220179 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 44 | Front Yard : Yard | Tree | Private 2 | 22 | 6004963.53829 | 2096567.90345 | 37.7370571728501 | -122.42531809906 | (37.7370571728501, -122.42531809906) | 2 | 7 | 5 | 28859 | 2 | ||||
58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
58980 | 220171 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 35 | Front Yard : Yard | Tree | Private 2 | 23 | 6004943.37646 | 2096556.00352 | 37.7370233592275 | -122.425386961047 | (37.7370233592275, -122.425386961047) | 2 | 7 | 5 | 28859 | 2 | ||||
60331 | 220156 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 64 | Front Yard : Yard | Tree | Private 2 | 4 | 6004516.6061 | 2096115.66582 | 37.7357901701732 | -122.426831148142 | (37.7357901701732, -122.426831148142) | 2 | 7 | 5 | 28861 | 2 | ||||
60784 | 220162 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 25 | Front Yard : Yard | Tree | Private 2 | 33 | 6004904.25494 | 2096495.99975 | 37.7368563920029 | -122.42551795269 | (37.7368563920029, -122.42551795269) | 2 | 7 | 5 | 28859 | 2 | ||||
66434 | 221378 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 190 Storrie St | 17 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6000803.23299 | 2105309.21717 | 37.7608228056365 | -122.440328815537 | (37.7608228056365, -122.440328815537) | 15 | 4 | 5 | 28862 | 3 | |||
67776 | 188594 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Jack Balestreri Way | 2 | Front Yard : Yard | Tree | Private 2 | 16 | 6012410.71719 | 2104764.5597 | 37.7599813531633 | -122.400145172978 | (37.7599813531633, -122.400145172978) | 10 | 3 | 8 | 28856 | 29 | ||||
67882 | 220157 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1201 San Jose Ave | 65 | Front Yard : Yard | Tree | Private 2 | 3 | 6004526.08475 | 2096117.80265 | 37.7357965733541 | -122.426798528853 | (37.7357965733541, -122.426798528853) | 2 | 7 | 5 | 28861 | 2 | ||||
68330 | 220150 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6005133.60427 | 2096768.51614 | 37.7376176168434 | -122.424744371178 | (37.7376176168434, -122.424744371178) | 2 | 7 | 5 | 28859 | 2 | ||||
71099 | 203882 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 16 | Front Yard : Yard | Tree | Private 2 | 10 | Width 0ft | 5991371.09776 | 2095893.61129 | 37.7344284401265 | -122.47226369551 | (37.7344284401265, -122.47226369551) | 1 | 8 | 4 | 64 | 40 | |||
71614 | 221388 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 671 Church St | 57 | Front Yard : Yard | Tree | Private 2 | 17 | Width 3ft | 6004298.75223 | 2105308.17182 | 37.7610183389455 | -122.428239289531 | (37.7610183389455, -122.428239289531) | 2 | 4 | 5 | 28862 | 3 | |||
71845 | 114379 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 443X ARBALLO DR | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5988110 | 2090275 | 37.7188118998372 | -122.483126550771 | (37.7188118998372, -122.483126550771) | 1 | 8 | 4 | 64 | 14 | ||||
72442 | 203880 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 18 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 5991364.83676 | 2095904.51613 | 37.7344580197106 | -122.472286136294 | (37.7344580197106, -122.472286136294) | 1 | 8 | 4 | 64 | 40 | |||
72786 | 220144 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 6003159.40524 | 2095238.92343 | 37.7333060043723 | -122.43146095066 | (37.7333060043723, -122.43146095066) | 2 | 7 | 5 | 28861 | 25 | ||||
76427 | 188664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 501 Amador St | 11 | Front Yard : Yard | Tree | Private 2 | 10 | Width 1ft | 6017799.22634 | 2099547.38372 | 37.745955042685 | -122.381145981202 | (37.745955042685, -122.381145981202) | 10 | 3 | 8 | 58 | 1 | |||
81179 | 175042 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 98 San Diego Ave | 1 | Front Yard : Yard | Tree | Private 2 | 33 | 5992757.09235 | 2086323.81583 | 37.7082322293939 | -122.466776470378 | (37.7082322293939, -122.466776470378) | 9 | 8 | 6 | 28588 | 25 | ||||
81570 | 220168 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 32 | Front Yard : Yard | Tree | Private 2 | 9 | 6004945.76603 | 2096533.5746 | 37.7369619094711 | -122.425377103585 | (37.7369619094711, -122.425377103585) | 2 | 7 | 5 | 28859 | 2 | ||||
83981 | 220193 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 65 | Front Yard : Yard | Tree | Private 2 | 9 | Width 5ft | 6003549.85445 | 2095682.63787 | 37.7345464653385 | -122.430142703749 | (37.7345464653385, -122.430142703749) | 2 | 7 | 5 | 63 | 7 | |||
85020 | 217845 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 35 | Front Yard : Yard | Tree | Private 2 | 24 | 5991433.42379 | 2095847.21705 | 37.7343046601167 | -122.4720448356 | (37.7343046601167, -122.4720448356) | 1 | 8 | 4 | 64 | 40 | ||||
86411 | 249836 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 333 Greenwich St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011225.58487 | 2120372.97732 | 37.8027722652867 | -122.405343196852 | (37.8027722652867, -122.405343196852) | 3 | 1 | 10 | 308 | 23 | |||
87787 | 221368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Sanchez St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 3ft | 6003710.38169 | 2103854.76962 | 37.7569943341355 | -122.43017051797 | (37.7569943341355, -122.43017051797) | 2 | 4 | 5 | 28862 | 3 | |||
90893 | 249812 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 260 Chestnut St | 2 | Front Yard : Yard | Tree | Private 2 | 14 | Width 0ft | 6010650.19801 | 2121033.73963 | 37.8045543690542 | -122.407380948177 | (37.8045543690542, -122.407380948177) | 3 | 1 | 10 | 308 | 23 | |||
91715 | 220278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3925 21st St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6002292.19971 | 2103528.34865 | 37.7560176344239 | -122.435051775442 | (37.7560176344239, -122.435051775442) | 2 | 4 | 5 | 28862 | 22 | ||||
91798 | 173615 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X JUNIPERO SERRA BLVD | 14 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
93424 | 220182 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 7 | 6004985.47233 | 2096611.09675 | 37.7371770110996 | -122.425245335799 | (37.7371770110996, -122.425245335799) | 2 | 7 | 5 | 28859 | 2 | ||||
94888 | 220143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 22nd St | 5 | Front Yard : Yard | Tree | Private 2 | 5 | 6011248.89515 | 2103712.94956 | 37.7570290164987 | -122.404089366557 | (37.7570290164987, -122.404089366557) | 10 | 4 | 8 | 28859 | 19 | ||||
96982 | 220196 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 68 | Front Yard : Yard | Tree | Private 2 | 12 | Width 5ft | 6003535.06176 | 2095676.55127 | 37.7345289150748 | -122.430193412914 | (37.7345289150748, -122.430193412914) | 2 | 7 | 5 | 63 | 7 | |||
97238 | 175009 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 265 Hester Ave | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6012301.72001 | 2087735.75637 | 37.7132177542762 | -122.399326699068 | (37.7132177542762, -122.399326699068) | 10 | 3 | 8 | 309 | 1 | ||||
97511 | 203879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 19 | Front Yard : Yard | Tree | Private 2 | 6 | Width 0ft | 5991366.58351 | 2095910.40405 | 37.7344742875433 | -122.472280526329 | (37.7344742875433, -122.472280526329) | 1 | 8 | 4 | 64 | 40 | |||
101254 | 175012 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6013182.79855 | 2087056.15726 | 37.7114007756959 | -122.396233767795 | (37.7114007756959, -122.396233767795) | 10 | 3 | 8 | 309 | 1 | |||
101335 | 220137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2501 25th St | 5 | Front Yard : Yard | Tree | Private 2 | 17 | 6011439.73612 | 2101810.34595 | 37.7518155467598 | -122.403295523263 | (37.7518155467598, -122.403295523263) | 10 | 4 | 8 | 28859 | 19 | ||||
102160 | 117527 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1099x WALLER ST | 1 | Front Yard : Yard | Tree | Private 2 | 6000071 | 2108311 | 37.769023235971 | -122.44307686155 | (37.769023235971, -122.44307686155) | 15 | 5 | 5 | 29492 | 9 | |||||
102398 | 105415 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 1 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
102741 | 98542 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
102806 | 220188 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 76 | Front Yard : Yard | Tree | Private 2 | 6 | 6004898.43848 | 2096540.40011 | 37.736977976744 | -122.425541221768 | (37.736977976744, -122.425541221768) | 2 | 7 | 5 | 28859 | 2 | ||||
106101 | 107308 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 190 EUCALYPTUS DR | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 5990695.4 | 2094728.8 | 37.7311910349726 | -122.474514801842 | (37.7311910349726, -122.474514801842) | 1 | 8 | 4 | 64 | 40 | ||||
107627 | 220184 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 72 | Front Yard : Yard | Tree | Private 2 | 14 | 6004926.8696 | 2096549.97699 | 37.7370058791054 | -122.425443603957 | (37.7370058791054, -122.425443603957) | 2 | 7 | 5 | 28859 | 2 | ||||
107652 | 220177 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 42 | Front Yard : Yard | Tree | Private 2 | 31 | 6004978.16757 | 2096563.63573 | 37.7370462811452 | -122.425267215414 | (37.7370462811452, -122.425267215414) | 2 | 7 | 5 | 28859 | 2 | ||||
107957 | 94851 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1107 Bowdoin St | 2 | Front Yard : Yard | Tree | Private 2 | 11/17/2010 12:00:00 AM | 12 | Permit Number 774691 | 6009593 | 2091048 | 37.7221611506882 | -122.408922553301 | (37.7221611506882, -122.408922553301) | 10 | 3 | 7 | 309 | 28 | ||
108941 | 188566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 901 Iowa St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6014791.61868 | 2102890.82424 | 37.7549689439879 | -122.391779701799 | (37.7549689439879, -122.391779701799) | 10 | 3 | 8 | 28856 | 29 | ||||
113928 | 220167 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 31 | Front Yard : Yard | Tree | Private 2 | 13 | 6004945.26232 | 2096528.1578 | 37.7369470076993 | -122.425378459774 | (37.7369470076993, -122.425378459774) | 2 | 7 | 5 | 28859 | 2 | ||||
114090 | 220194 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 13 | Width 5ft | 6003545.8031 | 2095679.42322 | 37.7345374091774 | -122.430156481356 | (37.7345374091774, -122.430156481356) | 2 | 7 | 5 | 63 | 7 | |||
114223 | 105416 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 2 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
115084 | 104751 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 13X JUAN BAUTISTA CIR | 2 | Front Yard : Yard | Tree | Private 2 | 5989494 | 2090180 | 37.7186314952818 | -122.47833572412 | (37.7186314952818, -122.47833572412) | 1 | 8 | 4 | 64 | 14 | |||||
116008 | 188572 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 22 | Front Yard : Yard | Tree | Private 2 | 1 | 6014321.61552 | 2106524.04213 | 37.764918870439 | -122.393659397268 | (37.764918870439, -122.393659397268) | 14 | 3 | 8 | 310 | 29 | ||||
116509 | 98545 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
119294 | 203878 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Cranleigh Dr | 20 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 5991362.95772 | 2095918.02159 | 37.7344949935417 | -122.472293616873 | (37.7344949935417, -122.472293616873) | 1 | 8 | 4 | 64 | 40 | |||
121122 | 220172 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 36 | Front Yard : Yard | Tree | Private 2 | 13 | 6004959.70888 | 2096542.80768 | 37.7369880491675 | -122.425329553743 | (37.7369880491675, -122.425329553743) | 2 | 7 | 5 | 28859 | 2 | ||||
121173 | 125287 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 945 Green St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6008576.87154 | 2118976.92053 | 37.7987905960632 | -122.414410284916 | (37.7987905960632, -122.414410284916) | 5 | 1 | 10 | 308 | 21 | ||||
123051 | 97973 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 3 | Front Yard : Yard | Tree | Private 2 | 21 | 3x105 | Permit Number 767976 | 6008571.29393 | 2094144.04925 | 37.7306049589414 | -122.412673118464 | (37.7306049589414, -122.412673118464) | 9 | 3 | 7 | 309 | 28 | ||
124179 | 221369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Sanchez St | 2 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6003690.30976 | 2103870.989 | 37.7570377318327 | -122.430241091376 | (37.7570377318327, -122.430241091376) | 2 | 4 | 5 | 28862 | 3 | |||
124470 | 105858 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1580 Valencia St | 18 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
126565 | 220161 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 23 | Front Yard : Yard | Tree | Private 2 | 23 | 6004865.4895 | 2096506.15272 | 37.7368820793529 | -122.42565270441 | (37.7368820793529, -122.42565270441) | 2 | 7 | 5 | 28859 | 2 | ||||
127471 | 220164 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 San Jose Ave | 28 | Front Yard : Yard | Tree | Private 2 | 23 | 6004931.31387 | 2096515.53098 | 37.7369115492209 | -122.425425787491 | (37.7369115492209, -122.425425787491) | 2 | 7 | 5 | 28859 | 2 | ||||
128003 | 249705 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2400 Baker St | 37 | Front Yard : Yard | Tree | Private 2 | 23 | 5999691.23036 | 2117200.88619 | 37.7934109100399 | -122.445029631231 | (37.7934109100399, -122.445029631231) | 13 | 9 | 1 | 57 | 27 | ||||
128560 | 250218 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 310 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011294.98745 | 2120066.49067 | 37.8019346079448 | -122.40508143388 | (37.8019346079448, -122.40508143388) | 3 | 1 | 10 | 308 | 23 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );