trees
3,965 rows where qSpecies_id = 70 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72037 | 100067 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 93 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | On property line with 99 Buena Vista Ter | 6001505.1 | 2107681.4 | 37.7673761743712 | -122.438071302911 | (37.7673761743712, -122.438071302911) | 15 | 5 | 5 | 29492 | 3 | |||
127087 | 100123 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
47901 | 100204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | 5x5 | 6001902.2596 | 2114280.466 | 37.7855181330415 | -122.437170124873 | (37.7855181330415, -122.437170124873) | 13 | 6 | 11 | 29490 | 13 | |||
153968 | 100245 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 539 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 5x4 | 5990297.62552 | 2111697.27561 | 37.7777589234968 | -122.477129482371 | (37.7777589234968, -122.477129482371) | 11 | 6 | 2 | 55 | 26 | |||
25531 | 100246 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 539 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 7x4 | 5990298.61194 | 2111686.34529 | 37.7777289690844 | -122.477125271101 | (37.7777289690844, -122.477125271101) | 11 | 6 | 2 | 55 | 26 | |||
139746 | 100371 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 836 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Permit Number 22564 | 6011703.37581 | 2118243.83114 | 37.7969528476575 | -122.403539900553 | (37.7969528476575, -122.403539900553) | 3 | 1 | 10 | 308 | 4 | |||
190907 | 100386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5989668.805 | 2104235.219 | 37.7572336462205 | -122.478758883384 | (37.7572336462205, -122.478758883384) | 1 | 8 | 3 | 56 | 35 | |||
69398 | 100387 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5989667.3817 | 2104248.5033 | 37.7572700387148 | -122.478764777193 | (37.7572700387148, -122.478764777193) | 1 | 8 | 3 | 56 | 35 | |||
178622 | 100392 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769124 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
110591 | 100393 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
91712 | 100394 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
134008 | 100395 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1800X Lincoln Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 18187 | 5990148.1 | 2107238.4 | 37.7655073938756 | -122.477320788075 | (37.7655073938756, -122.477320788075) | 11 | 8 | 2 | 29492 | 8 | ||||
54213 | 100653 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1594 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 5992503 | 2104630 | 37.7584817696578 | -122.468985951036 | (37.7584817696578, -122.468985951036) | 1 | 8 | 4 | 56 | 12 | ||||
106719 | 100655 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 590X Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992492.1 | 2104587.3 | 37.7583638968548 | -122.469020540261 | (37.7583638968548, -122.469020540261) | 1 | 8 | 4 | 56 | 12 | |||||
181165 | 100656 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 590X Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992503 | 2104630 | 37.7584817696578 | -122.468985951036 | (37.7584817696578, -122.468985951036) | 1 | 8 | 4 | 56 | 12 | |||||
58541 | 100788 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 29 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x28 | 5990804.26577 | 2114865.56876 | 37.786487558431 | -122.475608262715 | (37.786487558431, -122.475608262715) | 11 | 6 | 1 | 54 | 33 | |||
4435 | 100789 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 29 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | 6x25 | Permit Number 27110 | 5990777 | 2114840 | 37.7864157730855 | -122.475700726719 | (37.7864157730855, -122.475700726719) | 11 | 6 | 1 | 54 | 33 | ||
159964 | 100837 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
57232 | 100838 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
167296 | 101002 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
139471 | 101005 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
69214 | 101006 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
116351 | 101007 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
170998 | 101008 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
145004 | 101009 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
165399 | 101010 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
17877 | 101023 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3024 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999465 | 2119192 | 37.7988650643156 | -122.445955676486 | (37.7988650643156, -122.445955676486) | 13 | 9 | 1 | 57 | 17 | ||||
36852 | 101136 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1477 Grove St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000824.6116 | 2110666.7087 | 37.7755343608772 | -122.440639163585 | (37.7755343608772, -122.440639163585) | 15 | 5 | 11 | 29492 | 10 | |||
33600 | 101137 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1477 Grove St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000842.8876 | 2110669.9339 | 37.7755442571847 | -122.440576174035 | (37.7755442571847, -122.440576174035) | 15 | 5 | 11 | 29492 | 10 | |||
146730 | 101287 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3355X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | 13 | 9 | 1 | 57 | 17 | ||||
20303 | 101420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000374.3516 | 2116185.0207 | 37.7906605745677 | -122.442593016179 | (37.7906605745677, -122.442593016179) | 13 | 6 | 1 | 29490 | 27 | ||||
86612 | 101421 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6000370.97152 | 2116196.31251 | 37.7906913862526 | -122.442605522132 | (37.7906913862526, -122.442605522132) | 13 | 6 | 1 | 29490 | 27 | ||||
54170 | 101422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6000369.95559 | 2116208.82574 | 37.790725686401 | -122.442609936018 | (37.790725686401, -122.442609936018) | 13 | 6 | 1 | 29490 | 27 | ||||
179309 | 101423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6000367.44733 | 2116221.15803 | 37.7907594046669 | -122.442619500284 | (37.7907594046669, -122.442619500284) | 13 | 6 | 1 | 29490 | 27 | ||||
46123 | 101424 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2200 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6000365.03159 | 2116237.93468 | 37.7908053312568 | -122.442629063689 | (37.7908053312568, -122.442629063689) | 13 | 6 | 1 | 29490 | 27 | ||||
49584 | 101654 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 465 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 5991223.42773 | 2112267.5766 | 37.7793784815584 | -122.473968464522 | (37.7793784815584, -122.473968464522) | 11 | 6 | 2 | 54 | 26 | ||||
134250 | 102012 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992512.8 | 2104342 | 37.7576915632091 | -122.468931100171 | (37.7576915632091, -122.468931100171) | 1 | 8 | 4 | 56 | 12 | ||||
173233 | 102013 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992512.8 | 2104342 | 37.7576915632091 | -122.468931100171 | (37.7576915632091, -122.468931100171) | 1 | 8 | 4 | 56 | 12 | ||||
108647 | 102014 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992512.8 | 2104342 | 37.7576915632091 | -122.468931100171 | (37.7576915632091, -122.468931100171) | 1 | 8 | 4 | 56 | 12 | ||||
69126 | 102186 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3999X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
160561 | 102187 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3999X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
118067 | 102444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001528.5407 | 2088896.6516 | 37.7157989956067 | -122.436645469419 | (37.7157989956067, -122.436645469419) | 9 | 7 | 6 | 28861 | 5 | |||
38057 | 102472 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 66 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x15 | 5993897.9 | 2101386.8 | 37.7496572701738 | -122.463926385697 | (37.7496572701738, -122.463926385697) | 1 | 8 | 4 | 29491 | 40 | ||||
45882 | 10255 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 140 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005448.27784 | 2109623.58668 | 37.7729324136912 | -122.424570554491 | (37.7729324136912, -122.424570554491) | 7 | 9 | 11 | 28852 | 10 | |||
77281 | 10256 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/18/1998 12:00:00 AM | 30 | 3X3 | 6005382.9385 | 2109612.15 | 37.7728973211229 | -122.424795757535 | (37.7728973211229, -122.424795757535) | 7 | 9 | 11 | 28852 | 10 | ||
67590 | 10261 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X4 | 6005221.62679 | 2109603.34443 | 37.772864030808 | -122.425353127526 | (37.772864030808, -122.425353127526) | 7 | 9 | 11 | 28852 | 10 | |||
119753 | 102623 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 351 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010148.1574 | 2120916.7901 | 37.8042051428233 | -122.409110056734 | (37.8042051428233, -122.409110056734) | 3 | 1 | 10 | 308 | 23 | |||
48043 | 102629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 769953 | 5988063.8153 | 2114882.99878 | 37.7863761669029 | -122.485090700066 | (37.7863761669029, -122.485090700066) | 11 | 6 | 1 | 55 | 33 | |||
55934 | 10263 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 212 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6005030.70582 | 2109564.31462 | 37.7727460760509 | -122.426010766966 | (37.7727460760509, -122.426010766966) | 7 | 9 | 11 | 28852 | 10 | |||
170016 | 102630 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 168 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988081.5 | 2114873.1 | 37.7863500177909 | -122.485028789744 | (37.7863500177909, -122.485028789744) | 11 | 6 | 1 | 55 | 33 | |||||
193946 | 102631 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 175 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769999 | 5987997.5 | 2114816.6 | 37.7861899917282 | -122.485315257259 | (37.7861899917282, -122.485315257259) | 11 | 6 | 1 | 55 | 33 | |||
66025 | 102707 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 369 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5991523.74054 | 2112932.53548 | 37.7812216665299 | -122.472978070118 | (37.7812216665299, -122.472978070118) | 11 | 6 | 2 | 54 | 26 | |||
96805 | 10274 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 218 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/2016 03:07:00 PM | 3 | 3x3 | 6004921.53459 | 2109545.14882 | 37.7726872808276 | -122.426387037745 | (37.7726872808276, -122.426387037745) | 7 | 9 | 11 | 28852 | 10 | ||
55738 | 102747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x5 | Permit Number 20974 | 6001053.30266 | 2118369.08064 | 37.7966961109838 | -122.44040059224 | (37.7966961109838, -122.44040059224) | 13 | 9 | 1 | 57 | 17 | ||
37965 | 102748 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2900 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x5 | Permit Number 20974 | 6001048.4849 | 2118395.31546 | 37.7967678705825 | -122.440419145231 | (37.7967678705825, -122.440419145231) | 13 | 9 | 1 | 57 | 17 | ||
107256 | 10275 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 222 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3x3 | 6004852.27648 | 2109616.19972 | 37.7728784541117 | -122.426631669617 | (37.7728784541117, -122.426631669617) | 7 | 9 | 11 | 28852 | 10 | |||
127301 | 102753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 542 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 3x9 | 5992553.89583 | 2111741.50306 | 37.778011002181 | -122.469327555756 | (37.778011002181, -122.469327555756) | 11 | 6 | 2 | 54 | 11 | |||
84507 | 102800 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 708 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5995062.7103 | 2110691.85511 | 37.7752736059254 | -122.460572652238 | (37.7752736059254, -122.460572652238) | 11 | 6 | 2 | 54 | 11 | ||||
24935 | 102801 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 708 03rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5995061.23686 | 2110707.05181 | 37.7753152472732 | -122.460578850624 | (37.7753152472732, -122.460578850624) | 11 | 6 | 2 | 54 | 11 | ||||
36060 | 102802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1245 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5987672.179 | 2106793.3292 | 37.7641413829477 | -122.485851660773 | (37.7641413829477, -122.485851660773) | 1 | 8 | 3 | 56 | 35 | |||
42073 | 10282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 359 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6004422.78828 | 2109427.83457 | 37.7723369589176 | -122.428103893873 | (37.7723369589176, -122.428103893873) | 7 | 9 | 11 | 28852 | 10 | |||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
175106 | 10290 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 457 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003955.27989 | 2109364.91773 | 37.7721377428856 | -122.429716559981 | (37.7721377428856, -122.429716559981) | 7 | 9 | 11 | 29492 | 10 | |||
151084 | 10296 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 533 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6003575.42628 | 2109315.11731 | 37.7719794864975 | -122.431026949543 | (37.7719794864975, -122.431026949543) | 15 | 9 | 11 | 29492 | 10 | |||
99902 | 10298 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 545 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6003525.02911 | 2109303.72593 | 37.77194535274 | -122.431200463837 | (37.77194535274, -122.431200463837) | 15 | 9 | 11 | 29492 | 10 | |||
40929 | 10306 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 618- 620 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 33 | 7x5 | 6003056.4779 | 2109285.6248 | 37.7718690881058 | -122.432819922419 | (37.7718690881058, -122.432819922419) | 15 | 5 | 11 | 29492 | 9 | |||
190128 | 10319 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | 15 | 5 | 11 | 29492 | 9 | |||
139105 | 10325 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 807 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6002259.27538 | 2109123.5178 | 37.7713787357685 | -122.435565898974 | (37.7713787357685, -122.435565898974) | 15 | 5 | 11 | 29492 | 9 | |||
107746 | 103283 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3195X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998987.7 | 2116257.6 | 37.790780717413 | -122.447395962042 | (37.790780717413, -122.447395962042) | 13 | 6 | 1 | 29490 | 31 | ||||
180748 | 10329 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 826 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6002169.5428 | 2109164.521 | 37.7714862234563 | -122.435879222083 | (37.7714862234563, -122.435879222083) | 15 | 5 | 11 | 29492 | 9 | |||
67508 | 10334 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 850 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6002067 | 2109164 | 37.7714789673294 | -122.436233885162 | (37.7714789673294, -122.436233885162) | 15 | 5 | 11 | 29492 | 9 | |||
165440 | 10335 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 860 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 4x4 | 6002028.0975 | 2109143.8299 | 37.7714213748567 | -122.436367006921 | (37.7714213748567, -122.436367006921) | 15 | 5 | 11 | 29492 | 9 | |||
15453 | 103382 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3199X JACKSON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999158 | 2116301 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | 13 | 6 | 1 | 29490 | 31 | |||||
95102 | 103383 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3199X JACKSON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999158 | 2116301 | 37.7909096124749 | -122.446809858862 | (37.7909096124749, -122.446809858862) | 13 | 6 | 1 | 29490 | 31 | |||||
50841 | 103385 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999013 | 2116197 | 37.7906157715272 | -122.447304062173 | (37.7906157715272, -122.447304062173) | 13 | 6 | 1 | 29490 | 31 | ||||
101910 | 103408 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
188484 | 103409 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
87109 | 103410 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 201 Executive Park Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 56795 | 6014240.56167 | 2087011.24615 | 37.7113362593892 | -122.392574697929 | (37.7113362593892, -122.392574697929) | 10 | 3 | 8 | 58 | 1 | ||||
162685 | 103476 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 147 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2013 12:00:00 AM | Permit Number 775299 | 6001179.7 | 2121217.2 | 37.8045234887457 | -122.440167571349 | (37.8045234887457, -122.440167571349) | 13 | 9 | 1 | 57 | 17 | |||
99326 | 103488 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001028.36335 | 2117564.66729 | 37.7944859830059 | -122.440429166379 | (37.7944859830059, -122.440429166379) | 13 | 9 | 1 | 57 | 27 | |||
165087 | 103489 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6001042.45399 | 2117566.1251 | 37.7944907880724 | -122.440380515743 | (37.7944907880724, -122.440380515743) | 13 | 9 | 1 | 57 | 27 | |||
33368 | 103490 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2601 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6001053.62878 | 2117568.22705 | 37.7944971957398 | -122.440342000495 | (37.7944971957398, -122.440342000495) | 13 | 9 | 1 | 57 | 27 | |||
128434 | 10359 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1060 HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X4 | 6001056 | 2109004 | 37.770982153968 | -122.439719505856 | (37.770982153968, -122.439719505856) | 15 | 5 | 11 | 29492 | 9 | |||
98161 | 10360 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1080 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6000968.2773 | 2109001.3276 | 37.7709698227664 | -122.440022748836 | (37.7709698227664, -122.440022748836) | 15 | 5 | 11 | 29492 | 9 | |||
121312 | 10362 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1126 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X4 | 6000713.44362 | 2108968.6618 | 37.7708656202791 | -122.440901879767 | (37.7708656202791, -122.440901879767) | 15 | 5 | 11 | 29492 | 9 | |||
164112 | 10363 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1136 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X4 | 6000656.6881 | 2108954.0474 | 37.7708222602121 | -122.441097149265 | (37.7708222602121, -122.441097149265) | 15 | 5 | 11 | 29492 | 9 | |||
89100 | 10367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6000483.5353 | 2108928.9047 | 37.7707433605012 | -122.441694282188 | (37.7707433605012, -122.441694282188) | 15 | 5 | 11 | 29492 | 9 | |||
3152 | 10368 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000449.8535 | 2108924.1608 | 37.7707284158065 | -122.441810447284 | (37.7707284158065, -122.441810447284) | 15 | 5 | 11 | 29492 | 9 | |||
112014 | 10369 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X4 | 6000434.46289 | 2108927.97129 | 37.7707380014845 | -122.44186395705 | (37.7707380014845, -122.44186395705) | 15 | 5 | 11 | 29492 | 9 | |||
97143 | 10371 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1202 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6000331.2557 | 2108908.0315 | 37.7706773703693 | -122.442219519892 | (37.7706773703693, -122.442219519892) | 15 | 5 | 11 | 29492 | 9 | |||
37448 | 10372 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1216 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6000283.8166 | 2108900.9156 | 37.7706551281266 | -122.442383101019 | (37.7706551281266, -122.442383101019) | 15 | 5 | 11 | 29492 | 9 | |||
71178 | 10373 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1234 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 9x5 | 6000208.6256 | 2108891.1906 | 37.770624139779 | -122.44264248857 | (37.770624139779, -122.44264248857) | 15 | 5 | 11 | 29492 | 9 | |||
94708 | 10376 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1255X Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 21x6 | 6000170.7774496 | 2108835.6049214 | 37.7704693578958 | -122.442769413392 | (37.7704693578958, -122.442769413392) | 15 | 5 | 5 | 29492 | 9 | |||
30901 | 103929 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 191 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5994248.3 | 2114379.9 | 37.7853530981444 | -122.463657591004 | (37.7853530981444, -122.463657591004) | 11 | 6 | 1 | 54 | 11 | ||||
142547 | 103938 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6008916.3437 | 2121176.0576 | 37.8048479427137 | -122.413391203795 | (37.8048479427137, -122.413391203795) | 3 | 1 | 10 | 308 | 23 | ||||
73593 | 103939 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 6008915.3132 | 2121187.3941 | 37.8048790120409 | -122.413395572179 | (37.8048790120409, -122.413395572179) | 3 | 1 | 10 | 308 | 23 | ||||
16200 | 103940 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2300 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008943.2 | 2121170.5 | 37.804834190774 | -122.413297871125 | (37.804834190774, -122.413297871125) | 3 | 1 | 10 | 308 | 23 | |||||
185590 | 10422 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1407 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5999387.74957 | 2108726.34207 | 37.7701246795762 | -122.445470043217 | (37.7701246795762, -122.445470043217) | 15 | 5 | 11 | 29492 | 9 | |||
77456 | 10426 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1418 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x4 | 5999318.43579 | 2108766.88191 | 37.7702320345214 | -122.44571271379 | (37.7702320345214, -122.44571271379) | 15 | 5 | 11 | 29492 | 9 | |||
40559 | 104272 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3675 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997210.1 | 2115656.5 | 37.7890285184352 | -122.453502918425 | (37.7890285184352, -122.453502918425) | 11 | 6 | 1 | 54 | 31 |
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) );