trees
3,247 rows where qSpecies_id = 22 sorted by Police 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98681 | 129044 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6013286.59086 | 2117813.86982 | 37.7958605823612 | -122.398031383042 | (37.7958605823612, -122.398031383042) | 3 | 1 | 10 | 28860 | 6 | |||
| 99627 | 107884 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
| 99915 | 109610 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 100039 | 92890 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Tree no. 2 on Montgomery | 6011720.98401 | 2118117.86666 | 37.796607963049 | -122.403470105059 | (37.796607963049, -122.403470105059) | 3 | 1 | 10 | 308 | 4 | ||
| 100090 | 11432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1994 12:00:00 AM | 6 | 3X3 | 6012526.0110026 | 2118137.4589098 | 37.796706690547 | -122.400685892184 | (37.796706690547, -122.400685892184) | 3 | 1 | 10 | 28860 | 4 | ||
| 100427 | 55347 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1357 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1972 12:00:00 AM | 12 | Permit Number 11278 | 6008237.04974 | 2116897.5275 | 37.7930620018618 | -122.415438890802 | (37.7930620018618, -122.415438890802) | 5 | 1 | 10 | 28858 | 21 | ||
| 100505 | 88411 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1135 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51385 | 6009845.51627 | 2117657.92269 | 37.7952401364672 | -122.409927183403 | (37.7952401364672, -122.409927183403) | 3 | 1 | 10 | 28857 | 4 | |
| 100990 | 129043 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013288.00774 | 2117785.67539 | 37.795783246053 | -122.398024501452 | (37.795783246053, -122.398024501452) | 3 | 1 | 10 | 28860 | 6 | |||
| 101612 | 84803 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2007 12:00:00 AM | 3 | Permit No. 49258 | 6012320.77135 | 2117339.17787 | 37.7945033525031 | -122.401339944792 | (37.7945033525031, -122.401339944792) | 3 | 1 | 10 | 28860 | 4 | ||
| 102419 | 91459 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 103045 | 129055 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 444 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2004 12:00:00 AM | 5 | Width 4ft | 6012276.75519 | 2117819.30425 | 37.7958192090308 | -122.401526007337 | (37.7958192090308, -122.401526007337) | 3 | 1 | 10 | 28860 | 4 | ||
| 103285 | 109617 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 103663 | 64361 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 580 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 8 | Permit Number 25200 | 6010170.4257 | 2120272.4208 | 37.8024371115938 | -122.408987502507 | (37.8024371115938, -122.408987502507) | 3 | 1 | 10 | 308 | 23 | |
| 104985 | 23693 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 444 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2012 12:00:00 AM | 3 | 3x3 | 6012360.1719452 | 2117827.4460445 | 37.795846218583 | -122.401237940514 | (37.795846218583, -122.401237940514) | 3 | 1 | 10 | 28860 | 4 | ||
| 105119 | 109619 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 106349 | 92889 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 53104 Tree no. 1 on Montgomery St | 6011723.54732 | 2118091.83637 | 37.7965366333102 | -122.403459403146 | (37.7965366333102, -122.403459403146) | 3 | 1 | 10 | 308 | 4 | |
| 106482 | 91454 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 110745 | 64382 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | Permit Number 25223 | 6010171.68830219 | 2120276.20924301 | 37.8024475844496 | -122.408983400718 | (37.8024475844496, -122.408983400718) | 3 | 1 | 10 | 308 | 23 | ||
| 111317 | 129018 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010048.24656 | 2117474.59523 | 37.794748123684 | -122.40921275837 | (37.794748123684, -122.40921275837) | 3 | 1 | 10 | 28857 | 4 | |||
| 111993 | 84804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2007 12:00:00 AM | 3 | Permit No. 49258 | 6012316.07521 | 2117370.91967 | 37.7945902459089 | -122.401358425857 | (37.7945902459089, -122.401358425857) | 3 | 1 | 10 | 28860 | 4 | ||
| 112580 | 64365 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1988 12:00:00 AM | 7 | Permit Number 25204 | 6010256.8933 | 2120284.6971 | 37.8024756625421 | -122.408689147089 | (37.8024756625421, -122.408689147089) | 3 | 1 | 10 | 308 | 23 | |
| 114301 | 98806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
| 116188 | 129042 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013288.71505 | 2117766.07666 | 37.795729471979 | -122.398020678438 | (37.795729471979, -122.398020678438) | 3 | 1 | 10 | 28860 | 6 | |||
| 117805 | 129024 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Montgomery St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 2ft | 6011905.28525 | 2116843.33674 | 37.7931187014156 | -122.40274269923 | (37.7931187014156, -122.40274269923) | 4 | 1 | 10 | 28854 | 6 | |||
| 119665 | 254391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009354.25568 | 2118062.93204 | 37.7963246481861 | -122.41165565994 | (37.7963246481861, -122.41165565994) | 3 | 1 | 10 | 308 | 4 | ||
| 120042 | 84805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2007 12:00:00 AM | 3 | Permit No. 49258 | 6012309.5136 | 2117415.99647 | 37.7947136499591 | -122.401384299366 | (37.7947136499591, -122.401384299366) | 3 | 1 | 10 | 28860 | 4 | ||
| 121110 | 98804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010297.35863 | 2117215.00262 | 37.7940492982967 | -122.408332474088 | (37.7940492982967, -122.408332474088) | 3 | 1 | 10 | 28857 | 4 |
| 121836 | 129056 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011415.91868 | 2117696.60349 | 37.7954342317671 | -122.404496036363 | (37.7954342317671, -122.404496036363) | 3 | 1 | 10 | 28857 | 4 | |
| 121936 | 112128 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 122492 | 107885 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |||
| 124196 | 112801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 865 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009421.02251 | 2118738.48661 | 37.7981833000696 | -122.411472383257 | (37.7981833000696, -122.411472383257) | 3 | 1 | 10 | 308 | 4 | |||
| 127997 | 92908 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 802 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Tree no. 2 on Jackson St. | 6011726 | 2118056 | 37.7964383722538 | -122.403448393826 | (37.7964383722538, -122.403448393826) | 3 | 1 | 10 | 28860 | 4 | ||
| 129234 | 129046 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013276.03301 | 2117859.85346 | 37.7959862545039 | -122.398071142972 | (37.7959862545039, -122.398071142972) | 3 | 1 | 10 | 28860 | 6 | |||
| 129500 | 129010 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2200 Grant Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010219.4685 | 2122201.72912 | 37.8077372604315 | -122.408953993726 | (37.8077372604315, -122.408953993726) | 3 | 1 | 10 | 308 | 23 | |||
| 130087 | 110156 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1041 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008596.56055 | 2118265.88339 | 37.7968393702849 | -122.414291819036 | (37.7968393702849, -122.414291819036) | 5 | 1 | 10 | 308 | 21 | |
| 130969 | 116857 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x3 | 6010080.35093 | 2117187.65635 | 37.793962057763 | -122.409081415981 | (37.793962057763, -122.409081415981) | 3 | 1 | 10 | 28857 | 4 | ||
| 133806 | 91457 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 134329 | 56346 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 Front St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2017 12:00:00 AM | 3 | Permit Number 12488 | 6012822.94142 | 2118342.56385 | 37.797286416082 | -122.399672847242 | (37.797286416082, -122.399672847242) | 3 | 1 | 10 | 28860 | 6 | ||
| 136326 | 143070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 528 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010344.9622 | 2120299.1083 | 37.8025201643159 | -122.408385400714 | (37.8025201643159, -122.408385400714) | 3 | 1 | 10 | 308 | 23 | |||
| 137551 | 172448 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | 6009344.92188 | 2118146.86954 | 37.7965545963687 | -122.411693890757 | (37.7965545963687, -122.411693890757) | 3 | 1 | 10 | 308 | 4 | ||
| 137874 | 143493 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011305.9671 | 2117702.4892 | 37.7954442472417 | -122.404876903904 | (37.7954442472417, -122.404876903904) | 3 | 1 | 10 | 28857 | 4 | |
| 137959 | 109614 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 138291 | 129015 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6011821.67405 | 2120927.2444 | 37.8043274566138 | -122.403319427258 | (37.8043274566138, -122.403319427258) | 3 | 1 | 10 | 28860 | 6 | |||
| 138747 | 129033 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013239.28212 | 2117856.41836 | 37.795974775567 | -122.398198067906 | (37.795974775567, -122.398198067906) | 3 | 1 | 10 | 28860 | 6 | |||
| 141075 | 143068 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Child St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010607.1256 | 2120351.0165 | 37.8026773688895 | -122.407481842223 | (37.8026773688895, -122.407481842223) | 3 | 1 | 10 | 308 | 23 | |||
| 142053 | 110157 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045-1059 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775264 | 6008554.60995 | 2118262.34224 | 37.7968272906045 | -122.414436727676 | (37.7968272906045, -122.414436727676) | 5 | 1 | 10 | 308 | 21 | ||
| 142752 | 67622 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1760 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | Permit Number 31207 | 6007850.45930515 | 2118441.04608217 | 37.7972783848242 | -122.416885926914 | (37.7972783848242, -122.416885926914) | 5 | 1 | 10 | 28858 | 21 | ||
| 144820 | 109620 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 145292 | 128990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1211 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009818.96912 | 2117865.4528 | 37.7958084756462 | -122.410033699112 | (37.7958084756462, -122.410033699112) | 3 | 1 | 10 | 308 | 4 | |||
| 146733 | 109616 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | |||
| 151480 | 143067 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 15 Child St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010601.6848 | 2120393.9506 | 37.8027949508206 | -122.407503698977 | (37.8027949508206, -122.407503698977) | 3 | 1 | 10 | 308 | 23 | |||
| 153449 | 129027 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012154.38216 | 2117111.9074 | 37.7938700373275 | -122.401899691814 | (37.7938700373275, -122.401899691814) | 4 | 1 | 10 | 28860 | 6 | |||
| 153836 | 129058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011338.85852 | 2117686.82601 | 37.7954030783469 | -122.404761990195 | (37.7954030783469, -122.404761990195) | 3 | 1 | 10 | 28857 | 4 | |
| 155253 | 129011 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2200 Grant Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010212.84483 | 2122235.52115 | 37.8078296738771 | -122.40897930247 | (37.8078296738771, -122.40897930247) | 3 | 1 | 10 | 308 | 23 | |||
| 157926 | 129031 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012257.35815 | 2117124.13683 | 37.7939093628708 | -122.401544242867 | (37.7939093628708, -122.401544242867) | 4 | 1 | 10 | 28860 | 6 | |||
| 158324 | 129054 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 444 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2012 12:00:00 AM | 2 | Width 4ft | 6012321.89911 | 2117825.32237 | 37.7958382521842 | -122.401370223173 | (37.7958382521842, -122.401370223173) | 3 | 1 | 10 | 28860 | 4 | ||
| 160038 | 129021 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010133.14197 | 2117484.27799 | 37.7947794659604 | -122.408919690903 | (37.7947794659604, -122.408919690903) | 3 | 1 | 10 | 28857 | 4 | |||
| 160602 | 250211 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 212 Union St | 7 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796 | (37.80121941579, -122.40351603796) | 3 | 1 | 10 | 308 | 23 | |||
| 161993 | 129036 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013248.88041 | 2117784.9287 | 37.7957790165368 | -122.398159837726 | (37.7957790165368, -122.398159837726) | 3 | 1 | 10 | 28860 | 6 | |||
| 162337 | 129047 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 349 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012243.75564 | 2118106.34516 | 37.796605513293 | -122.401660377751 | (37.796605513293, -122.401660377751) | 3 | 1 | 10 | 28860 | 4 | |||
| 162733 | 55912 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 801 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770168 | 6007877.21664 | 2120606.58742 | 37.8032259237896 | -122.416946850615 | (37.8032259237896, -122.416946850615) | 5 | 1 | 1 | 308 | 32 | |
| 163523 | 107883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
| 164189 | 129028 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012179.81742 | 2117115.37877 | 37.7938809883639 | -122.401811926996 | (37.7938809883639, -122.401811926996) | 4 | 1 | 10 | 28860 | 6 | |||
| 164360 | 129035 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013321 | 2117453 | 37.7948716356348 | -122.397886993565 | (37.7948716356348, -122.397886993565) | 3 | 1 | 10 | 28860 | 6 | |||
| 164423 | 129008 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2550 Leavenworth St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007462.65437 | 2121216.63674 | 37.804877636656 | -122.418424741625 | (37.804877636656, -122.418424741625) | 5 | 1 | 1 | 308 | 32 | |||
| 167456 | 143453 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 790 CALIFORNIA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010556.4547 | 2116595.0498 | 37.7923615628264 | -122.407392244261 | (37.7923615628264, -122.407392244261) | 3 | 1 | 10 | 28857 | 4 | |||
| 169090 | 98805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010143.10639 | 2117195.10642 | 37.793986029186 | -122.408864800763 | (37.793986029186, -122.408864800763) | 3 | 1 | 10 | 28857 | 4 |
| 170083 | 98803 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |
| 170372 | 1717 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Battery St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012534.63593 | 2117926.51881 | 37.7961279804624 | -122.400641221934 | (37.7961279804624, -122.400641221934) | 3 | 1 | 10 | 28860 | 4 | |||
| 171012 | 128998 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1717 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008298.90003 | 2118387.0949 | 37.7971554622092 | -122.41533038219 | (37.7971554622092, -122.41533038219) | 5 | 1 | 10 | 28858 | 21 | |||
| 171481 | 107886 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
| 172055 | 112127 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 173439 | 52200 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 558 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2005 12:00:00 AM | 1 | Permit Number 48388 | 6010241.4146 | 2120284.6971 | 37.8024747955984 | -122.408742711308 | (37.8024747955984, -122.408742711308) | 3 | 1 | 10 | 308 | 23 | ||
| 174435 | 112129 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 175024 | 129038 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013256.5667 | 2117739.00297 | 37.7956533434856 | -122.398130017998 | (37.7956533434856, -122.398130017998) | 3 | 1 | 10 | 28860 | 6 | |||
| 177036 | 129014 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1500 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6011826.76829 | 2120892.13124 | 37.8042313289751 | -122.403299326499 | (37.8042313289751, -122.403299326499) | 3 | 1 | 10 | 28860 | 6 | |||
| 177985 | 110155 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1041 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 55966 | 6008584.20475 | 2118266.76798 | 37.7968411050867 | -122.414334635748 | (37.7968411050867, -122.414334635748) | 5 | 1 | 10 | 308 | 21 | |
| 179485 | 98802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | |
| 181409 | 129057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011354.55314 | 2117688.13829 | 37.7954075587569 | -122.404707776336 | (37.7954075587569, -122.404707776336) | 3 | 1 | 10 | 28857 | 4 | |
| 181565 | 109621 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 | ||||
| 181881 | 52195 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1209 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2005 12:00:00 AM | 3 | Permit Number 48386 | 6007084.31165 | 2119457.46133 | 37.8000260811036 | -122.419609149648 | (37.8000260811036, -122.419609149648) | 5 | 1 | 1 | 28858 | 32 | ||
| 182248 | 129012 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 150 Francisco St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010624.52904 | 2121364.46761 | 37.8054610295673 | -122.407493109815 | (37.8054610295673, -122.407493109815) | 3 | 1 | 10 | 308 | 23 | ||||
| 184074 | 128997 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1189 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007893.47286 | 2118525.78201 | 37.7975134679385 | -122.416743094821 | (37.7975134679385, -122.416743094821) | 5 | 1 | 10 | 28858 | 21 | |||
| 184339 | 128996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1189 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007875.74827 | 2118524.15827 | 37.7975080126282 | -122.416804311666 | (37.7975080126282, -122.416804311666) | 5 | 1 | 10 | 28858 | 21 | |||
| 186354 | 91452 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 186830 | 143214 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 209 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010288.2363 | 2121289.8221 | 37.805237242499 | -122.408651632361 | (37.805237242499, -122.408651632361) | 3 | 1 | 10 | 308 | 23 | |||
| 187706 | 98797 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010116.35805 | 2117191.91562 | 37.7939757697248 | -122.408957127878 | (37.7939757697248, -122.408957127878) | 3 | 1 | 10 | 28857 | 4 | |
| 188877 | 91456 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 188988 | 98791 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) | 3 | 1 | 10 | 28857 | 4 | |
| 189815 | 112130 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 850X COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3x6 | 6008928 | 2120320 | 37.8024980771426 | -122.41329029105 | (37.8024980771426, -122.41329029105) | 3 | 1 | 10 | 308 | 23 | |||
| 190931 | 65419 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 790 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1989 12:00:00 AM | 7 | Permit Number 28277 | 6010596.9458 | 2116598.4716 | 37.7923732244726 | -122.407252384703 | (37.7923732244726, -122.407252384703) | 3 | 1 | 10 | 28857 | 4 | |
| 191301 | 254390 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009354.25568 | 2118062.93204 | 37.7963246481861 | -122.41165565994 | (37.7963246481861, -122.41165565994) | 3 | 1 | 10 | 308 | 4 | ||
| 192440 | 129052 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012440.41364 | 2117843.22562 | 37.7958940218454 | -122.40096139676 | (37.7958940218454, -122.40096139676) | 3 | 1 | 10 | 28860 | 4 | |||
| 192668 | 46083 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 678 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2001 12:00:00 AM | 1 | Permit Number 44461 | 6009646.5972 | 2120203.7861 | 37.8022193006044 | -122.4107953652 | (37.8022193006044, -122.4107953652) | 3 | 1 | 10 | 308 | 23 | ||
| 14392 | 128960 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007843 | 2112396 | 37.7806797483911 | -122.416483319824 | (37.7806797483911, -122.416483319824) | 7 | 10 | 9 | 28852 | 36 | |||
| 14644 | 128956 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 190 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008324.7013 | 2112452.543 | 37.7808620795531 | -122.414820881171 | (37.7808620795531, -122.414820881171) | 7 | 10 | 9 | 28852 | 36 | |||
| 17644 | 128974 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008318.90919 | 2112394.69245 | 37.7807029103535 | -122.414836823479 | (37.7807029103535, -122.414836823479) | 7 | 10 | 9 | 28852 | 36 | |||
| 19281 | 128961 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007843 | 2112396 | 37.7806797483911 | -122.416483319824 | (37.7806797483911, -122.416483319824) | 7 | 10 | 9 | 28852 | 36 | |||
| 35138 | 49968 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 250 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2016 12:00:00 AM | 3 | Permit Number 773269 | 6007921.55804 | 2112390.20722 | 37.7806682603601 | -122.416211138647 | (37.7806682603601, -122.416211138647) | 7 | 10 | 9 | 28852 | 36 | |
| 36499 | 128982 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008559.94601 | 2112424.43606 | 37.7807981197758 | -122.41400506301 | (37.7807981197758, -122.41400506301) | 7 | 10 | 9 | 28852 | 36 |
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) );