trees
3,247 rows where qSpecies_id = 22 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
22774 | 121447 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1251 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015574 | 2109248 | 37.7724677756099 | -122.389517929907 | (37.7724677756099, -122.389517929907) | 14 | 3 | 9 | 310 | 20 | |||||
26633 | 88961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 583 Shotwell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2008 12:00:00 AM | 3x3 | Permit Number 51727 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | |||
26808 | 89205 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 662 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51833 | 5988199 | 2111465.2 | 37.7769997309607 | -122.48437223608 | (37.7769997309607, -122.48437223608) | 11 | 6 | 2 | 55 | 26 | |||
56626 | 88396 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 635 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51375 | 5988132.305185 | 2111648.444046 | 37.7774989839242 | -122.484616395841 | (37.7774989839242, -122.484616395841) | 11 | 6 | 2 | 55 | 26 | |||
57309 | 88585 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 811 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51528 | 5988482.92039 | 2110432.25241 | 37.7741800732451 | -122.483314341794 | (37.7741800732451, -122.483314341794) | 11 | 6 | 2 | 55 | 26 | ||
94564 | 88962 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 583 Shotwell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51727 | 6008031.3 | 2104525.5 | 37.7590797904057 | -122.415274584034 | (37.7590797904057, -122.415274584034) | 2 | 4 | 7 | 28859 | 19 | ||||
96852 | 88591 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 265 Chenery St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51536 | 6004525.2 | 2096785.5 | 37.7376298693918 | -122.42684912469 | (37.7376298693918, -122.42684912469) | 2 | 7 | 5 | 63 | 7 | |||
103228 | 88440 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2848 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51404 | 6001088 | 2118113 | 37.795994956377 | -122.440262158185 | (37.795994956377, -122.440262158185) | 13 | 9 | 1 | 57 | 17 | |||
124884 | 104764 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1855 08TH AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x4 | Permit Number 770861 | 5993717.5 | 2102872.4 | 37.7537259496496 | -122.464658073456 | (37.7537259496496, -122.464658073456) | 1 | 8 | 4 | 56 | 12 | |||
154039 | 107119 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 41 Elsie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 3x3 | Permit Number 773430 | 6007557.36556 | 2099188.16218 | 37.7443980238935 | -122.416535600799 | (37.7443980238935, -122.416535600799) | 2 | 7 | 7 | 28859 | 2 | |||
155409 | 86818 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3444 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2007 12:00:00 AM | 3x3 | Permit Number 49753 | 6000793 | 2120207 | 37.8017277261212 | -122.441433245596 | (37.8017277261212, -122.441433245596) | 13 | 9 | 1 | 57 | 17 | |||
16572 | 19741 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
14048 | 19740 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
692 | 61241 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3970 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21113 | 6003879.55901956 | 2104241.51200503 | 37.7580658175007 | -122.429613020503 | (37.7580658175007, -122.429613020503) | 2 | 4 | 5 | 28862 | 3 | ||
1069 | 49087 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 692 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2003 12:00:00 AM | Permit Number 46237 | 6012085.19773634 | 2105185.1896517 | 37.7611181541392 | -122.401300553818 | (37.7611181541392, -122.401300553818) | 10 | 3 | 8 | 28856 | 29 | |||
1246 | 160377 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 824 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6001767.32645 | 2089068.63157 | 37.7162847814869 | -122.435832414836 | (37.7162847814869, -122.435832414836) | 9 | 7 | 6 | 28861 | 5 | ||
1277 | 220672 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6005444.88154 | 2104573.79472 | 37.759066695887 | -122.424223091727 | (37.759066695887, -122.424223091727) | 2 | 4 | 5 | 28859 | 19 | |||
1506 | 70618 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1557 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007346.38924 | 2116443.24691 | 37.7917645589423 | -122.418488407316 | (37.7917645589423, -122.418488407316) | 5 | 1 | 10 | 28858 | 21 | |||
1608 | 32205 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1697 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 8 | Permit Number 35528 | 6009341.58261 | 2099615.8477 | 37.7456725350783 | -122.410396317437 | (37.7456725350783, -122.410396317437) | 2 | 7 | 7 | 28859 | 2 | |
1669 | 35520 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41442 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
1686 | 225676 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008816.88964 | 2096900.69924 | 37.7381879057352 | -122.412018790637 | (37.7381879057352, -122.412018790637) | 10 | 7 | 7 | 28859 | 2 | |||
1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
1952 | 129457 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010137.05679 | 2118184.23209 | 37.7967015887668 | -122.408955554965 | (37.7967015887668, -122.408955554965) | 3 | 1 | 10 | 308 | 4 | |||
2109 | 71599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.459970121431 | (37.7083363538073, -122.459970121431) | 9 | 8 | 6 | 28861 | 25 | |||
2312 | 71328 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004151.95998 | 2089814.42795 | 37.7184677472758 | -122.427643069565 | (37.7184677472758, -122.427643069565) | 9 | 7 | 6 | 28861 | 5 | |||
2367 | 226104 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 269 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005509.798 | 2107472.48259 | 37.7670294722636 | -122.424204733868 | (37.7670294722636, -122.424204733868) | 8 | 4 | 5 | 28853 | 19 | |||
2409 | 225663 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006114.92527 | 2097621.73369 | 37.7400157373359 | -122.421412046638 | (37.7400157373359, -122.421412046638) | 2 | 7 | 7 | 28859 | 2 | |||
2444 | 187616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 3x3 | 6013035 | 2114021 | 37.78543223702 | -122.398635644163 | (37.78543223702, -122.398635644163) | 6 | 2 | 9 | 28855 | 6 | ||
2467 | 5648 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1997 12:00:00 AM | 12 | 3x3 | 6005228.5165 | 2100736.64221 | 37.748518548493 | -122.424698417605 | (37.748518548493, -122.424698417605) | 2 | 4 | 5 | 28859 | 19 | ||
2577 | 31869 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 166 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 1 | Permit Number 35311 | 6000215.42905 | 2104900.21847 | 37.759666310759 | -122.442332399837 | (37.759666310759, -122.442332399837) | 2 | 4 | 5 | 28862 | 3 | |
2637 | 262319 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1616 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011556 | 2107033 | 37.7661622878471 | -122.403260820888 | (37.7661622878471, -122.403260820888) | 8 | 2 | 8 | 28853 | 20 | ||||
2645 | 137669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1927 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000327.0363 | 2111629.9151 | 37.7781507333481 | -122.442429558556 | (37.7781507333481, -122.442429558556) | 15 | 5 | 11 | 29490 | 16 | |||
2843 | 243848 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2976 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2017 12:00:00 AM | 3 | Width 3ft | 6009037.26284 | 2102182.62574 | 37.7527032720445 | -122.411629937289 | (37.7527032720445, -122.411629937289) | 2 | 4 | 7 | 28859 | 19 | ||
3134 | 190600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015217.08572 | 2107526.40267 | 37.7677208521577 | -122.390632216307 | (37.7677208521577, -122.390632216307) | 14 | 3 | 9 | 310 | 20 | |||
3143 | 46360 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2002 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.31969 | 37.7779021128043 | -122.482350384801 | (37.7779021128043, -122.482350384801) | 11 | 6 | 2 | 55 | 26 | |
3155 | 171861 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009150.18336 | 2091330.30171 | 37.722911477365 | -122.410473193303 | (37.722911477365, -122.410473193303) | 9 | 3 | 7 | 309 | 28 | |||
3333 | 66070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 517 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 7 | Permit Number 29111 | 6014120.17951 | 2104674.3104 | 37.7598287157536 | -122.39422660508 | (37.7598287157536, -122.39422660508) | 10 | 3 | 8 | 28856 | 29 | |
3435 | 226185 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 160 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008635.20088 | 2097780.05534 | 37.7405922297483 | -122.412709130925 | (37.7405922297483, -122.412709130925) | 10 | 7 | 7 | 28859 | 2 | |||
3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
3762 | 159863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 31 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781524 | 6001585.86798 | 2091604.37779 | 37.7232370625303 | -122.436641024974 | (37.7232370625303, -122.436641024974) | 9 | 7 | 6 | 28861 | 25 | |
3930 | 225746 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 492 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003162.34102 | 2103320.8798 | 37.7554973442542 | -122.432027724994 | (37.7554973442542, -122.432027724994) | 2 | 4 | 5 | 28862 | 22 | |||
4067 | 37077 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1278 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 6 | Permit Number 39679 | 5982458.52457533 | 2106416.34966851 | 37.7628011138985 | -122.503855957317 | (37.7628011138985, -122.503855957317) | 1 | 8 | 3 | 56 | 35 | |
4169 | 56472 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2014 12:00:00 AM | 3 | Permit Number 773427 | 6010126.92776078 | 2099291.06805198 | 37.7448247552135 | -122.40765780266 | (37.7448247552135, -122.40765780266) | 2 | 7 | 7 | 28859 | 2 | ||
4230 | 25991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1821 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | 3 | 3X3 | 6013865.62853 | 2096292.13024 | 37.7367988747247 | -122.394520028611 | (37.7367988747247, -122.394520028611) | 10 | 3 | 8 | 58 | 1 | ||
4261 | 224651 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 157 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 5x9 | Permit Number 781922 | 6006794.80583 | 2098578.82638 | 37.7426820095795 | -122.419129166176 | (37.7426820095795, -122.419129166176) | 2 | 7 | 7 | 28859 | 2 | |
4469 | 224678 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 904 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:09:00 PM | 3 | Width 3ft | 6007360.84858 | 2102028.60298 | 37.7521861798641 | -122.417416376772 | (37.7521861798641, -122.417416376772) | 2 | 4 | 7 | 28859 | 19 | ||
4481 | 83152 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1499 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 6016214.02655 | 2098054.96896 | 37.741769546638 | -122.386523393735 | (37.741769546638, -122.386523393735) | 10 | 3 | 8 | 58 | 1 | ||
4635 | 51506 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3641 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 4 | Permit Number 47816 | 5997376.74864 | 2115377.3985 | 37.7882717315077 | -122.452906185094 | (37.7882717315077, -122.452906185094) | 11 | 6 | 1 | 54 | 31 | ||
4701 | 78630 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 675-677 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011847.3509 | 2105245.39121 | 37.7612701814803 | -122.40212740108 | (37.7612701814803, -122.40212740108) | 10 | 3 | 8 | 28856 | 29 | |||
4819 | 226206 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 597 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007961.05461 | 2097012.3504 | 37.7384464203683 | -122.414985752093 | (37.7384464203683, -122.414985752093) | 2 | 7 | 7 | 28859 | 2 | |||
5352 | 143065 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2 Child St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6010630.6807 | 2120383.8561 | 37.8027688567606 | -122.4074026458 | (37.8027688567606, -122.4074026458) | 3 | 1 | 10 | 308 | 23 | |||
5434 | 244069 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997423.6428 | 2109118.4396 | 37.7710889568013 | -122.45229212933 | (37.7710889568013, -122.45229212933) | 15 | 5 | 11 | 29492 | 9 | |||
5442 | 225670 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 617 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008674.38046 | 2096497.62262 | 37.7370731483986 | -122.412483034163 | (37.7370731483986, -122.412483034163) | 10 | 7 | 7 | 28859 | 2 | |||
5444 | 35590 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2808 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 38953 | 6000039.2737 | 2114426.5269 | 37.7858131029776 | -122.443625984057 | (37.7858131029776, -122.443625984057) | 15 | 6 | 1 | 29490 | 31 | ||
5489 | 84255 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 591 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51832 | 5988111.36438 | 2111976.41893 | 37.7783982912941 | -122.484712901029 | (37.7783982912941, -122.484712901029) | 11 | 6 | 2 | 55 | 26 | |
5509 | 226294 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 410 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003702.40419 | 2096529.69179 | 37.7368809219105 | -122.429675682206 | (37.7368809219105, -122.429675682206) | 2 | 7 | 5 | 63 | 7 | |||
5533 | 59035 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3367 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1980 12:00:00 AM | Permit Number 18327; Original species unknown. Removed and replaced without permit in 2000 | 6005902.92482081 | 2103717.90003873 | 37.7567424611364 | -122.422578138877 | (37.7567424611364, -122.422578138877) | 2 | 4 | 5 | 28859 | 19 | |||
5628 | 228239 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3940 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004071.82454 | 2104248.46 | 37.758095779704 | -122.42894857943 | (37.758095779704, -122.42894857943) | 2 | 4 | 5 | 28862 | 3 | |||
5756 | 256400 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1116 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.01285 | 2102666.82679 | 37.7540552516703 | -122.410278250843 | (37.7540552516703, -122.410278250843) | 2 | 4 | 7 | 28859 | 19 | ||||
5809 | 62467 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 710 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/1985 12:00:00 AM | 10 | Permit Number 22636 | 6011241.19795 | 2104960.20112 | 37.760453261625 | -122.404203766595 | (37.760453261625, -122.404203766595) | 10 | 3 | 8 | 28856 | 29 | |
5830 | 98280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 2 | Permit Number 58649 | 6008148.55904 | 2110896.00071 | 37.776578287595 | -122.415320022909 | (37.776578287595, -122.415320022909) | 8 | 2 | 9 | 28853 | 34 | ||
6023 | 54593 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 525 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1972 12:00:00 AM | 7 | Permit Number 10416 | 6014123.46926 | 2104627.40559 | 37.7597001081867 | -122.394211943453 | (37.7597001081867, -122.394211943453) | 10 | 3 | 8 | 28856 | 29 | ||
6058 | 138706 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1701 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001044.197 | 2114457.2843 | 37.7859548176593 | -122.440151445956 | (37.7859548176593, -122.440151445956) | 15 | 6 | 1 | 29490 | 27 | |||
6217 | 44045 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 442 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2000 12:00:00 AM | Permit Number 43576 | 6010366.61752859 | 2089364.49737601 | 37.7175819036471 | -122.406129784758 | (37.7175819036471, -122.406129784758) | 10 | 7 | 8 | 309 | 39 | |||
6356 | 66071 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 523 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 8 | Permit Number 29112 | 6014121.77425 | 2104653.37197 | 37.7597713120136 | -122.394219623663 | (37.7597713120136, -122.394219623663) | 10 | 3 | 8 | 28856 | 29 | |
6398 | 82303 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6016177.26617 | 2098207.30464 | 37.7421857942275 | -122.386661120412 | (37.7421857942275, -122.386661120412) | 10 | 3 | 8 | 58 | 1 | |||
6502 | 71315 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6003422.952 | 2090101.24578 | 37.7192140226932 | -122.430183398047 | (37.7192140226932, -122.430183398047) | 9 | 7 | 6 | 28861 | 5 | |||
6645 | 226161 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32799 | 5997997.11826 | 2106529.02842 | 37.76401192934 | -122.450121798605 | (37.76401192934, -122.450121798605) | 15 | 5 | 11 | 29492 | 9 | |
6665 | 226202 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 599X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008574.51077 | 2096960.1089 | 37.7383374297197 | -122.412861018343 | (37.7383374297197, -122.412861018343) | 10 | 7 | 7 | 28859 | 2 | |||
6684 | 32355 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1996 12:00:00 AM | 2 | Permit Number 36909 | 5988077.70341 | 2112909.74205 | 37.7809589730845 | -122.484897834483 | (37.7809589730845, -122.484897834483) | 11 | 6 | 2 | 55 | 26 | |
6702 | 84260 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 660 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988186.45102 | 2111472.04935 | 37.777017806636 | -122.484416148832 | (37.777017806636, -122.484416148832) | 11 | 6 | 2 | 55 | 26 | |||
6849 | 45748 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | 3 | Permit Number 44395 | 5997461.24318 | 2116299.42267 | 37.7908082054694 | -122.452680420191 | (37.7908082054694, -122.452680420191) | 11 | 6 | 1 | 54 | 31 | ||
6969 | 26176 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 491 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/1998 12:00:00 AM | 3 | 3X3 | 6002367.6851 | 2105408.33914 | 37.7611839212116 | -122.434925166173 | (37.7611839212116, -122.434925166173) | 15 | 4 | 5 | 28862 | 3 | ||
7043 | 112197 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.7921756543416 | -122.437399303646 | (37.7921756543416, -122.437399303646) | 13 | 6 | 1 | 29490 | 27 | ||
7354 | 228212 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 258 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 4x4 | 6001431.41596 | 2104296.0416 | 37.7580766187648 | -122.438083635558 | (37.7580766187648, -122.438083635558) | 2 | 4 | 5 | 28862 | 3 | |||
7494 | 243413 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998151.68157 | 2104894.95588 | 37.7595340204918 | -122.449469463666 | (37.7595340204918, -122.449469463666) | 15 | 5 | 11 | 28862 | 12 | |
7524 | 111636 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486 | 2097347 | 37.7380767082098 | -122.492717127165 | (37.7380767082098, -122.492717127165) | 1 | 8 | 3 | 29491 | 35 | ||
7575 | 221710 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 90 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41442 | 6005828.31885 | 2102883.52989 | 37.7544472652446 | -122.422776859587 | (37.7544472652446, -122.422776859587) | 2 | 4 | 5 | 28859 | 19 | |
7616 | 71689 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2133 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5997637.9995 | 2109872.9453 | 37.7731729127242 | -122.451605099071 | (37.7731729127242, -122.451605099071) | 15 | 5 | 11 | 29492 | 16 | |||
8132 | 19305 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 345 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/1990 12:00:00 AM | 20 | 3X3 | 6010549.63293 | 2110708.85281 | 37.7761990776491 | -122.407000778664 | (37.7761990776491, -122.407000778664) | 14 | 2 | 9 | 28853 | 34 | ||
8137 | 84234 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 361-363 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52253 | 5988056.84631807 | 2113563.86004854 | 37.782753781159 | -122.485017993529 | (37.782753781159, -122.485017993529) | 11 | 6 | 2 | 55 | 26 | ||
8230 | 105663 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 263 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x2 | 5990541.50647 | 2113621.53342 | 37.783056548593 | -122.476426424914 | (37.783056548593, -122.476426424914) | 11 | 6 | 2 | 55 | 26 | |||
8238 | 195098 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6015116.41348 | 2103939.58285 | 37.7578666360554 | -122.390729746003 | (37.7578666360554, -122.390729746003) | 10 | 3 | 8 | 28856 | 29 | |||
8246 | 264713 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
8273 | 226143 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 165 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004761.35268 | 2102682.3331 | 37.7538345679338 | -122.426452382491 | (37.7538345679338, -122.426452382491) | 2 | 4 | 5 | 28862 | 22 | |||
8515 | 76311 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299X Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 0 | 6006754.26056 | 2093151.90933 | 37.7277786091743 | -122.418884550584 | (37.7277786091743, -122.418884550584) | 9 | 3 | 7 | 309 | 5 | ||
8567 | 225678 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 600X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008639.28815 | 2096915.28176 | 37.7382179799816 | -122.412633881069 | (37.7382179799816, -122.412633881069) | 10 | 7 | 7 | 28859 | 2 | |||
8656 | 64940 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2157 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1989 12:00:00 AM | 5 | Permit Number 25969 | 5997552.9152 | 2109862.9805 | 37.7731406790273 | -122.451898696297 | (37.7731406790273, -122.451898696297) | 15 | 5 | 11 | 29492 | 16 | |
8659 | 71325 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 114 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004555.30191 | 2090455.11867 | 37.7202497511935 | -122.426294473226 | (37.7202497511935, -122.426294473226) | 9 | 7 | 6 | 28861 | 5 | |||
8720 | 67850 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 485 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31520 | 6002735.666769 | 2098756.82734478 | 37.7429413329054 | -122.433177202226 | (37.7429413329054, -122.433177202226) | 2 | 7 | 5 | 63 | 22 | ||
8732 | 261131 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 205 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002921 | 2092296 | 37.725211886246 | -122.432075099304 | (37.725211886246, -122.432075099304) | 9 | 7 | 6 | 28861 | 5 | ||
8835 | 225756 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004264.93448 | 2101628.47099 | 37.7509128342656 | -122.428094014849 | (37.7509128342656, -122.428094014849) | 2 | 4 | 5 | 28862 | 22 | |||
8933 | 6551 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1275 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3x3 | 6017377.10796 | 2097187.95737 | 37.7394532248805 | -122.382441492395 | (37.7394532248805, -122.382441492395) | 10 | 3 | 8 | 58 | 1 | ||
9046 | 225629 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100X Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007636.88846 | 2098165.70559 | 37.7415950574792 | -122.416188226626 | (37.7415950574792, -122.416188226626) | 2 | 7 | 7 | 28859 | 2 | |||
9306 | 40717 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 360 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41696 | 6008594.61699406 | 2097088.56935412 | 37.7386912826447 | -122.412800580048 | (37.7386912826447, -122.412800580048) | 10 | 7 | 7 | 28859 | 2 |
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) );