trees
3,965 rows where qSpecies_id = 70 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
756 | 124716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
1032 | 39972 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
1424 | 264758 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
1460 | 30324 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 720 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | 3 | 1 | 10 | 28860 | 4 | |||
1631 | 30310 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 8 | ||||||||||||||
1633 | 50106 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46830 | 5992376.29027554 | 2096837.8582672 | 37.7370792283941 | -122.468857136293 | (37.7370792283941, -122.468857136293) | 1 | 8 | 4 | 59 | 40 | ||
1875 | 261661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 741 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 5986614 | 2110873 | 37.7752812973329 | -122.489811603249 | (37.7752812973329, -122.489811603249) | 11 | 6 | 2 | 55 | 26 | ||||
2063 | 87007 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
2101 | 117036 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2220x SUTTER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
2343 | 99661 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1365 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.465323151466 | (37.7394617231066, -122.465323151466) | 1 | 8 | 4 | 59 | 40 | |||||
2829 | 264759 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007165 | 2087428 | 37.7120850908031 | -122.417059211527 | (37.7120850908031, -122.417059211527) | 9 | 7 | 8 | 309 | 39 | ||||
2948 | 34162 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1321 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1997 12:00:00 AM | Permit Number 37995 | 6002005.24557776 | 2100252.01136141 | 37.7470052949129 | -122.435809748575 | (37.7470052949129, -122.435809748575) | 2 | 7 | 5 | 63 | 22 | |||
3045 | 261353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 160 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5990864 | 2091394 | 37.7220442755547 | -122.473688749933 | (37.7220442755547, -122.473688749933) | 9 | 8 | 4 | 64 | 40 | ||||
3286 | 264753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 176 Hahn St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
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 | |||||
3691 | 121048 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2652 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6006192.78395747 | 2119877.54417008 | 37.8011292630692 | -122.422724050002 | (37.8011292630692, -122.422724050002) | 13 | 9 | 1 | 28858 | 32 | ||||
3768 | 262321 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990975 | 2093805 | 37.7286707085155 | -122.473480827138 | (37.7286707085155, -122.473480827138) | 9 | 8 | 4 | 64 | 40 | ||||
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 | |||||
3857 | 104292 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2245 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999485.4 | 2120797.2 | 37.8032736772553 | -122.446000602494 | (37.8032736772553, -122.446000602494) | 13 | 9 | 1 | 57 | 17 | |||||
4509 | 262192 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799x 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992411 | 2103494 | 37.7553572944486 | -122.469221443954 | (37.7553572944486, -122.469221443954) | 1 | 8 | 4 | 56 | 12 | ||||
4735 | 262469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 35 Broadmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2x6 | 5991096 | 2093545 | 37.7279638199594 | -122.4730435743 | (37.7279638199594, -122.4730435743) | 9 | 8 | 4 | 64 | 40 | ||||
4872 | 262191 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1799x 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992411 | 2103494 | 37.7553572944486 | -122.469221443954 | (37.7553572944486, -122.469221443954) | 1 | 8 | 4 | 56 | 12 | ||||
5261 | 262386 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 198 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6005187.2243 | 2109578.99326 | 37.7727952246844 | -122.425470396534 | (37.7727952246844, -122.425470396534) | 7 | 9 | 11 | 28852 | 10 | ||||
5419 | 87002 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | 3x3 | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | ||
5429 | 116488 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2149 LYON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999319 | 2116238 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | 13 | 6 | 1 | 29490 | 31 | |||||
5712 | 258876 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1326 Hayes St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 0ft | 6001504 | 2110473 | 37.7750411502564 | -122.438275119801 | (37.7750411502564, -122.438275119801) | 15 | 5 | 11 | 29492 | 10 | ||||
6698 | 261941 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Verna St | 6 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
6759 | 111228 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
6854 | 39379 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.418561678075 | (37.7674774616365, -122.418561678075) | 8 | 4 | 7 | 28853 | 19 | |||
7087 | 261756 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 310 30th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004309 | 2098427 | 37.7421248276758 | -122.427713553768 | (37.7421248276758, -122.427713553768) | 2 | 7 | 5 | 63 | 22 | ||||
7197 | 116162 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2569 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000631 | 2118874 | 37.7980584318084 | -122.441898109379 | (37.7980584318084, -122.441898109379) | 13 | 9 | 1 | 57 | 17 | ||||
7206 | 264879 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 94 Stratford Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4x6 | 5990921 | 2091777 | 37.7230991995598 | -122.473519640019 | (37.7230991995598, -122.473519640019) | 9 | 8 | 4 | 64 | 40 | ||||
7388 | 29904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 Fell St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | 7 | 9 | 11 | 28852 | 10 | ||||||
7482 | 30852 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
8318 | 98543 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
9246 | 254278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Junipero Serra Blvd | 2 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
9702 | 254280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Junipero Serra Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||||
9708 | 261204 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007215 | 2095432 | 37.7340651744382 | -122.417453284567 | (37.7340651744382, -122.417453284567) | 2 | 7 | 7 | 28859 | 2 | ||||
9883 | 262003 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1503X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 5984810 | 2104956 | 37.7589293895364 | -122.495615433308 | (37.7589293895364, -122.495615433308) | 1 | 8 | 3 | 56 | 35 | ||||
10456 | 118326 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3200 CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999426 | 2115708 | 37.7892966967134 | -122.445839927288 | (37.7892966967134, -122.445839927288) | 13 | 6 | 1 | 29490 | 31 | ||||
11391 | 260515 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 487 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 784711 | 5989595 | 2094714 | 37.7310865793073 | -122.478317956131 | (37.7310865793073, -122.478317956131) | 1 | 8 | 4 | 64 | 14 | |||
11723 | 93875 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997572 | 2107825 | 37.7675460011803 | -122.451685641377 | (37.7675460011803, -122.451685641377) | 15 | 5 | 11 | 29492 | 9 | |||||
12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
12411 | 260714 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Lyon St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 784756 | 5999390 | 2116615 | 37.7917850243096 | -122.446029746387 | (37.7917850243096, -122.446029746387) | 13 | 6 | 1 | 29490 | 27 | |||
12733 | 102843 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
12775 | 260566 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Denslowe Dr | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 5990592.24818 | 2090826.09743 | 37.7204692135739 | -122.474586693137 | (37.7204692135739, -122.474586693137) | 9 | 8 | 4 | 64 | 40 | |||||
13685 | 261983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403 Keith St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
14158 | 99903 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
14404 | 261203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 601X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007215 | 2095432 | 37.7340651744382 | -122.417453284567 | (37.7340651744382, -122.417453284567) | 2 | 7 | 7 | 28859 | 2 | ||||
14545 | 30309 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 8 | ||||||||||||||
15254 | 260460 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1798X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | ||||
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 | |||||
15697 | 40095 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | 13 | 6 | 11 | 29490 | 13 | |||
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 | |||||
17223 | 39975 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
17569 | 98514 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328 | (37.7238271478872, -122.45935081328) | 9 | 8 | 4 | 28861 | 24 | ||||
17786 | 258887 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1251 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 6005937.37607 | 2114355.05187 | 37.785951472517 | -122.423215093814 | (37.785951472517, -122.423215093814) | 13 | 9 | 1 | 28858 | 41 | ||||
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 | ||||
18268 | 262388 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1525 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6016246.49948 | 2097351.8889 | 37.739840829559 | -122.38636210374 | (37.739840829559, -122.38636210374) | 10 | 3 | 8 | 58 | 1 | |||||
18941 | 264761 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 240 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007356 | 2087104 | 37.7112061971181 | -122.416376123926 | (37.7112061971181, -122.416376123926) | 9 | 7 | 8 | 309 | 39 | ||||
18948 | 51496 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.440129480361 | (37.773809648853, -122.440129480361) | 15 | 5 | 11 | 29492 | 10 | |||
20338 | 30322 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 720 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/1956 12:00:00 AM | Permit Number 16 | 6011772.9424544 | 2117800.56968196 | 37.7957396438077 | -122.403267984357 | (37.7957396438077, -122.403267984357) | 3 | 1 | 10 | 28860 | 4 | |||
20469 | 114842 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2670 LEAVENWORTH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007398 | 2121652 | 37.8060693936166 | -122.418679378695 | (37.8060693936166, -122.418679378695) | 5 | 1 | 1 | 308 | 23 | ||||
21465 | 104273 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3675 Washington St | 2 | 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 | ||||
22201 | 121023 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||||
22295 | 99908 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
22336 | 98569 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301X Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |||
22388 | 98555 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2360 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991737.8 | 2099355.8 | 37.7439559460975 | -122.471248063337 | (37.7439559460975, -122.471248063337) | 1 | 8 | 4 | 29491 | 40 | |||||
23492 | 99901 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
23626 | 99853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 755 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | Permit Number 768797 | 5999383.5 | 2121460.3 | 37.8050885512442 | -122.446400961387 | (37.8050885512442, -122.446400961387) | 13 | 9 | 1 | 57 | 17 | |||
23787 | 50103 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1530 Portola Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.7372215720402 | -122.468657807095 | (37.7372215720402, -122.468657807095) | 1 | 8 | 4 | 59 | 40 | ||
24114 | 116895 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 998X KIRKHAM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991857 | 2105283 | 37.7602373900467 | -122.471267663471 | (37.7602373900467, -122.471267663471) | 1 | 8 | 4 | 56 | 12 | ||||
24319 | 106459 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 125 HANCOCK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003462.6 | 2105028.1 | 37.7602019821643 | -122.431111184527 | (37.7602019821643, -122.431111184527) | 2 | 4 | 5 | 28862 | 3 | ||||
25186 | 98556 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2360 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5991737.8 | 2099355.8 | 37.7439559460975 | -122.471248063337 | (37.7439559460975, -122.471248063337) | 1 | 8 | 4 | 29491 | 40 | |||||
25306 | 116489 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2149 LYON ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999319 | 2116238 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | 13 | 6 | 1 | 29490 | 31 | ||||
25335 | 87291 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 763 45th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/19/2008 12:00:00 AM | Permit Number 50306 | 5981945.1 | 2110561.2 | 37.7741514699411 | -122.505938997766 | (37.7741514699411, -122.505938997766) | 11 | 6 | 2 | 55 | 26 | |||
25512 | 87006 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
25711 | 111769 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 855 MONTEREY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996319 | 2094654 | 37.7313098799379 | -122.455067728735 | (37.7313098799379, -122.455067728735) | 9 | 7 | 4 | 28861 | 40 | ||||
26139 | 253819 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100x Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001057 | 2086858 | 37.7101745029318 | -122.43812937572 | (37.7101745029318, -122.43812937572) | 9 | 7 | 6 | 28861 | 5 | |||||
26390 | 97260 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1994@ Octavia Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004661.4 | 2117107.1 | 37.7934358122691 | -122.427825787413 | (37.7934358122691, -122.427825787413) | 13 | 9 | 1 | 28858 | 27 | |||||
26922 | 40094 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2249 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/1999 12:00:00 AM | Permit Number 41318 | 6001849.57530622 | 2114273.14459713 | 37.7854950354219 | -122.437351872267 | (37.7854950354219, -122.437351872267) | 13 | 6 | 11 | 29490 | 13 | |||
27626 | 48436 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 555 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | Permit Number 45813 | 5993118.67686511 | 2111697.80509175 | 37.7779236404027 | -122.467370615227 | (37.7779236404027, -122.467370615227) | 11 | 6 | 2 | 54 | 11 | |||
28495 | 110830 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 55x HILLWAY AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996252 | 2106562 | 37.7640024435914 | -122.456159994784 | (37.7640024435914, -122.456159994784) | 15 | 5 | 11 | 29492 | 12 | ||||
28555 | 112249 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 133X EUCALYPTUS DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991186 | 2094598 | 37.730860304248 | -122.472809193365 | (37.730860304248, -122.472809193365) | 9 | 8 | 4 | 64 | 40 | ||||
28763 | 30315 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.7926503347532 | -122.412449106972 | (37.7926503347532, -122.412449106972) | 3 | 1 | 10 | 28857 | 21 | |||
28825 | 30290 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | 9 | 3 | 7 | 309 | 28 | |||
28878 | 256354 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 120 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.7637806720109 | -122.495681237536 | (37.7637806720109, -122.495681237536) | 1 | 8 | 3 | 56 | 35 | ||||
29051 | 44174 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3898 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.7887563568945 | -122.457199029036 | (37.7887563568945, -122.457199029036) | 11 | 6 | 1 | 54 | 31 | ||
29542 | 85499 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Nebraska St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
29875 | 120994 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
30315 | 114947 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 146 STRATFORD DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990875 | 2091468 | 37.7222480982686 | -122.473656121456 | (37.7222480982686, -122.473656121456) | 9 | 8 | 4 | 64 | 40 | ||||
30371 | 120985 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
30545 | 111071 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1908 15TH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5991632 | 2102414 | 37.7523468518329 | -122.471836728689 | (37.7523468518329, -122.471836728689) | 1 | 8 | 4 | 29491 | 12 | ||||
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 | ||||
31158 | 117161 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1383X VERMONT ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6011571 | 2102081 | 37.7525660338429 | -122.402860625738 | (37.7525660338429, -122.402860625738) | 10 | 3 | 8 | 28856 | 29 | |||||
31329 | 66977 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 87 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1992 12:00:00 AM | 3x3 | Permit Number 51959 | 6008713.44526342 | 2098219.93166523 | 37.7418044249338 | -122.412469676471 | (37.7418044249338, -122.412469676471) | 10 | 7 | 7 | 28859 | 2 | ||
31720 | 254395 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1286 26th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 781556 | 5988061 | 2106558 | 37.7635178832746 | -122.484489596097 | (37.7635178832746, -122.484489596097) | 1 | 8 | 3 | 56 | 35 |
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) );