trees
3,247 rows where qSpecies_id = 22 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
8250 | 19840 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
11197 | 19797 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
12826 | 19801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
14048 | 19740 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
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 | ||||||||||||||
16572 | 19741 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
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 | ||||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
153512 | 107579 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | 9 | 8 | 4 | 64 | 24 | ||
182443 | 107581 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.94682 | 2086830.99569 | 37.7096038591978 | -122.468068397753 | (37.7096038591978, -122.468068397753) | 9 | 8 | 4 | 64 | 24 | ||
116754 | 107580 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.7096038592127 | -122.468025367885 | (37.7096038592127, -122.468025367885) | 9 | 8 | 4 | 64 | 24 | ||
9176 | 176544 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 7 | : | Tree | Private 2 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.468531792305 | (37.7096104062721, -122.468531792305) | 9 | 8 | 4 | 64 | 24 | |||
175627 | 107582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.47342 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | 9 | 8 | 4 | 64 | 24 | ||
93251 | 176543 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 6 | : | Tree | Private 2 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.7096169524177 | -122.468449043003 | (37.7096169524177, -122.468449043003) | 9 | 8 | 4 | 64 | 24 | |||
84647 | 176542 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 5 | : | Tree | Private 2 | 1 | Width 3ft | 5992312.69836 | 2086838.42699 | 37.7096195712459 | -122.468349744347 | (37.7096195712459, -122.468349744347) | 9 | 8 | 4 | 64 | 24 | |||
118561 | 176541 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 213 Saint Charles Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992061.3412 | 2087065.50702 | 37.7102285570869 | -122.469234987506 | (37.7102285570869, -122.469234987506) | 9 | 8 | 4 | 64 | 24 | |||
34238 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 10x10 | 5992081.50866 | 2087171.04221 | 37.7105194967412 | -122.469172961285 | (37.7105194967412, -122.469172961285) | 9 | 8 | 4 | 64 | 24 | |||
190234 | 159340 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 38 Whipple Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 12:16:00 PM | 3 | Width 0ft | 5998227.58529 | 2087220.48645 | 37.7110084860347 | -122.447934438717 | (37.7110084860347, -122.447934438717) | 9 | 7 | 6 | 28861 | 25 | ||
9489 | 219078 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 23 Bright St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5993714.36027 | 2087390.34861 | 37.7112158768855 | -122.463545422096 | (37.7112158768855, -122.463545422096) | 9 | 8 | 4 | 64 | 24 | |||
89753 | 25339 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2001 12:00:00 AM | 3 | 3X3 | 5994735.55505 | 2087387.95343 | 37.711268087013 | -122.460015770114 | (37.711268087013, -122.460015770114) | 9 | 8 | 6 | 28861 | 24 | ||
51267 | 19073 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 207 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5994916.47783 | 2087386.74786 | 37.7112751808846 | -122.459390372563 | (37.7112751808846, -122.459390372563) | 9 | 8 | 6 | 28861 | 24 | |||
18644 | 219072 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995143.85497 | 2087382.22564 | 37.7112758346919 | -122.458604178052 | (37.7112758346919, -122.458604178052) | 9 | 8 | 6 | 28861 | 24 | |||
68798 | 19068 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 197 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1997 12:00:00 AM | 6 | 3X3 | 5995078.75797 | 2087384.27088 | 37.71127770888 | -122.458829316129 | (37.71127770888, -122.458829316129) | 9 | 8 | 6 | 28861 | 24 | ||
20111 | 1217 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.09824 | 37.7112992341463 | -122.463612070865 | (37.7112992341463, -122.463612070865) | 9 | 8 | 4 | 64 | 24 | ||
179810 | 51605 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2005 12:00:00 AM | Permit Number 47902 | 5994151.59939184 | 2087413.0796794 | 37.7113034743583 | -122.462035873495 | (37.7113034743583, -122.462035873495) | 9 | 8 | 6 | 28861 | 24 | |||
39256 | 17240 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 288X Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994052.53109 | 2087477.46763 | 37.7114745641852 | -122.46238294313 | (37.7114745641852, -122.46238294313) | 9 | 8 | 6 | 28861 | 24 | |||
103005 | 19099 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 280 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2000 12:00:00 AM | 6 | 3X4 | 5994211.21795 | 2087475.16429 | 37.7114773763499 | -122.461834317098 | (37.7114773763499, -122.461834317098) | 9 | 8 | 6 | 28861 | 24 | ||
76262 | 19101 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 286 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2000 12:00:00 AM | 3 | 3X3 | 5994132.39945 | 2087476.81693 | 37.7114773763557 | -122.462106852145 | (37.7114773763557, -122.462106852145) | 9 | 8 | 6 | 28861 | 24 | ||
154112 | 29924 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 288X Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5994099.1729 | 2087478.19658 | 37.7114792514346 | -122.462221790909 | (37.7114792514346, -122.462221790909) | 9 | 8 | 6 | 28861 | 24 | |||
179010 | 19064 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 178 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2014 12:54:00 PM | 6 | 3X3 | 5995196.63012 | 2087463.05702 | 37.7115008117791 | -122.45842762225 | (37.7115008117791, -122.45842762225) | 9 | 8 | 6 | 28861 | 24 | ||
92615 | 69418 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 156 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 6 | Permit Number 33523 | 6001409.83218 | 2087347.55332 | 37.7115387685699 | -122.436944943671 | (37.7115387685699, -122.436944943671) | 9 | 7 | 6 | 28861 | 5 | |
150363 | 177275 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 134 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 01:50:00 PM | 3 | Width 2ft | 5998042.78598 | 2087418.21702 | 37.7115408441972 | -122.448587378031 | (37.7115408441972, -122.448587378031) | 9 | 7 | 6 | 28861 | 25 | ||
23797 | 94990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.404779818423 | (37.7116594240627, -122.404779818423) | 9 | 7 | 8 | 309 | 39 | ||||
176185 | 187408 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 50 Leland Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6010703.7606 | 2087207.6456 | 37.7116784782683 | -122.404812664008 | (37.7116784782683, -122.404812664008) | 9 | 7 | 8 | 309 | 39 | |||
61024 | 94991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.404748673867 | (37.7116964188451, -122.404748673867) | 9 | 7 | 8 | 309 | 39 | ||||
103865 | 95014 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 95 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010465.4 | 2087260.9 | 37.7118113779993 | -122.405640255324 | (37.7118113779993, -122.405640255324) | 9 | 7 | 8 | 309 | 39 | ||||
140420 | 106472 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 101 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2014 12:00:00 AM | 3 | Permit Number 772868 | 6010429.7 | 2087279.3 | 37.7118599042892 | -122.405764940253 | (37.7118599042892, -122.405764940253) | 9 | 7 | 8 | 309 | 39 | ||
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 | ||||
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 | |
29104 | 216866 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:20:00 PM | 3 | Width 3ft | 5995872.63368 | 2087895.25589 | 37.7127263548073 | -122.456122418814 | (37.7127263548073, -122.456122418814) | 9 | 8 | 6 | 28861 | 24 | ||
69929 | 109058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772785 | 6000981.19022 | 2087817.6053 | 37.712805054485 | -122.438460096258 | (37.712805054485, -122.438460096258) | 9 | 7 | 6 | 28861 | 5 |
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 | |||
177638 | 176540 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1340 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011857.96847 | 2088639.5018 | 37.7156745159485 | -122.400923922912 | (37.7156745159485, -122.400923922912) | 10 | 7 | 8 | 309 | 39 | |||
90701 | 51804 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.439431058942 | (37.7158284472863, -122.439431058942) | 9 | 7 | 6 | 28861 | 5 | |||
126475 | 51806 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.439431058942 | (37.7158284472863, -122.439431058942) | 9 | 7 | 6 | 28861 | 5 | |||
156581 | 51805 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.439431058942 | (37.7158284472863, -122.439431058942) | 9 | 7 | 6 | 28861 | 5 | |||
168747 | 51803 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.439431058942 | (37.7158284472863, -122.439431058942) | 9 | 7 | 6 | 28861 | 5 | |||
189523 | 176524 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 852 Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000736.05759 | 2088940.42663 | 37.7158741240663 | -122.439387786529 | (37.7158741240663, -122.439387786529) | 9 | 7 | 6 | 28861 | 5 | |||
10523 | 262206 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 888 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000738 | 2088975 | 37.7159691653279 | -122.439383549479 | (37.7159691653279, -122.439383549479) | 9 | 7 | 6 | 28861 | 5 | ||||
23520 | 51660 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
46097 | 51658 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
111239 | 51657 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
131416 | 51659 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 965 @ PARIS Geneva Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.439937951405 | (37.7160289372019, -122.439937951405) | 9 | 7 | 6 | 28861 | 5 | |||
11718 | 176523 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 852 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 4 | Width 2ft | Permit Number 48053 | 6000783.87975 | 2089020.62281 | 37.7160970462187 | -122.439228236006 | (37.7160970462187, -122.439228236006) | 9 | 7 | 6 | 28861 | 5 | |
64519 | 176539 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010868.55665 | 2088874.81805 | 37.7162654064988 | -122.404360352946 | (37.7162654064988, -122.404360352946) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
54863 | 50496 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 766 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 6 | Permit Number 47133 | 6001214.03711 | 2089205.20914 | 37.7166283477038 | -122.437754623095 | (37.7166283477038, -122.437754623095) | 9 | 7 | 6 | 28861 | 5 | |
67457 | 176538 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 351 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781440 | 6011090.57956 | 2089007.63237 | 37.7166424922212 | -122.403602269453 | (37.7166424922212, -122.403602269453) | 9 | 7 | 8 | 309 | 39 | |
154320 | 176537 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 353 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781440 | 6011077.16933 | 2089015.56342 | 37.7166635201745 | -122.403649179893 | (37.7166635201745, -122.403649179893) | 9 | 7 | 8 | 309 | 39 | |
85473 | 219076 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 105 Majestic Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997099.54595 | 2089348.6148 | 37.7167872911766 | -122.451986630097 | (37.7167872911766, -122.451986630097) | 9 | 8 | 6 | 28861 | 24 | |||
85353 | 44043 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 438 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2000 12:00:00 AM | Permit Number 43574 | 6010388.22639171 | 2089356.5298458 | 37.7175612350831 | -122.406054531395 | (37.7175612350831, -122.406054531395) | 10 | 7 | 8 | 309 | 39 | |||
164898 | 176536 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 448 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010349.12937 | 2089363.29024 | 37.717577610905 | -122.406190148657 | (37.717577610905, -122.406190148657) | 10 | 7 | 8 | 309 | 39 | |||
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 | |||
146931 | 219075 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Majestic Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997267.3367 | 2089660.30758 | 37.7176527366739 | -122.451429131349 | (37.7176527366739, -122.451429131349) | 9 | 8 | 6 | 28861 | 24 | |||
79133 | 176520 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1407 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999174.41377 | 2089660.47464 | 37.7177622156247 | -122.444837263538 | (37.7177622156247, -122.444837263538) | 9 | 7 | 6 | 28861 | 25 | |||
191072 | 219071 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 778 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994285.94244 | 2089946.42348 | 37.7182671687656 | -122.461755121921 | (37.7182671687656, -122.461755121921) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
117129 | 219070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 915 Capitol Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995006.51385 | 2090023.52797 | 37.7185203333247 | -122.459270009121 | (37.7185203333247, -122.459270009121) | 9 | 8 | 6 | 28861 | 24 | |||
76927 | 84044 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 915 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49722 | 5995003.95807398 | 2090024.96350436 | 37.7185241280217 | -122.459278947225 | (37.7185241280217, -122.459278947225) | 9 | 8 | 6 | 28861 | 24 | ||
29415 | 108948 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774439 | 6002672.3 | 2089874.6 | 37.7185491584783 | -122.432761932836 | (37.7185491584783, -122.432761932836) | 9 | 7 | 6 | 28861 | 5 |
71337 | 65595 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 648 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/1990 12:00:00 AM | Permit Number 28497 | 6002593.16557245 | 2089884.83914592 | 37.7185727844662 | -122.433036198966 | (37.7185727844662, -122.433036198966) | 9 | 7 | 6 | 28861 | 5 | ||
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 |
38355 | 176529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 559 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003638.0746 | 2089931.06876 | 37.7187589360517 | -122.42942767166 | (37.7187589360517, -122.42942767166) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
52611 | 219077 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 494 Victoria St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993267.6387 | 2090426.62452 | 37.7195270128342 | -122.465309800205 | (37.7195270128342, -122.465309800205) | 9 | 8 | 6 | 64 | 24 | |||
138015 | 65521 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1990 12:00:00 AM | 8 | Permit Number 28408 | 6001922.53748 | 2090247.55155 | 37.7195306487984 | -122.435380214118 | (37.7195306487984, -122.435380214118) | 9 | 7 | 6 | 28861 | 5 | |
156788 | 176525 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6001927.74225 | 2090254.03018 | 37.7195487332566 | -122.435362686337 | (37.7195487332566, -122.435362686337) | 9 | 7 | 6 | 28861 | 5 | |||
110790 | 219074 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 250 Tara St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5997774.99858 | 2090348.20126 | 37.7195705903952 | -122.449723925911 | (37.7195705903952, -122.449723925911) | 9 | 8 | 6 | 28861 | 24 | |||
143369 | 66264 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 250 Tara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/1990 12:00:00 AM | Permit Number 29369 | 5997774.99968717 | 2090362.35065104 | 37.719609441401 | -122.44972494119 | (37.719609441401, -122.44972494119) | 9 | 8 | 6 | 28861 | 24 | ||
154680 | 219073 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 250 Tara St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997792.80656 | 2090380.48595 | 37.7196602554868 | -122.449664695695 | (37.7196602554868, -122.449664695695) | 9 | 8 | 6 | 28861 | 24 | |||
175575 | 115255 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 345 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772821 | 5995728.7 | 2090517.8 | 37.7199189816113 | -122.456809453119 | (37.7199189816113, -122.456809453119) | 9 | 8 | 6 | 28861 | 24 | |||
173684 | 65519 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 529 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1990 12:00:00 AM | Permit Number 28406 | 6002018.71967294 | 2090396.09993471 | 37.7199439913946 | -122.435058366498 | (37.7199439913946, -122.435058366498) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
176812 | 176528 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Prague St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004578.32338 | 2090490.71188 | 37.7203487836515 | -122.426217428296 | (37.7203487836515, -122.426217428296) | 9 | 7 | 6 | 28861 | 5 | |||
20365 | 176527 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004589.78271 | 2090506.01263 | 37.7203914438823 | -122.42617890585 | (37.7203914438823, -122.42617890585) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
36293 | 176526 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004597.29185 | 2090518.89763 | 37.720427247709 | -122.426153866008 | (37.720427247709, -122.426153866008) | 9 | 7 | 6 | 28861 | 5 | |||
128037 | 31393 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 134 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1995 12:00:00 AM | 2 | Permit Number 34986 | 5996537.48076 | 2090788.97078 | 37.7207099603809 | -122.454033368353 | (37.7207099603809, -122.454033368353) | 9 | 8 | 6 | 28861 | 24 | ||
94025 | 52978 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 554 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48958 | 5993806.42000954 | 2090906.17268529 | 37.7208747934184 | -122.463482227177 | (37.7208747934184, -122.463482227177) | 9 | 8 | 6 | 64 | 24 | ||
92471 | 176530 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 519 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002857.33344 | 2090724.39946 | 37.7208930119788 | -122.432183003759 | (37.7208930119788, -122.432183003759) | 9 | 7 | 6 | 28861 | 5 | |||
131713 | 52974 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 561 Bright St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48955 | 5993754.8623302 | 2090944.41829471 | 37.7209768359267 | -122.463663219473 | (37.7209768359267, -122.463663219473) | 9 | 8 | 6 | 64 | 24 | ||
104375 | 113266 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | 1 | Permit Number 774770 | 6012949.27071 | 2090610.02044 | 37.7211459795788 | -122.397289961272 | (37.7211459795788, -122.397289961272) | 10 | 3 | 8 | 58 | 1 |
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) );