trees
3,247 rows where qSpecies_id = 22 sorted by qCareAssistant descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38991 | 107888 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 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 |
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 | ||
136011 | 100962 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 55 Hawthorne St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/03/2013 12:00:00 AM | 18 | 3x3 | Permit Number 768706 | 6013015.61085 | 2114021.62606 | 37.7854328757839 | -122.39870276924 | (37.7854328757839, -122.39870276924) | 6 | 2 | 9 | 28855 | 6 |
158891 | 251370 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 390 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
156358 | 106963 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 14 | 5999920.02374 | 2118149.14648 | 37.7960276377095 | -122.444306168018 | (37.7960276377095, -122.444306168018) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |
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 | |
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 | |
3402 | 81722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014944.17963 | 2104119.9743 | 37.758352394954 | -122.391338017739 | (37.758352394954, -122.391338017739) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |
4360 | 71812 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 340 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5997177.69428 | 2115152.46792 | 37.787642723191 | -122.453578628865 | (37.787642723191, -122.453578628865) | 11 | 6 | 1 | 54 | 31 | |||
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 | ||
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 | |||
5007 | 30714 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 111 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 2 | Permit Number 34618 | 6005877.6805 | 2109983.4249 | 37.7739446835862 | -122.423110779148 | (37.7739446835862, -122.423110779148) | 7 | 9 | 11 | 28852 | 10 | |
5009 | 47117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 111X Kingston St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | 3x3 | Permit Number 45100 | 6005877.48531462 | 2098254.931079 | 37.7417409646574 | -122.422277993643 | (37.7417409646574, -122.422277993643) | 2 | 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 | ||
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 | |
6041 | 42134 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Connecticut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 7 | 6x4 | Permit Number 42430 | 6013207.16013 | 2104921.81 | 37.760457503722 | -122.397401670553 | (37.760457503722, -122.397401670553) | 10 | 3 | 8 | 28856 | 29 |
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 | |||
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 | |||
6920 | 32855 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 121 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37205 | 6000624.61627289 | 2102511.57259046 | 37.7531309843157 | -122.440745886867 | (37.7531309843157, -122.440745886867) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |||
8103 | 108711 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2000-2038X 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773095 | 6011373.53842 | 2106528.51703 | 37.7647668994048 | -122.40385642054 | (37.7647668994048, -122.40385642054) | 8 | 3 | 8 | 28853 | 20 |
8505 | 71601 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994653.0975 | 2086384.07363 | 37.7085069255288 | -122.460228076664 | (37.7085069255288, -122.460228076664) | 9 | 8 | 6 | 28861 | 25 | |||
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 | |||
8668 | 39268 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015240.80145 | 2113614.13929 | 37.7844377354544 | -122.390975718675 | (37.7844377354544, -122.390975718675) | 6 | 2 | 9 | 28856 | 6 |
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 | ||
8872 | 80804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6015534.52104 | 2104634.07686 | 37.759796756532 | -122.389332239092 | (37.759796756532, -122.389332239092) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
9388 | 84237 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 382-384 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5988116.70798 | 2113371.1409 | 37.7822281155783 | -122.484796757861 | (37.7822281155783, -122.484796757861) | 11 | 6 | 2 | 55 | 26 | |||
9806 | 81718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014951.7156 | 2104031.36678 | 37.7581095159642 | -122.39130576085 | (37.7581095159642, -122.39130576085) | 10 | 3 | 8 | 28856 | 29 | |||
10304 | 71422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 658 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009722.2927 | 2120212.6608 | 37.8022479122752 | -122.410534048105 | (37.8022479122752, -122.410534048105) | 3 | 1 | 10 | 308 | 23 | |||
10467 | 47093 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2527 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | 3 | Permit Number 45075 | 5996913.4055 | 2110751.4542 | 37.7755435471962 | -122.454175015215 | (37.7755435471962, -122.454175015215) | 15 | 6 | 2 | 54 | 16 | |
10917 | 73960 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.460179309136 | (37.7084764663958, -122.460179309136) | 9 | 8 | 6 | 28861 | 25 | |||
11217 | 36019 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39165 | 6006729.30953986 | 2099082.13183863 | 37.7440602847413 | -122.419391331569 | (37.7440602847413, -122.419391331569) | 2 | 7 | 7 | 28859 | 2 | ||
11262 | 258169 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 148 Felton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x3 | 6010466.36455 | 2093776.54364 | 37.7297020458087 | -122.406095661025 | (37.7297020458087, -122.406095661025) | 10 | 3 | 7 | 309 | 28 | ||
11854 | 72418 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3878 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5996349.46796 | 2114952.54152 | 37.7870462658131 | -122.456429650633 | (37.7870462658131, -122.456429650633) | 11 | 6 | 1 | 54 | 31 | |||
12146 | 80632 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 261-263 Texas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6013772.88089 | 2105882.21581 | 37.7631260494579 | -122.395512375704 | (37.7631260494579, -122.395512375704) | 14 | 3 | 8 | 28856 | 29 | |||
12292 | 74182 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994679.00139 | 2086362.08429 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | 9 | 8 | 6 | 28861 | 25 | |||
12449 | 80636 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 261-263 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013774.02904 | 2105871.68608 | 37.7630972009925 | -122.395507666864 | (37.7630972009925, -122.395507666864) | 14 | 3 | 8 | 28856 | 29 | |||
12559 | 30713 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 111 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 3 | Permit Number 34618 | 6005868.3438 | 2109981.6465 | 37.7739392736408 | -122.42314294996 | (37.7739392736408, -122.42314294996) | 7 | 9 | 11 | 28852 | 10 | |
12704 | 72671 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 203 04th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5994585.61762 | 2114114.79768 | 37.7846446297113 | -122.462471346717 | (37.7846446297113, -122.462471346717) | 11 | 6 | 2 | 54 | 11 | |||
13047 | 70677 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 110 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010274.94764 | 2110617.18135 | 37.7759319943133 | -122.407944528121 | (37.7759319943133, -122.407944528121) | 8 | 2 | 9 | 28853 | 34 | |||
13295 | 72207 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 528 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010331.0847 | 2120296.9733 | 37.8025135249949 | -122.40843327331 | (37.8025135249949, -122.40843327331) | 3 | 1 | 10 | 308 | 23 | |||
14001 | 49817 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1226 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46608 | 6012208.77564 | 2102677.65266 | 37.7542399031726 | -122.400696986204 | (37.7542399031726, -122.400696986204) | 10 | 3 | 8 | 28856 | 29 |
14461 | 62082 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1985 12:00:00 AM | 5 | Permit Number 22166 | 6013236.0728 | 2104376.01067 | 37.7589604679833 | -122.397263399784 | (37.7589604679833, -122.397263399784) | 10 | 3 | 8 | 28856 | 29 | |
14531 | 84257 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 894 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988243.88098 | 2109914.2292 | 37.7727438112406 | -122.484103215339 | (37.7727438112406, -122.484103215339) | 11 | 6 | 2 | 55 | 26 | |||
14854 | 74616 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2350 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5991316.62714 | 2112033.26872 | 37.7787405344574 | -122.473628955238 | (37.7787405344574, -122.473628955238) | 11 | 6 | 2 | 54 | 26 | |||
15326 | 30913 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | 9 | 8 | 6 | 28861 | 24 | ||
15486 | 81720 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014948.39032 | 2104075.36829 | 37.7582301501175 | -122.39132033706 | (37.7582301501175, -122.39132033706) | 10 | 3 | 8 | 28856 | 29 | |||
15610 | 78628 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 695 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6011848.41815 | 2105223.54822 | 37.7612102650599 | -122.402122174202 | (37.7612102650599, -122.402122174202) | 10 | 3 | 8 | 28856 | 29 | |||
15826 | 83441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 325 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6014074.06894 | 2105534.94834 | 37.7621892769404 | -122.394446342739 | (37.7621892769404, -122.394446342739) | 10 | 3 | 8 | 28856 | 29 | ||
15922 | 62857 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 179 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23225 | 6008674.53760188 | 2097751.18669018 | 37.7405151705193 | -122.412571078994 | (37.7405151705193, -122.412571078994) | 10 | 7 | 7 | 28859 | 2 | ||
16265 | 83806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 6008439.24535 | 2117330.37578 | 37.794261859346 | -122.414769927392 | (37.794261859346, -122.414769927392) | 5 | 1 | 10 | 28858 | 21 | ||
16311 | 71600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994689.24707 | 2086354.84413 | 37.7084287474492 | -122.460101024051 | (37.7084287474492, -122.460101024051) | 9 | 8 | 6 | 28861 | 25 | |||
16796 | 70557 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 20 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004148.34946 | 2093373.6236 | 37.7282403094269 | -122.42790902788 | (37.7282403094269, -122.42790902788) | 9 | 7 | 6 | 28861 | 5 | |||
17457 | 73445 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007755.78016 | 2114801.18136 | 37.7872788880559 | -122.416955517392 | (37.7872788880559, -122.416955517392) | 13 | 1 | 10 | 28858 | 21 | |||
17481 | 52506 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 180 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48613 | 6000220.46380878 | 2092503.12984203 | 37.7256271406599 | -122.441425411243 | (37.7256271406599, -122.441425411243) | 9 | 7 | 6 | 28861 | 25 | ||
17601 | 71793 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2125 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997663.2948 | 2109878.311 | 37.773189094117 | -122.451517986846 | (37.773189094117, -122.451517986846) | 15 | 5 | 11 | 29492 | 16 | |||
17720 | 73608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5994710.3414 | 2086333.69481 | 37.7083718896252 | -122.460026588949 | (37.7083718896252, -122.460026588949) | 9 | 8 | 6 | 28861 | 25 | |||
17756 | 73719 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001003.51582 | 2093592.54046 | 37.7286629916874 | -122.438796501163 | (37.7286629916874, -122.438796501163) | 9 | 7 | 6 | 28861 | 25 | |||
17842 | 72669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 203 04th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5994587.45477 | 2114094.64597 | 37.7845894043596 | -122.462463528658 | (37.7845894043596, -122.462463528658) | 11 | 6 | 2 | 54 | 11 | |||
17856 | 68790 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | 1 | 8 | 4 | 29491 | 40 | ||
17962 | 37394 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 9 | Permit Number 39876 | 6000430.23445 | 2087496.65427 | 37.7118924395572 | -122.440341369156 | (37.7118924395572, -122.440341369156) | 9 | 7 | 6 | 28861 | 5 | |
18366 | 39267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015247.62996 | 2113604.71354 | 37.7844122333873 | -122.390951435185 | (37.7844122333873, -122.390951435185) | 6 | 2 | 9 | 28856 | 6 |
18490 | 34599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3200 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38292 | 5999320.20166 | 2116021.69073 | 37.7901519674937 | -122.446228549814 | (37.7901519674937, -122.446228549814) | 13 | 6 | 1 | 29490 | 31 | |
18798 | 71245 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1732 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006396.12471 | 2117006.83983 | 37.7932585028357 | -122.421816375523 | (37.7932585028357, -122.421816375523) | 13 | 9 | 10 | 28858 | 32 | |||
18848 | 54010 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1537 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/1972 12:00:00 AM | 5 | Permit Number 9729 | 6012988.89964 | 2105636.75215 | 37.7624084228186 | -122.398206698706 | (37.7624084228186, -122.398206698706) | 10 | 3 | 8 | 28856 | 29 | |
19320 | 33230 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | Permit Number 37416 | 6000651.12195 | 2117750.428 | 37.7949745459919 | -122.441747802734 | (37.7949745459919, -122.441747802734) | 13 | 9 | 1 | 57 | 27 | ||
19360 | 80805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015535.39126 | 2104617.20142 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) | 10 | 3 | 8 | 28856 | 29 | |||
19891 | 61244 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3974 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/1984 12:00:00 AM | Permit Number 21116 | 6003854.92098549 | 2104240.14481817 | 37.7580606684354 | -122.429698131841 | (37.7580606684354, -122.429698131841) | 2 | 4 | 5 | 28862 | 3 | ||
20976 | 49996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 247@ 18TH ST Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 3 | Permit Number 46739 | 6013491.30508 | 2105926.86406 | 37.7632329779416 | -122.396489388368 | (37.7632329779416, -122.396489388368) | 14 | 3 | 8 | 28856 | 29 | |
21196 | 95772 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767507 | 6002653.48548 | 2089890.5721 | 37.7185919472416 | -122.432828107254 | (37.7185919472416, -122.432828107254) | 9 | 7 | 6 | 28861 | 5 |
21207 | 33596 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 224 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/27/1996 12:00:00 AM | Permit Number 37704 | 6006764.88220944 | 2097872.66772056 | 37.7407413706298 | -122.419182553853 | (37.7407413706298, -122.419182553853) | 2 | 7 | 7 | 28859 | 2 | ||
22441 | 35507 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3460 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38910 | 6005335.59882734 | 2103155.12631958 | 37.7551651932954 | -122.42450013257 | (37.7551651932954, -122.42450013257) | 2 | 4 | 5 | 28859 | 19 | ||
22665 | 67038 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 140 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1994 12:00:00 AM | Permit Number 30414 | 6004243.51306572 | 2101045.11693078 | 37.7493098678885 | -122.4281265241 | (37.7493098678885, -122.4281265241) | 2 | 4 | 5 | 28862 | 22 | ||
22948 | 63826 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 801 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24514 | 6008974.10291824 | 2096930.94751017 | 37.7382797803205 | -122.411477359627 | (37.7382797803205, -122.411477359627) | 10 | 7 | 7 | 28859 | 2 | ||
23050 | 63859 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 573 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24560 | 6002112.91730611 | 2110421.71062272 | 37.7749349366141 | -122.436165074208 | (37.7749349366141, -122.436165074208) | 15 | 5 | 11 | 29492 | 10 | ||
23454 | 63811 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 397 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24498 | 6008814.87080902 | 2096945.70760042 | 37.7383113756234 | -122.41202895062 | (37.7383113756234, -122.41202895062) | 10 | 7 | 7 | 28859 | 2 | ||
24018 | 53050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1024 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767676 | 6009180.15933 | 2118047.86674 | 37.7962735150778 | -122.412257006676 | (37.7962735150778, -122.412257006676) | 3 | 1 | 10 | 308 | 21 |
24058 | 34407 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 151 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38155 | 6004576.44969274 | 2097521.36031941 | 37.7396532725762 | -122.426724317666 | (37.7396532725762, -122.426724317666) | 2 | 7 | 5 | 63 | 7 | ||
24939 | 37321 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 445 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | Permit Number 41123 | 6003410.55922166 | 2103870.78228446 | 37.7570213149701 | -122.431208559798 | (37.7570213149701, -122.431208559798) | 2 | 4 | 5 | 28862 | 3 | ||
25476 | 59994 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 331 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1982 12:00:00 AM | 7 | Permit Number 19478 | 5997127.59055 | 2115197.55495 | 37.7877636478193 | -122.453755234125 | (37.7877636478193, -122.453755234125) | 11 | 6 | 1 | 54 | 31 | |
26417 | 66310 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1990 12:00:00 AM | Permit Number 29425 | 6001332.72327258 | 2095407.42415394 | 37.7336649686266 | -122.43778834571 | (37.7336649686266, -122.43778834571) | 9 | 7 | 5 | 63 | 40 | ||
27069 | 31476 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 282 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 7 | Permit Number 35042 | 6001438.63779 | 2104181.90614 | 37.7577636411886 | -122.438050483837 | (37.7577636411886, -122.438050483837) | 2 | 4 | 5 | 28862 | 3 | |
27248 | 42307 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42530 | 5998732.16654968 | 2093631.30703212 | 37.7286399521282 | -122.446651448677 | (37.7286399521282, -122.446651448677) | 9 | 7 | 4 | 28861 | 40 | ||
27284 | 32001 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Brazil Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1995 12:00:00 AM | Permit Number 35398 | 6004626.44544717 | 2090517.44642515 | 37.7204249107717 | -122.426052988126 | (37.7204249107717, -122.426052988126) | 9 | 7 | 6 | 28861 | 5 | ||
27288 | 33750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 845 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38932 | 6005705.24449579 | 2104057.07564242 | 37.7576626039009 | -122.42328590054 | (37.7576626039009, -122.42328590054) | 2 | 4 | 5 | 28859 | 19 | ||
28328 | 45196 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3379 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2001 12:00:00 AM | Permit Number 44041 | 6005846.47654917 | 2103129.45360257 | 37.7551235392216 | -122.422731541054 | (37.7551235392216, -122.422731541054) | 2 | 4 | 5 | 28859 | 19 |
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) );