Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4834 | 4834 | 50011 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 99@ 20TH ST Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | Permit Number 46742 | ||||||||
| 6258 | 6258 | 36871 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 10764 | 10764 | 19741 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 11829 | 11829 | 19801 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 12355 | 12355 | 36869 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 12425 | 12425 | 19740 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY15 | -50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 1OST | ||||||||
| 12626 | 12626 | 36872 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 14064 | 14064 | 19797 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY21 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 14259 | 14259 | 36873 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16189 | 16189 | 19840 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 100 STAIRWAY25 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 35802 | 35802 | 71599 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994726.40181 | 2086320.41636 | 37.7083363538073 | -122.45997012143101 | (37.7083363538073, -122.459970121431) | ||
| 137279 | 137279 | 73608 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 14 | 5994710.3414 | 2086333.6948099998 | 37.7083718896252 | -122.46002658894899 | (37.7083718896252, -122.460026588949) | ||
| 159957 | 159957 | 71600 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994689.24707 | 2086354.8441299999 | 37.708428747449204 | -122.460101024051 | (37.7084287474492, -122.460101024051) | ||
| 55464 | 55464 | 74182 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994679.00139 | 2086362.0842900001 | 37.7084480379267 | -122.46013695827 | (37.7084480379267, -122.46013695827) | ||
| 65128 | 65128 | 73960 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994666.9696 | 2086372.6899 | 37.7084764663958 | -122.46017930913601 | (37.7084764663958, -122.460179309136) | ||
| 136095 | 136095 | 71601 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 138 Wilson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994653.0975 | 2086384.07363 | 37.708506925528795 | -122.46022807666401 | (37.7085069255288, -122.460228076664) | ||
| 12169 | 12169 | 107579 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | ||
| 10524 | 10524 | 107581 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992393.946819999 | 2086830.9956900002 | 37.7096038591978 | -122.46806839775299 | (37.7096038591978, -122.468068397753) | ||
| 10370 | 10370 | 107580 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.709603859212706 | -122.468025367885 | (37.7096038592127, -122.468025367885) | ||
| 161043 | 161043 | 176544 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.46853179230499 | (37.7096104062721, -122.468531792305) | |||
| 11907 | 11907 | 107582 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.4734200002 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | ||
| 51729 | 51729 | 176543 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.709616952417704 | -122.468449043003 | (37.7096169524177, -122.468449043003) | |||
| 60465 | 60465 | 176542 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992312.69836 | 2086838.42699 | 37.7096195712459 | -122.468349744347 | (37.7096195712459, -122.468349744347) | |||
| 132784 | 132784 | 176541 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 213 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992061.3412 | 2087065.5070200001 | 37.7102285570869 | -122.46923498750601 | (37.7102285570869, -122.469234987506) | |||
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 4045 | 4045 | 159340 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 38 Whipple Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 12:16:00 PM | 3 | Width 0ft | 5998227.58529 | 2087220.48645 | 37.7110084860347 | -122.447934438717 | (37.7110084860347, -122.447934438717) | ||
| 56337 | 56337 | 219078 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 23 Bright St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993714.36027 | 2087390.3486099998 | 37.7112158768855 | -122.463545422096 | (37.7112158768855, -122.463545422096) | |||
| 20440 | 20440 | 25339 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 221 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2001 12:00:00 AM | 3 | 3X3 | 5994735.55505 | 2087387.95343 | 37.711268087013 | -122.460015770114 | (37.711268087013, -122.460015770114) | ||
| 18042 | 18042 | 19073 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 207 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5994916.47783 | 2087386.7478599998 | 37.7112751808846 | -122.45939037256299 | (37.7112751808846, -122.459390372563) | |||
| 168026 | 168026 | 219072 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 183 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995143.85497 | 2087382.22564 | 37.7112758346919 | -122.458604178052 | (37.7112758346919, -122.458604178052) | |||
| 20797 | 20797 | 19068 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 197 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1997 12:00:00 AM | 6 | 3X3 | 5995078.75797 | 2087384.27088 | 37.71127770888 | -122.458829316129 | (37.71127770888, -122.458829316129) | ||
| 17607 | 17607 | 1217 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 3501 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2016 12:00:00 AM | 3 | 3x3 | 5993695.72185 | 2087421.0982400002 | 37.711299234146296 | -122.463612070865 | (37.7112992341463, -122.463612070865) | ||
| 140952 | 140952 | 51605 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47902 | 5994151.59939184 | 2087413.0796794 | 37.711303474358296 | -122.46203587349501 | (37.7113034743583, -122.462035873495) | |||
| 17801 | 17801 | 17240 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 288X Sagamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994052.53109 | 2087477.4676299999 | 37.7114745641852 | -122.46238294313 | (37.7114745641852, -122.46238294313) | |||
| 20023 | 20023 | 19099 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 280 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2000 12:00:00 AM | 6 | 3X4 | 5994211.21795 | 2087475.1642900002 | 37.7114773763499 | -122.46183431709801 | (37.7114773763499, -122.461834317098) | ||
| 18330 | 18330 | 19101 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 286 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2000 12:00:00 AM | 3 | 3X3 | 5994132.39945 | 2087476.81693 | 37.7114773763557 | -122.462106852145 | (37.7114773763557, -122.462106852145) | ||
| 21958 | 21958 | 29924 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 288X Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 5994099.1729 | 2087478.19658 | 37.711479251434604 | -122.462221790909 | (37.7114792514346, -122.462221790909) | |||
| 22271 | 22271 | 19064 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 178 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2014 12:54:00 PM | 6 | 3X3 | 5995196.63012 | 2087463.0570200002 | 37.7115008117791 | -122.45842762225 | (37.7115008117791, -122.45842762225) | ||
| 24658 | 24658 | 69418 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 156 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 6 | Permit Number 33523 | 6001409.83218 | 2087347.5533200002 | 37.7115387685699 | -122.436944943671 | (37.7115387685699, -122.436944943671) | |
| 4051 | 4051 | 177275 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 134 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 01:50:00 PM | 3 | Width 2ft | 5998042.78598 | 2087418.21702 | 37.7115408441972 | -122.44858737803101 | (37.7115408441972, -122.448587378031) | ||
| 12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
| 161194 | 161194 | 187408 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Leland Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 6010703.7606 | 2087207.6456 | 37.7116784782683 | -122.404812664008 | (37.7116784782683, -122.404812664008) | |||
| 88454 | 88454 | 94991 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.40474867386699 | (37.7116964188451, -122.404748673867) | ||||
| 101628 | 101628 | 95014 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 95 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010465.4 | 2087260.9 | 37.7118113779993 | -122.405640255324 | (37.7118113779993, -122.405640255324) | ||||
| 73276 | 73276 | 106472 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 101 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2014 12:00:00 AM | 3 | Permit Number 772868 | 6010429.7 | 2087279.3 | 37.711859904289206 | -122.405764940253 | (37.7118599042892, -122.405764940253) | ||
| 12794 | 12794 | 95013 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.40564982910401 | (37.7118779294401, -122.405649829104) | ||||
| 132121 | 132121 | 37394 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 260 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 9 | Permit Number 39876 | 6000430.23445 | 2087496.65427 | 37.711892439557204 | -122.440341369156 | (37.7118924395572, -122.440341369156) | |
| 4199 | 4199 | 216866 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 225 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:20:00 PM | 3 | Width 3ft | 5995872.63368 | 2087895.2558900001 | 37.712726354807295 | -122.45612241881399 | (37.7127263548073, -122.456122418814) | ||
| 10783 | 10783 | 109058 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772785 | 6000981.190219999 | 2087817.6053 | 37.712805054485 | -122.438460096258 | (37.712805054485, -122.438460096258) |
| 169596 | 169596 | 176540 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1340 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011857.96847 | 2088639.5018 | 37.7156745159485 | -122.400923922912 | (37.7156745159485, -122.400923922912) | |||
| 92735 | 92735 | 51804 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 888 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.43943105894199 | (37.7158284472863, -122.439431058942) | |||
| 105192 | 105192 | 51806 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 888 Paris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.43943105894199 | (37.7158284472863, -122.439431058942) | |||
| 117767 | 117767 | 51803 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 888 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.43943105894199 | (37.7158284472863, -122.439431058942) | |||
| 119006 | 119006 | 51805 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 888 Paris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2005 12:00:00 AM | Permit Number 48053 | 6000723.19902231 | 2088924.05785102 | 37.7158284472863 | -122.43943105894199 | (37.7158284472863, -122.439431058942) | |||
| 169891 | 169891 | 176524 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 852 Paris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000736.05759 | 2088940.42663 | 37.715874124066296 | -122.43938778652901 | (37.7158741240663, -122.439387786529) | |||
| 83980 | 83980 | 51658 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 965 @ PARIS Geneva Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.43993795140499 | (37.7160289372019, -122.439937951405) | |||
| 100339 | 100339 | 51657 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 965 @ PARIS Geneva Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.43993795140499 | (37.7160289372019, -122.439937951405) | |||
| 108599 | 108599 | 51659 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 965 @ PARIS Geneva Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.43993795140499 | (37.7160289372019, -122.439937951405) | |||
| 129317 | 129317 | 51660 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 965 @ PARIS Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47940 | 6000578.12419421 | 2089000.08275614 | 37.7160289372019 | -122.43993795140499 | (37.7160289372019, -122.439937951405) | |||
| 68964 | 68964 | 176523 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 852 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000783.87975 | 2089020.6228099999 | 37.71609704621871 | -122.43922823600599 | (37.7160970462187, -122.439228236006) | |||
| 148696 | 148696 | 176539 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010868.55665 | 2088874.81805 | 37.71626540649879 | -122.404360352946 | (37.7162654064988, -122.404360352946) | |||
| 176423 | 176423 | 50496 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 766 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 6 | Permit Number 47133 | 6001214.03711 | 2089205.2091400002 | 37.7166283477038 | -122.437754623095 | (37.7166283477038, -122.437754623095) | |
| 147771 | 147771 | 176538 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 351 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011090.5795599995 | 2089007.63237 | 37.716642492221204 | -122.40360226945299 | (37.7166424922212, -122.403602269453) | |||
| 50281 | 50281 | 176537 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 353 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011077.16933 | 2089015.56342 | 37.7166635201745 | -122.403649179893 | (37.7166635201745, -122.403649179893) | |||
| 60594 | 60594 | 219076 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 105 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997099.54595 | 2089348.6148 | 37.7167872911766 | -122.45198663009701 | (37.7167872911766, -122.451986630097) | |||
| 92192 | 92192 | 44043 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 438 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2000 12:00:00 AM | Permit Number 43574 | 6010388.22639171 | 2089356.5298458 | 37.7175612350831 | -122.406054531395 | (37.7175612350831, -122.406054531395) | |||
| 151069 | 151069 | 176536 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 448 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010349.129369999 | 2089363.2902400002 | 37.717577610904996 | -122.406190148657 | (37.717577610905, -122.406190148657) | |||
| 19406 | 19406 | 44045 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 442 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2000 12:00:00 AM | Permit Number 43576 | 6010366.61752859 | 2089364.49737601 | 37.7175819036471 | -122.406129784758 | (37.7175819036471, -122.406129784758) | |||
| 134820 | 134820 | 219075 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 56 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997267.3367 | 2089660.30758 | 37.7176527366739 | -122.45142913134899 | (37.7176527366739, -122.451429131349) | |||
| 51897 | 51897 | 176520 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1407 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999174.4137699995 | 2089660.4746400001 | 37.7177622156247 | -122.44483726353799 | (37.7177622156247, -122.444837263538) | |||
| 49258 | 49258 | 219071 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 778 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994285.94244 | 2089946.4234799999 | 37.7182671687656 | -122.461755121921 | (37.7182671687656, -122.461755121921) | |||
| 39184 | 39184 | 71328 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 228 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 9 | 6004151.959980001 | 2089814.42795 | 37.718467747275795 | -122.427643069565 | (37.7184677472758, -122.427643069565) | ||
| 129733 | 129733 | 219070 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 915 Capitol Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 5995006.51385 | 2090023.5279700002 | 37.718520333324705 | -122.459270009121 | (37.7185203333247, -122.459270009121) | |||
| 94718 | 94718 | 84044 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 915 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49722 | 5995003.95807398 | 2090024.96350436 | 37.718524128021706 | -122.459278947225 | (37.7185241280217, -122.459278947225) | ||
| 125445 | 125445 | 108948 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774439 | 6002672.3 | 2089874.6 | 37.7185491584783 | -122.432761932836 | (37.7185491584783, -122.432761932836) |
| 90167 | 90167 | 65595 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 648 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | Permit Number 28497 | 6002593.16557245 | 2089884.83914592 | 37.718572784466204 | -122.43303619896601 | (37.7185727844662, -122.433036198966) | ||
| 178545 | 178545 | 95772 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767507 | 6002653.48548 | 2089890.5721 | 37.7185919472416 | -122.43282810725401 | (37.7185919472416, -122.432828107254) |
| 56625 | 56625 | 176529 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 559 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003638.0746 | 2089931.06876 | 37.7187589360517 | -122.42942767166001 | (37.7187589360517, -122.42942767166) | |||
| 49071 | 49071 | 71315 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 555 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 8 | 6003422.9520000005 | 2090101.24578 | 37.71921402269321 | -122.430183398047 | (37.7192140226932, -122.430183398047) | ||
| 32867 | 32867 | 219077 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 494 Victoria St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993267.6387 | 2090426.62452 | 37.7195270128342 | -122.465309800205 | (37.7195270128342, -122.465309800205) | |||
| 180627 | 180627 | 65521 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 555 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | 8 | Permit Number 28408 | 6001922.53748 | 2090247.55155 | 37.7195306487984 | -122.435380214118 | (37.7195306487984, -122.435380214118) | |
| 72091 | 72091 | 176525 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 555 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6001927.74225 | 2090254.03018 | 37.7195487332566 | -122.435362686337 | (37.7195487332566, -122.435362686337) | |||
| 163748 | 163748 | 219074 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 250 Tara St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997774.99858 | 2090348.2012599998 | 37.7195705903952 | -122.449723925911 | (37.7195705903952, -122.449723925911) | |||
| 111057 | 111057 | 66264 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 250 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/1990 12:00:00 AM | Permit Number 29369 | 5997774.99968717 | 2090362.35065104 | 37.719609441401 | -122.44972494119 | (37.719609441401, -122.44972494119) | ||
| 177549 | 177549 | 219073 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 250 Tara St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997792.8065599995 | 2090380.48595 | 37.7196602554868 | -122.449664695695 | (37.7196602554868, -122.449664695695) | |||
| 143006 | 143006 | 115255 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 345 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 772821 | 5995728.7 | 2090517.8 | 37.71991898161129 | -122.45680945311899 | (37.7199189816113, -122.456809453119) | |||
| 140690 | 140690 | 65519 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 529 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1990 12:00:00 AM | Permit Number 28406 | 6002018.71967294 | 2090396.09993471 | 37.7199439913946 | -122.435058366498 | (37.7199439913946, -122.435058366498) | ||
| 147537 | 147537 | 71325 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 114 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 5 | 6004555.30191 | 2090455.11867 | 37.7202497511935 | -122.426294473226 | (37.7202497511935, -122.426294473226) | ||
| 155785 | 155785 | 176528 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004578.32338 | 2090490.7118799998 | 37.7203487836515 | -122.426217428296 | (37.7203487836515, -122.426217428296) | |||
| 68051 | 68051 | 176527 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004589.78271 | 2090506.01263 | 37.7203914438823 | -122.42617890585 | (37.7203914438823, -122.42617890585) | |||
| 126579 | 126579 | 32001 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1100 Brazil Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | Permit Number 35398 | 6004626.44544717 | 2090517.44642515 | 37.720424910771705 | -122.42605298812599 | (37.7204249107717, -122.426052988126) | ||
| 170889 | 170889 | 176526 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004597.29185 | 2090518.89763 | 37.720427247709 | -122.426153866008 | (37.720427247709, -122.426153866008) | |||
| 70011 | 70011 | 31393 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 134 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/1995 12:00:00 AM | 2 | Permit Number 34986 | 5996537.48076 | 2090788.9707799999 | 37.720709960380894 | -122.45403336835301 | (37.7207099603809, -122.454033368353) | ||
| 91689 | 91689 | 52978 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 554 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48958 | 5993806.42000954 | 2090906.17268529 | 37.720874793418396 | -122.463482227177 | (37.7208747934184, -122.463482227177) | ||
| 65251 | 65251 | 176530 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 519 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6002857.33344 | 2090724.3994599998 | 37.720893011978795 | -122.43218300375901 | (37.7208930119788, -122.432183003759) | |||
| 109218 | 109218 | 52974 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 561 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48955 | 5993754.8623302 | 2090944.41829471 | 37.720976835926706 | -122.463663219473 | (37.7209768359267, -122.463663219473) | ||
| 72250 | 72250 | 113266 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 86 Carr St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | 1 | Permit Number 774770 | 6012949.27071 | 2090610.02044 | 37.72114597957879 | -122.397289961272 | (37.7211459795788, -122.397289961272) | ||
| 43358 | 43358 | 30913 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 183 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | ||
| 141761 | 141761 | 30914 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 183 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34734 | 5995612.81318116 | 2091099.78305051 | 37.7215103139917 | -122.457252110286 | (37.7215103139917, -122.457252110286) | |||
| 69739 | 69739 | 200151 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1294 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014053.259 | 2090750.7135 | 37.7215936967598 | -122.393483605481 | (37.7215936967598, -122.393483605481) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");