Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 133315 | 133315 | 182033 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1318 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5988666.672 | 2106312.5286 | 37.7628791367764 | -122.48237680780599 | (37.7628791367764, -122.482376807806) | |||
| 61479 | 61479 | 120317 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 442 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5988773.16818 | 2112284.8883 | 37.77928378225079 | -122.482446109308 | (37.7792837822508, -122.482446109308) | |||
| 31105 | 31105 | 46360 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 514 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2004 12:00:00 AM | 2 | Permit Number 44598 | 5988790.17087 | 2111781.3196900003 | 37.7779021128043 | -122.48235038480101 | (37.7779021128043, -122.482350384801) | |
| 111423 | 111423 | 45036 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2303 24th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2001 12:00:00 AM | Permit Number 43927 | 5988847.11690672 | 2099646.08528379 | 37.744585360466 | -122.48126452014 | (37.744585360466, -122.48126452014) | ||
| 32466 | 32466 | 120488 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 6020 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5988854.16632 | 2114030.55727 | 37.7840816098569 | -122.48229384037799 | (37.7840816098569, -122.482293840378) | |||
| 43142 | 43142 | 182094 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2345 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988860.1945 | 2099353.6516 | 37.7437831746845 | -122.48119789136601 | (37.7437831746845, -122.481197891366) | |||
| 176343 | 176343 | 182093 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2345 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988860.1945 | 2099380.3749 | 37.7438565498511 | -122.481199847808 | (37.7438565498511, -122.481199847808) | |||
| 160944 | 160944 | 182095 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2345 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988860.871 | 2099329.6345 | 37.74371726936079 | -122.481193793904 | (37.7437172693608, -122.481193793904) | |||
| 54220 | 54220 | 182096 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2345 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988861.2093 | 2099306.9704 | 37.74365505935771 | -122.481190964904 | (37.7436550593577, -122.481190964904) | |||
| 29287 | 29287 | 120447 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 55 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988944.82314 | 2114949.71234 | 37.7866106225502 | -122.482047561852 | (37.7866106225502, -122.482047561852) | |||
| 70192 | 70192 | 120446 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 55 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988945.575730001 | 2114940.19348 | 37.7865845302304 | -122.482044260519 | (37.7865845302304, -122.482044260519) | |||
| 137708 | 137708 | 120445 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 65 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988945.83143 | 2114929.73493 | 37.7865558288888 | -122.482042609422 | (37.7865558288888, -122.482042609422) | |||
| 65669 | 65669 | 120444 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 65 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988946.42808 | 2114912.8547400003 | 37.786509515373794 | -122.48203930813101 | (37.7865095153738, -122.482039308131) | |||
| 37978 | 37978 | 120443 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 77 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988946.9866 | 2114882.9089200003 | 37.786427325124 | -122.48203518126199 | (37.786427325124, -122.482035181262) | |||
| 73119 | 73119 | 120442 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 77 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5988947.55811 | 2114864.8414 | 37.7863777500738 | -122.482031879947 | (37.7863777500738, -122.482031879947) | |||
| 106959 | 106959 | 12796 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2025 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/1990 12:00:00 AM | 12 | 3X3 | 5989146.0199 | 2114666.32821 | 37.7858442295496 | -122.481330717904 | (37.7858442295496, -122.481330717904) | ||
| 172194 | 172194 | 33804 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1411 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | 0 | Permit Number 38506 | 5989260.68046067 | 2105731.95209097 | 37.761319566555 | -122.480279867052 | (37.761319566555, -122.480279867052) | ||
| 164259 | 164259 | 120714 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 124 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989311.18086 | 2114513.57102 | 37.7854344024084 | -122.48074812632099 | (37.7854344024084, -122.480748126321) | |||
| 183908 | 183908 | 120713 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 124 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989311.23496 | 2114525.1179299997 | 37.7854661101097 | -122.480748784796 | (37.7854661101097, -122.480748784796) | |||
| 40113 | 40113 | 120715 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 126 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989312.46235 | 2114493.2875900003 | 37.785378784315206 | -122.480742207337 | (37.7853787843152, -122.480742207337) | |||
| 133980 | 133980 | 120736 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 718 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5989459.46048 | 2110420.19517 | 37.7742037514814 | -122.47993547166901 | (37.7742037514814, -122.479935471669) | |||
| 67723 | 67723 | 44796 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1427 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 1 | Permit Number 43890 | 5989579.5364 | 2105634.5108 | 37.7610705422286 | -122.47916996271002 | (37.7610705422286, -122.47916996271) | |
| 153472 | 153472 | 82373 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 514 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51520 | 5989717.7120199995 | 2111819.5418700003 | 37.778060971226104 | -122.479144526651 | (37.7780609712261, -122.479144526651) | |
| 120298 | 120298 | 12765 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1809 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | 6 | 4x4 | 5989831.1491 | 2114690.64776 | 37.785950813422204 | -122.478962167728 | (37.7859508134222, -122.478962167728) | ||
| 87959 | 87959 | 121284 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 88763 | 88763 | 121283 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 93289 | 93289 | 121276 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 93639 | 93639 | 121277 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 94711 | 94711 | 121282 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 96933 | 96933 | 121279 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 138526 | 138526 | 121281 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 139824 | 139824 | 121278 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 140929 | 140929 | 121280 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 369 18th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x15 | 5990184.0 | 2112906.0 | 37.781071152831004 | -122.477610920079 | (37.781071152831, -122.477610920079) | ||||
| 187816 | 187816 | 43812 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 1 | Permit Number 43443 | 5990206.91027 | 2114192.65817 | 37.7846052867946 | -122.477625737803 | (37.7846052867946, -122.477625737803) | ||
| 69541 | 69541 | 43813 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50629 | 5990207.24302 | 2114208.40208 | 37.784648534476 | -122.477625737794 | (37.784648534476, -122.477625737794) | |
| 42851 | 42851 | 43811 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43443 | 5990208.52089 | 2114170.80069 | 37.784545365735 | -122.477618567464 | (37.784545365735, -122.477618567464) | ||
| 177002 | 177002 | 122047 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990208.67805 | 2114141.58816 | 37.784465165419604 | -122.47761588776599 | (37.7844651654196, -122.477615887766) | |||
| 170013 | 170013 | 122048 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990208.73434 | 2114159.22808 | 37.784513602972005 | -122.47761698283199 | (37.784513602972, -122.477616982832) | |||
| 168774 | 168774 | 122046 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 193 18th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990208.911 | 2114122.68237 | 37.7844132689265 | -122.477613699483 | (37.7844132689265, -122.477613699483) | |||
| 169287 | 169287 | 43767 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 562 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 1 | Permit Number 43402 | 5990349.33947 | 2111537.06728 | 37.777322035739395 | -122.47693887875099 | (37.7773220357394, -122.476938878751) | |
| 38026 | 38026 | 68360 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 716 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 2 | Permit Number 32180 | 5990389.00128 | 2110476.58792 | 37.774412551740205 | -122.476724178706 | (37.7744125517402, -122.476724178706) | |
| 52642 | 52642 | 68313 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 125 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 4 | Permit Number 32126 | 5990505.89446 | 2114550.40815 | 37.785604914031296 | -122.476617509135 | (37.7856049140313, -122.476617509135) | |
| 32967 | 32967 | 105663 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x2 | 5990541.506469999 | 2113621.53342 | 37.783056548593 | -122.476426424914 | (37.783056548593, -122.476426424914) | |||
| 76281 | 76281 | 46647 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 118 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2013 12:00:00 AM | 1 | Permit Number 770374 | 5990550.1058 | 2114607.23395 | 37.7857635060004 | -122.476468705016 | (37.7857635060004, -122.476468705016) | |
| 44298 | 44298 | 64385 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 315 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 6 | Permit Number 25226 | 5990554.51497 | 2113259.89684 | 37.7820643495075 | -122.47635499626301 | (37.7820643495075, -122.476354996263) | ||
| 152232 | 152232 | 122087 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 643 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5990635.16079 | 2111007.92405 | 37.7758857303963 | -122.47591148725 | (37.7758857303963, -122.47591148725) | |||
| 180734 | 180734 | 67417 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 787 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/1992 12:00:00 AM | 4 | Permit Number 30916 | 5990669.84727 | 2110037.89934 | 37.7732243191199 | -122.475720648254 | (37.7732243191199, -122.475720648254) | ||
| 50600 | 50600 | 219079 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2674 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5990725.25402 | 2095140.06488 | 37.7323219940584 | -122.474441593613 | (37.7323219940584, -122.474441593613) | |||
| 54168 | 54168 | 219017 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1247 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990773.84618 | 2106908.19715 | 37.76463703279239 | -122.47513238806299 | (37.7646370327924, -122.475132388063) | |||
| 155992 | 155992 | 122120 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 127 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990816.32296 | 2114544.74752 | 37.7856073718539 | -122.475543114189 | (37.7856073718539, -122.475543114189) | |||
| 27999 | 27999 | 53556 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 155 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1969 12:00:00 AM | 5 | Permit Number 6468 | 5990822.61349 | 2114386.11588 | 37.7851721782666 | -122.47550976424 | (37.7851721782666, -122.47550976424) | ||
| 107601 | 107601 | 44075 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 409 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2001 12:00:00 AM | Permit Number 43597 | 5990886.42545988 | 2112617.28955618 | 37.7803191707205 | -122.47515982200301 | (37.7803191707205, -122.475159822003) | |||
| 120766 | 120766 | 12713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1462 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1990 12:00:00 AM | 8 | 3X3 | 5990888.84892 | 2114785.4149599997 | 37.786272381533706 | -122.475309775012 | (37.7862723815337, -122.475309775012) | ||
| 126420 | 126420 | 12712 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1462 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/1994 12:00:00 AM | 12 | 3X3 | 5990903.08198 | 2114785.23215 | 37.7862727045665 | -122.47526051946501 | (37.7862727045665, -122.475260519465) | ||
| 122588 | 122588 | 12709 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1448 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/24/1990 12:00:00 AM | 20 | 3X3 | 5990924.23041 | 2114788.11678 | 37.7862818507248 | -122.47518756279 | (37.7862818507248, -122.47518756279) | ||
| 123103 | 123103 | 12708 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1448 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 8 | 3X3 | 5990942.238 | 2114788.08158 | 37.786282797765104 | -122.475125259251 | (37.7862827977651, -122.475125259251) | ||
| 74983 | 74983 | 51270 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 628 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2014 12:00:00 AM | 1 | Permit Number 771154 | 5990988.32519 | 2111110.5307299998 | 37.776187930597295 | -122.474697303645 | (37.7761879305973, -122.474697303645) | |
| 88036 | 88036 | 12702 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1415 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 6 | 3X3 | 5991067.52539 | 2114735.08687 | 37.7861445496005 | -122.474687932397 | (37.7861445496005, -122.474687932397) | ||
| 23160 | 23160 | 12698 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1400 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5991072.89411 | 2114792.56605 | 37.7863026824924 | -122.474673554881 | (37.7863026824924, -122.474673554881) | |||
| 186074 | 186074 | 219018 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1371 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991112.59614 | 2106090.92873 | 37.7624126595246 | -122.473901124453 | (37.7624126595246, -122.473901124453) | |||
| 19799 | 19799 | 12700 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1403 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/1994 12:00:00 AM | 6 | 3X3 | 5991113.63066 | 2114737.21771 | 37.786153071735896 | -122.474528577552 | (37.7861530717359, -122.474528577552) | ||
| 53456 | 53456 | 219026 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1449 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991178.84607 | 2107216.2510900004 | 37.7655063309859 | -122.473754089794 | (37.7655063309859, -122.473754089794) | |||
| 57770 | 57770 | 121968 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 44 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5991181.38701 | 2114863.262 | 37.7865030798053 | -122.474303361826 | (37.7865030798053, -122.474303361826) | ||||
| 38754 | 38754 | 219028 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1490 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 5991185.310269999 | 2105281.9213400004 | 37.76019555188989 | -122.473590620024 | (37.7601955518899, -122.473590620024) | |||
| 161796 | 161796 | 219027 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1443 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991203.05325 | 2107216.60124 | 37.765508694390896 | -122.473670389004 | (37.7655086943909, -122.473670389004) | |||
| 83045 | 83045 | 65808 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2300 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28776 | 5991285.24152373 | 2099744.65687546 | 37.7449974586831 | -122.472841240296 | (37.7449974586831, -122.472841240296) | ||
| 72825 | 72825 | 74616 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2350 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 1 | 5991316.62714 | 2112033.26872 | 37.7787405344574 | -122.473628955238 | (37.7787405344574, -122.473628955238) | ||
| 55836 | 55836 | 219051 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2642 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991454.81179 | 2097430.44339 | 37.7386530359974 | -122.472086252978 | (37.7386530359974, -122.472086252978) | |||
| 33446 | 33446 | 219020 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1418 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991492.507259999 | 2105759.2792 | 37.7615240358153 | -122.47256298451299 | (37.7615240358153, -122.472562984513) | |||
| 146839 | 146839 | 219019 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1418 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991493.85585 | 2105743.6549 | 37.7614812136945 | -122.472557181186 | (37.7614812136945, -122.472557181186) | |||
| 45227 | 45227 | 51261 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 483 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 2 | Permit Number 47638 | 5991555.867459999 | 2112145.30882 | 37.779062018233 | -122.47280950933902 | (37.779062018233, -122.472809509339) | |
| 454 | 454 | 251309 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2111 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991606.081259999 | 2101026.68041 | 37.7485361329461 | -122.471825260742 | (37.7485361329461, -122.471825260742) | ||||
| 132176 | 132176 | 219050 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2226 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991760.48852 | 2100259.76764 | 37.746439321329 | -122.47123546015499 | (37.746439321329, -122.471235460155) | |||
| 177946 | 177946 | 124027 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 201 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991798.47727 | 2113998.77869 | 37.7841651786362 | -122.47210536758999 | (37.7841651786362, -122.47210536759) | |||
| 118328 | 118328 | 68699 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 162 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 772824 | 5991833.16910244 | 2114366.69190669 | 37.785177374174104 | -122.472012172388 | (37.7851773741741, -122.472012172388) | ||
| 50980 | 50980 | 68700 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 168 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 4 | Permit Number 32612 | 5991833.50014 | 2114340.31773 | 37.785104977135404 | -122.472009104115 | (37.7851049771354, -122.472009104115) | |
| 19494 | 19494 | 68790 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32727 | 5991985.43941061 | 2099518.6478439 | 37.744417405952 | -122.470403648157 | (37.744417405952, -122.470403648157) | ||
| 88094 | 88094 | 60847 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 2345 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32728 | 5991986.7837073 | 2099479.42782761 | 37.744309795556504 | -122.47039614419201 | (37.7443097955565, -122.470396144192) | ||
| 54227 | 54227 | 219100 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2339 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991987.82564 | 2099493.5872400003 | 37.744348733921 | -122.470393572423 | (37.744348733921, -122.470393572423) | |||
| 166333 | 166333 | 219101 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2345 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991990.11619 | 2099461.86688 | 37.744261770371 | -122.470383342635 | (37.744261770371, -122.470383342635) | |||
| 73245 | 73245 | 219057 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2043 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5992040.14931 | 2095397.21608 | 37.7331041614161 | -122.469914455893 | (37.7331041614161, -122.469914455893) | |||
| 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) | |||
| 88208 | 88208 | 104418 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1125 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | Permit Number 770463 | 5992112.0 | 2110623.1 | 37.7749146251824 | -122.47077473048 | (37.7749146251824, -122.47077473048) | |||
| 51791 | 51791 | 219021 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1346 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992113.21789 | 2106275.98534 | 37.7629786829377 | -122.470453853963 | (37.7629786829377, -122.470453853963) | |||
| 88254 | 88254 | 67724 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1346 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31342 | 5992116.05706304 | 2106274.73338322 | 37.7629754095582 | -122.47044394314699 | (37.7629754095582, -122.470443943147) | ||
| 113275 | 113275 | 47160 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 200 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52542 | 5992116.68521556 | 2095408.98560737 | 37.7331409014555 | -122.46965070979601 | (37.7331409014555, -122.469650709796) | ||
| 127823 | 127823 | 47159 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 200 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52542 | 5992116.68521556 | 2095408.98560737 | 37.7331409014555 | -122.46965070979601 | (37.7331409014555, -122.469650709796) | ||
| 75712 | 75712 | 67448 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1125 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/02/2013 12:00:00 AM | 1 | Permit Number 770463 | 5992116.869080001 | 2110647.4153 | 37.774981669988705 | -122.470759658967 | (37.7749816699887, -122.470759658967) | |
| 133701 | 133701 | 123780 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1101 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5992128.669869999 | 2110647.16676 | 37.7749816699912 | -122.470718819766 | (37.7749816699912, -122.470718819766) | |||
| 55839 | 55839 | 43667 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 335 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 3 | Permit Number 43310 | 5992137.1928 | 2113155.3528400003 | 37.7818689583158 | -122.470872084018 | (37.7818689583158, -122.470872084018) | |
| 40348 | 40348 | 68689 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 162 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 4 | Permit Number 32599 | 5992138.9687 | 2114381.7472 | 37.7852364025335 | -122.47095530753 | (37.7852364025335, -122.47095530753) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 53111 | 53111 | 219092 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1275 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992358.80283 | 2106761.11871 | 37.7643249275863 | -122.469639786754 | (37.7643249275863, -122.469639786754) | |||
| 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) | ||
| 149544 | 149544 | 219036 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1451 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992399.46309 | 2105574.2475900003 | 37.761068442877296 | -122.46941275649598 | (37.7610684428773, -122.469412756496) | |||
| 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) |
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");