trees
3,247 rows where qSpecies_id = 22 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
796 | 36869 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
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 | |||
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 | |||
1594 | 264718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 6 | 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 | |||
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 | ||
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 | |
2803 | 39877 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
3744 | 39401 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 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 | |
4074 | 264716 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 4 | 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 | |||
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 | ||
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 | |||
4392 | 264717 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 5 | 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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
8776 | 264714 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 2 | 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 | |||
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 | |||
8996 | 98282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008179.30272 | 2110863.50432 | 37.7764907880679 | -122.415211370411 | (37.7764907880679, -122.415211370411) | 8 | 2 | 9 | 28853 | 34 | ||
9164 | 264712 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 4 | 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 | |||
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 | |||
9701 | 50525 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 278 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2020 12:00:00 AM | 3 | Permit Number 785437 | 6013437.34066 | 2105807.45901 | 37.7629021146671 | -122.396667663687 | (37.7629021146671, -122.396667663687) | 14 | 3 | 8 | 28856 | 29 | ||
9774 | 264715 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 16th St | 3 | 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 | |||
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 | |||
10270 | 58254 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 588 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2014 12:00:00 AM | 12 | Permit Number 772841 | 6014358.43843 | 2104381.36252 | 37.7590375848275 | -122.393382076919 | (37.7590375848275, -122.393382076919) | 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 | |||
10315 | 264711 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 3 | 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 | |||
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 | |
10664 | 260923 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2019 12:00:00 AM | 3 | 5990807.95481 | 2114868.4417 | 37.7864956605801 | -122.475595709543 | (37.7864956605801, -122.475595709543) | 11 | 6 | 1 | 54 | 33 | |||
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 | ||
11309 | 44191 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
11687 | 95013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.405649829104 | (37.7118779294401, -122.405649829104) | 9 | 7 | 8 | 309 | 39 | ||||
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 | |||
12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
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 | |||
12788 | 84750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
13115 | 51970 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
13172 | 264709 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina 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 | |||
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 | |||
13578 | 253069 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 420 Innes Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Permit Number 770367 | 6021281.00752 | 2092952.36789 | 37.7280379741387 | -122.368650880757 | (37.7280379741387, -122.368650880757) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
14814 | 50011 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | Permit Number 46742 | |||||||||||||
14850 | 98281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.7765329177037 | -122.415259547114 | (37.7765329177037, -122.415259547114) | 8 | 2 | 9 | 28853 | 34 | ||
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 | ||
15361 | 36968 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 118 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/1998 12:00:00 AM | 5 | Permit Number 39595 | 5993987.97624 | 2114726.89582 | 37.786290850626 | -122.464583430573 | (37.786290850626, -122.464583430573) | 11 | 6 | 1 | 54 | 11 | ||
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 | |||
15898 | 36871 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
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 | ||
16108 | 264710 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 2 | 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 | |||
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 | |||
16322 | 41156 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 455 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2004 12:00:00 AM | Permit Number 47674 | 6009883.81375688 | 2109165.06157558 | 37.7719229056173 | -122.409195075279 | (37.7719229056173, -122.409195075279) | 14 | 2 | 9 | 28853 | 34 | |||
16336 | 36872 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
16438 | 87300 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 2 | Back Yard : Yard | Tree | DPW 1 | 6 | Permit Number 50312 | 6011877.98748 | 2100898.05147 | 37.749335051069 | -122.401715863223 | (37.749335051069, -122.401715863223) | 10 | 3 | 8 | 58 | 1 | |||
16453 | 260924 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2019 12:00:00 AM | 3 | 5990807.95481 | 2114868.4417 | 37.7864956605801 | -122.475595709543 | (37.7864956605801, -122.475595709543) | 11 | 6 | 1 | 54 | 33 | |||
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 | |||
17318 | 39391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
17433 | 36873 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
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 |
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) );