trees
8,659 rows where qSpecies_id = 11 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41135 | 249482 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6006310.58907 | 2115387.0991 | 37.7888062741271 | -122.421997218416 | (37.7888062741271, -122.421997218416) | 13 | 9 | 1 | 28858 | 21 | |||
42328 | 29773 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1323 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007274.40422 | 2121764.03489 | 37.8063700535072 | -122.41911505491 | (37.8063700535072, -122.41911505491) | 5 | 1 | 1 | 28858 | 32 | ||
42472 | 250057 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1353 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006085.94998 | 2114865.54265 | 37.7873615375443 | -122.422737359534 | (37.7873615375443, -122.422737359534) | 13 | 9 | 1 | 28858 | 41 | |||
42721 | 49663 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 7 | Permit Number 46510 | 6000228.83335 | 2120782.17575 | 37.8032748487093 | -122.443426854966 | (37.8032748487093, -122.443426854966) | 13 | 9 | 1 | 57 | 17 | ||
43306 | 18899 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2575 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6002504.45373 | 2115758.05504 | 37.7896094280702 | -122.435192436588 | (37.7896094280702, -122.435192436588) | 13 | 9 | 1 | 29490 | 27 | |||
43446 | 44173 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3898 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2007 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 | ||
43473 | 82028 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2787 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2017 09:51:00 AM | 3 | 6000618.2299 | 2114794.646 | 37.7868568655877 | -122.441649390834 | (37.7868568655877, -122.441649390834) | 13 | 6 | 1 | 29490 | 27 | |||
44246 | 45384 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
44601 | 12807 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2100X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2003 12:00:00 AM | 20 | 5 | 5988897.58667 | 2114714.29686 | 37.7859614909645 | -122.482193733009 | (37.7859614909645, -122.482193733009) | 11 | 6 | 1 | 55 | 33 | ||
44816 | 116496 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2501x Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4x4 | 6002673.7687 | 2116111.86994 | 37.790590526381 | -122.434631935029 | (37.790590526381, -122.434631935029) | 13 | 9 | 1 | 29490 | 27 | |||
44886 | 49661 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 8 | Permit Number 46510 | 6000222.49515 | 2120829.72457 | 37.8034050435642 | -122.443452205969 | (37.8034050435642, -122.443452205969) | 13 | 9 | 1 | 57 | 17 | ||
45305 | 94902 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3701 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2010 12:00:00 AM | Permit Number 53961 | 5997125 | 2115346 | 37.78817108981 | -122.453774920639 | (37.78817108981, -122.453774920639) | 11 | 6 | 1 | 54 | 31 | |||
45588 | 129854 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2545 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000840.45885 | 2118233.90287 | 37.7963128271162 | -122.441127374852 | (37.7963128271162, -122.441127374852) | 13 | 9 | 1 | 57 | 17 | |||
45903 | 12717 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/08/1994 12:00:00 AM | 65 | 3x3 | 5990792.41803 | 2114766.86784 | 37.7862158664455 | -122.475642042646 | (37.7862158664455, -122.475642042646) | 11 | 6 | 1 | 54 | 33 | ||
45920 | 39912 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1926 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41189 | 6001051.29800396 | 2114980.79776064 | 37.7873926549284 | -122.44016443305 | (37.7873926549284, -122.44016443305) | 13 | 6 | 1 | 29490 | 27 | |||
45985 | 99003 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
46241 | 13215 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2218 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2003 12:00:00 AM | 3X3 | 6001723.32387 | 2119444.12324 | 37.7996860231337 | -122.43815922186 | (37.7996860231337, -122.43815922186) | 13 | 9 | 1 | 57 | 17 | |||
46521 | 122247 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 47 Lake St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 4ft | 5990771.99578 | 2114778.57066 | 37.7862468151678 | -122.475713552448 | (37.7862468151678, -122.475713552448) | 11 | 6 | 1 | 54 | 33 | |||
47167 | 40137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2760 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1999 12:00:00 AM | 10 | Permit Number 41340 | 6000317.4874 | 2117510.86907 | 37.7942977647882 | -122.442885012557 | (37.7942977647882, -122.442885012557) | 13 | 9 | 1 | 57 | 27 | ||
48155 | 107646 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.76538 | 2115716.99395 | 37.7896817924241 | -122.423878022401 | (37.7896817924241, -122.423878022401) | 13 | 9 | 1 | 28858 | 41 | ||
48189 | 129891 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996747.37477 | 2114962.34995 | 37.7870960324911 | -122.455053698681 | (37.7870960324911, -122.455053698681) | 11 | 6 | 1 | 54 | 31 | |||
48515 | 124258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 5994743.00178 | 2114922.14665 | 37.7868704533367 | -122.461985420107 | (37.7868704533367, -122.461985420107) | 11 | 6 | 1 | 54 | 11 | |||
48942 | 130255 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2320 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6007588.34652 | 2120300.03904 | 37.8023679660663 | -122.417924753627 | (37.8023679660663, -122.417924753627) | 5 | 1 | 1 | 308 | 32 | |||
48998 | 98105 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 850 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001068 | 2114562 | 37.7862436951175 | -122.440076605796 | (37.7862436951175, -122.440076605796) | 13 | 6 | 1 | 29490 | 27 | |||
49182 | 9893 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1700 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6005337.6793 | 2115599.88016 | 37.7893355988943 | -122.425378500212 | (37.7893355988943, -122.425378500212) | 13 | 9 | 1 | 28858 | 41 | |||
49332 | 26738 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1300 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3X3 | 6005838.31144 | 2114533.71115 | 37.7864364355288 | -122.42357053736 | (37.7864364355288, -122.42357053736) | 13 | 9 | 1 | 28858 | 41 | ||
49385 | 34897 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2869 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | 13 | 5x12 | Permit Number 38502 | 5999275.6345 | 2118015.37674 | 37.7956235561453 | -122.446526243416 | (37.7956235561453, -122.446526243416) | 13 | 9 | 1 | 57 | 17 | |
49537 | 68226 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1424 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | Permit Number 32020 | 5991070.89524841 | 2114789.64633569 | 37.7862945499483 | -122.474680257183 | (37.7862945499483, -122.474680257183) | 11 | 6 | 1 | 54 | 33 | ||
49811 | 129942 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2300 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005058.65641 | 2117533.91236 | 37.7946301955676 | -122.426481654525 | (37.7946301955676, -122.426481654525) | 13 | 9 | 1 | 28858 | 27 | |||
50545 | 30980 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1994 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 17 | Permit Number 34767 | 6004672.88111 | 2117091.45468 | 37.7933935036642 | -122.427784946623 | (37.7933935036642, -122.427784946623) | 13 | 9 | 1 | 28858 | 27 | |
50981 | 96611 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2011 12:00:00 AM | 5 | Permit Number 767972 | 5997367.41166 | 2115420.25767 | 37.7883888763049 | -122.452941584197 | (37.7883888763049, -122.452941584197) | 11 | 6 | 1 | 54 | 31 | ||
51055 | 18031 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2790 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6000589.8945322 | 2114844.0214774 | 37.7869908234104 | -122.441750969288 | (37.7869908234104, -122.441750969288) | 13 | 6 | 1 | 29490 | 27 | |||
51690 | 129934 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2245 Vallejo St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6002908.44917 | 2117824.39253 | 37.7953059929233 | -122.433942417617 | (37.7953059929233, -122.433942417617) | 13 | 9 | 1 | 29490 | 27 | |||
51749 | 49665 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 6 | Permit Number 46510 | 6000243.34961 | 2120687.49551 | 37.8030157099616 | -122.443369816371 | (37.8030157099616, -122.443369816371) | 13 | 9 | 1 | 57 | 17 | ||
51973 | 106945 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1150 LOMBARD ST | 4 | Front Yard : Yard | Tree | Private 2 | 13 | Permit Number 773092 | 6006825 | 2120436.8 | 37.8027004869705 | -122.420576026126 | (37.8027004869705, -122.420576026126) | 5 | 1 | 1 | 28858 | 32 | |||
52106 | 129888 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5996890.78508 | 2114983.2227 | 37.7871615696854 | -122.454559041882 | (37.7871615696854, -122.454559041882) | 11 | 6 | 1 | 54 | 31 | |||
53048 | 129858 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 112 Moulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002518.41225 | 2119368.65314 | 37.7995239887052 | -122.43540252722 | (37.7995239887052, -122.43540252722) | 13 | 9 | 1 | 57 | 17 | |||
54974 | 45388 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | Permit Number 44200 | 5989322.60767277 | 2117225.76237725 | 37.7928819736725 | -122.480907237859 | (37.7928819736725, -122.480907237859) | 11 | 1 | 61 | 30 | |||||
55169 | 116499 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2501x Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 4x4 | 6002743.95619 | 2116120.48888 | 37.7906181760269 | -122.434389707131 | (37.7906181760269, -122.434389707131) | 13 | 9 | 1 | 29490 | 27 | |||
55584 | 68144 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2564 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31901 | 6000326.20966373 | 2114114.12374563 | 37.7849716854356 | -122.442610830361 | (37.7849716854356, -122.442610830361) | 15 | 6 | 1 | 29490 | 27 | ||
55668 | 34594 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3196 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 7 | Permit Number 38289 | 5999039.4413 | 2116637.89487 | 37.7918278631246 | -122.447244322395 | (37.7918278631246, -122.447244322395) | 11 | 6 | 1 | 29490 | 30 | |
55748 | 17751 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005900.15955 | 2115529.82964 | 37.7891750204629 | -122.423427399464 | (37.7891750204629, -122.423427399464) | 13 | 9 | 1 | 28858 | 41 | |||
56196 | 17750 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1661 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2000 12:00:00 AM | 4 | 3X3 | 6005879.38988 | 2115527.91702 | 37.7891685966102 | -122.423499124012 | (37.7891685966102, -122.423499124012) | 13 | 9 | 1 | 28858 | 41 | ||
56316 | 129898 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5996260.81247 | 2114721.3486 | 37.7864063819923 | -122.456719650485 | (37.7864063819923, -122.456719650485) | 11 | 6 | 1 | 54 | 31 | |||
56513 | 29750 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1333 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007187.30847 | 2121846.91915 | 37.8065927274426 | -122.419422349675 | (37.8065927274426, -122.419422349675) | 5 | 1 | 1 | 28858 | 32 | ||
57681 | 12756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1738 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/1996 12:00:00 AM | 12 | 3X3 | 5990012.64242 | 2114751.50661 | 37.7861284523683 | -122.478338709075 | (37.7861284523683, -122.478338709075) | 11 | 6 | 1 | 55 | 33 | ||
58118 | 36175 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3450 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | Permit Number 39248 | 5996359.55674118 | 2112911.23261697 | 37.781441954704 | -122.456247095506 | (37.781441954704, -122.456247095506) | 11 | 6 | 1 | 54 | 31 | ||
58548 | 13188 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2051X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 1 | 3x3 | 6002574.7502816 | 2119473.5963948 | 37.7998153348368 | -122.435215088035 | (37.7998153348368, -122.435215088035) | 13 | 9 | 1 | 57 | 17 | ||
59022 | 13117 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1626 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3X3 | 6004541.8938 | 2119838.8489 | 37.8009297345413 | -122.428434086559 | (37.8009297345413, -122.428434086559) | 13 | 9 | 1 | 57 | 17 | ||
59152 | 129959 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1711 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004840.53299 | 2118439.74682 | 37.7971050534142 | -122.427300947694 | (37.7971050534142, -122.427300947694) | 13 | 9 | 1 | 57 | 17 | |||
59551 | 35247 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38736 | 6005802.2 | 2120854.7 | 37.8037902383764 | -122.424145173625 | (37.8037902383764, -122.424145173625) | 5 | 9 | 1 | 28858 | 32 | |||
59618 | 130246 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2638 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006610.28866 | 2120310.8084 | 37.8023424433035 | -122.421310085112 | (37.8023424433035, -122.421310085112) | 5 | 9 | 1 | 28858 | 32 | |||
59654 | 14475 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 250 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5999023.61918 | 2112089.68788 | 37.7793387721051 | -122.446971627792 | (37.7793387721051, -122.446971627792) | 15 | 5 | 1 | 54 | 16 | |||
59847 | 116495 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2501x CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6002786 | 2116136 | 37.7906631519982 | -122.434245347461 | (37.7906631519982, -122.434245347461) | 13 | 9 | 1 | 29490 | 27 | ||||
60386 | 44073 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1350 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2000 12:00:00 AM | 11 | Permit Number 43596 | 5991224.72438 | 2114799.36352 | 37.7863301429585 | -122.474148762674 | (37.7863301429585, -122.474148762674) | 11 | 6 | 1 | 54 | 33 | ||
60633 | 14458 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/2008 12:00:00 AM | 3 | 3X3 | 5998939.65945 | 2112558.4834 | 37.7806211661612 | -122.447295828362 | (37.7806211661612, -122.447295828362) | 15 | 5 | 1 | 54 | 16 | ||
61248 | 26762 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005883.21897 | 2115261.30457 | 37.7884367612686 | -122.423466913964 | (37.7884367612686, -122.423466913964) | 13 | 9 | 1 | 28858 | 41 | |||
61465 | 68134 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1626 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | Permit Number 31886 | 6000649.34416563 | 2114229.75316348 | 37.7853075884876 | -122.44150119163 | (37.7853075884876, -122.44150119163) | 15 | 6 | 1 | 29490 | 27 | ||
62009 | 129850 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3161 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003755.93 | 2119579.28161 | 37.8001725230921 | -122.431135316047 | (37.8001725230921, -122.431135316047) | 13 | 9 | 1 | 57 | 17 | |||
62640 | 121059 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
62641 | 130232 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2013 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782588 | 6007201.62912 | 2119237.06192 | 37.7994275274066 | -122.419187542977 | (37.7994275274066, -122.419187542977) | 5 | 1 | 1 | 28858 | 32 |
62936 | 129861 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3718 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000182.92875 | 2121074.01431 | 37.8040735411278 | -122.443606686105 | (37.8040735411278, -122.443606686105) | 13 | 9 | 1 | 57 | 17 | |||
63315 | 130251 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2333 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007534.87604 | 2120327.1071 | 37.8024392787168 | -122.418111708292 | (37.8024392787168, -122.418111708292) | 5 | 1 | 1 | 28858 | 32 | |||
64688 | 52995 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1810 PINE ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2006 12:00:00 AM | 3x3 | Permit Number 48976 | 6005259 | 2115487 | 37.7890212126999 | -122.425642684361 | (37.7890212126999, -122.425642684361) | 13 | 9 | 1 | 28858 | 27 | |||
64920 | 129876 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6000565.08752 | 2121366.41121 | 37.8048981726751 | -122.442305206121 | (37.8048981726751, -122.442305206121) | 13 | 9 | 1 | 57 | 17 | |||
64956 | 41635 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 100 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42113 | 5996241.92564567 | 2113793.75965037 | 37.7838583861175 | -122.456717884501 | (37.7838583861175, -122.456717884501) | 11 | 6 | 1 | 54 | 31 | |||
65009 | 48498 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2312(REVISED) Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45838 | 6007594.14807985 | 2120292.61587813 | 37.8023479104406 | -122.417904150819 | (37.8023479104406, -122.417904150819) | 5 | 1 | 1 | 308 | 32 | |||
65107 | 12719 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1522 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 5990686.46435 | 2114778.99732 | 37.7862430276294 | -122.476009497029 | (37.7862430276294, -122.476009497029) | 11 | 6 | 1 | 54 | 33 | |||
65561 | 129883 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3140 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999094.06877 | 2116642.96292 | 37.7918448998751 | -122.447055676983 | (37.7918448998751, -122.447055676983) | 11 | 6 | 1 | 29490 | 30 | |||
65886 | 53069 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1863 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2006 12:00:00 AM | 4 | 3x3 | Permit Number 49040 | 6003471.12820952 | 2119597.08628901 | 37.8002052672436 | -122.432122112481 | (37.8002052672436, -122.432122112481) | 13 | 9 | 1 | 57 | 17 | |
65973 | 14463 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 150X Masonic Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/2008 12:00:00 AM | 3 | 3x3 | 5998939.65945 | 2112558.4834 | 37.7806211661612 | -122.447295828362 | (37.7806211661612, -122.447295828362) | 15 | 5 | 1 | 54 | 16 | ||
66181 | 87754 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 19 Cook St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50410 | 5997460 | 2113566 | 37.7833028815315 | -122.452487379595 | (37.7833028815315, -122.452487379595) | 15 | 6 | 1 | 54 | 31 | ||
66892 | 12853 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2430 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/26/2001 12:00:00 AM | 18 | 4X4 | 5987942.80456 | 2114670.37051 | 37.7857853007681 | -122.485493751784 | (37.7857853007681, -122.485493751784) | 11 | 6 | 1 | 55 | 33 | ||
67160 | 116491 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2147 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5999352.0889 | 2116219.58712 | 37.7906971598868 | -122.446132463558 | (37.7906971598868, -122.446132463558) | 13 | 6 | 1 | 29490 | 31 | |||
68320 | 137118 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2150 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 0 | Width 4ft | Permit Number 771149 | 6000490.48443 | 2120659.70119 | 37.8029534840902 | -122.442512606897 | (37.8029534840902, -122.442512606897) | 13 | 9 | 1 | 57 | 17 | |
68472 | 250933 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 258 28th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5987147.60505 | 2114230.18053 | 37.7845303035608 | -122.488212522694 | (37.7845303035608, -122.488212522694) | 11 | 6 | 1 | 55 | 33 | |||
68582 | 107647 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1600X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2016 12:00:00 AM | 3 | Permit Number 773331 | 6005773.76538 | 2115716.99395 | 37.7896817924241 | -122.423878022401 | (37.7896817924241, -122.423878022401) | 13 | 9 | 1 | 28858 | 41 | ||
68796 | 14453 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100 Masonic Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5998924.1725 | 2112667.0746 | 37.7809184444903 | -122.447357223078 | (37.7809184444903, -122.447357223078) | 15 | 5 | 1 | 54 | 16 | |||
68945 | 9896 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2007 12:00:00 AM | 3 | 3X3 | 6004999.6173 | 2115457.4476 | 37.7889254092316 | -122.426538009917 | (37.7889254092316, -122.426538009917) | 13 | 9 | 1 | 28858 | 27 | ||
69012 | 129859 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 229 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002241.84831 | 2118957.72082 | 37.7983799656199 | -122.436330110469 | (37.7983799656199, -122.436330110469) | 13 | 9 | 1 | 57 | 17 | |||
69382 | 52411 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2750X Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2013 12:00:00 AM | 5x5 | Permit Number 769980 | 6000654 | 2117712 | 37.7948691967916 | -122.441735085064 | (37.7948691967916, -122.441735085064) | 13 | 9 | 1 | 57 | 27 | ||
69481 | 129943 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2300 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6005055.38542 | 2117545.63857 | 37.7946622078574 | -122.426493807942 | (37.7946622078574, -122.426493807942) | 13 | 9 | 1 | 28858 | 27 | |||
70429 | 87756 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 19 Cook St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2008 12:00:00 AM | 3x3 | Permit Number 50410 | 5997460 | 2113566 | 37.7833028815315 | -122.452487379595 | (37.7833028815315, -122.452487379595) | 15 | 6 | 1 | 54 | 31 | ||
70863 | 65091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1830 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | Permit Number 27056 | 5989804.11356074 | 2114740.85049779 | 37.7860870860237 | -122.479059375757 | (37.7860870860237, -122.479059375757) | 11 | 6 | 1 | 55 | 33 | ||
71113 | 42638 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:49:00 PM | 3 | 5x5 | Permit Number 42688 | 6005231.45083 | 2118842.40752 | 37.7982327574016 | -122.425976953174 | (37.7982327574016, -122.425976953174) | 13 | 9 | 1 | 57 | 17 |
71380 | 129910 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3101 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005467.67917 | 2121063.89893 | 37.8043457515267 | -122.425317698873 | (37.8043457515267, -122.425317698873) | 13 | 1 | 1 | 28858 | 17 | |||
71643 | 121056 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 2901x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005984 | 2121043 | 37.8043175249008 | -122.423529438764 | (37.8043175249008, -122.423529438764) | 5 | 1 | 1 | 28858 | 32 | ||||
71791 | 76065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/16/1996 12:00:00 AM | 6 | 4x4 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | 5 | 9 | 1 | 28858 | 32 | |
71933 | 26763 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1500X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005883.21897 | 2115261.30457 | 37.7884367612686 | -122.423466913964 | (37.7884367612686, -122.423466913964) | 13 | 9 | 1 | 28858 | 41 | |||
72004 | 87557 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 408X Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/03/2007 12:00:00 AM | 3 | 3x3 | 5994236.22519 | 2114896.53302 | 37.7867709361644 | -122.463736876784 | (37.7867709361644, -122.463736876784) | 11 | 6 | 1 | 54 | 11 | |
73284 | 13119 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1641 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782191 | 6004501.8382 | 2119760.0821 | 37.8007111944994 | -122.428567078189 | (37.8007111944994, -122.428567078189) | 13 | 9 | 1 | 57 | 17 | |
73355 | 7132 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 408X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2008 12:00:00 AM | 5 | 4X4 | 5994235.92349 | 2114901.52504 | 37.7867846255071 | -122.463738283047 | (37.7867846255071, -122.463738283047) | 11 | 6 | 1 | 54 | 11 | ||
74324 | 249484 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1400x Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6006293.02954 | 2115454.9396 | 37.7889915569696 | -122.422062793377 | (37.7889915569696, -122.422062793377) | 13 | 9 | 1 | 28858 | 21 | |||
75064 | 12666 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1108-1118 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/2013 12:00:00 AM | 3 | 3x3 | 5992006.63192 | 2114826.47852 | 37.7864498571436 | -122.471445564886 | (37.7864498571436, -122.471445564886) | 11 | 6 | 1 | 54 | 11 | ||
75069 | 47415 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3630 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 05/14/2002 12:00:00 AM | 9 | Permit Number 45326 | 6000240.55787 | 2120707.38669 | 37.8030701666099 | -122.443380906816 | (37.8030701666099, -122.443380906816) | 13 | 9 | 1 | 57 | 17 | ||
75178 | 114538 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 172 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 0 | 3x3 | Permit Number 776379 | 5988062.82598 | 2114836.36547 | 37.7862480675093 | -122.485090700079 | (37.7862480675093, -122.485090700079) | 11 | 6 | 1 | 55 | 33 | |
76631 | 36890 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3193 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 6 | Permit Number 39544 | 5999051.40531 | 2116589.36278 | 37.7916952904572 | -122.447199432709 | (37.7916952904572, -122.447199432709) | 13 | 6 | 1 | 29490 | 31 | |
76830 | 99000 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2190X North Point St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 04/18/2011 12:00:00 AM | 3x3 | 6000277.5 | 2120626.8 | 37.8028510037355 | -122.443247276641 | (37.8028510037355, -122.443247276641) | 13 | 9 | 1 | 57 | 17 | |||
76955 | 99004 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2099X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | Permit Number 46510 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||||
77070 | 129896 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Cherry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5996264.99029 | 2114681.22571 | 37.786296455158 | -122.456702293584 | (37.786296455158, -122.456702293584) | 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) );