trees

3,247 rows where qSpecies_id = 22 sorted by XCoord

✎ View and edit SQL

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)
133117 182033 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1318 24th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5988666.672 2106312.5286 37.7628791367764 -122.482376807806 (37.7628791367764, -122.482376807806) 1 8 3 56 35
104012 120317 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 442 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5988773.16818 2112284.8883 37.7792837822508 -122.482446109308 (37.7792837822508, -122.482446109308) 11 6 2 55 26
3143 46360 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 514 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2002 12:00:00 AM 2   Permit Number 44598 5988790.17087 2111781.31969 37.7779021128043 -122.482350384801 (37.7779021128043, -122.482350384801) 11 6 2 55 26
145040 45036 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2303 24th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2001 12:00:00 AM     Permit Number 43927 5988847.11690672 2099646.08528379 37.744585360466 -122.48126452014 (37.744585360466, -122.48126452014) 1 8 3 29491 35
78935 120488 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 6020 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5988854.16632 2114030.55727 37.7840816098569 -122.482293840378 (37.7840816098569, -122.482293840378) 11 6 2 55 26
62134 182093 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2345 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5988860.1945 2099380.3749 37.7438565498511 -122.481199847808 (37.7438565498511, -122.481199847808) 1 8 3 29491 35
84392 182094 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2345 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5988860.1945 2099353.6516 37.7437831746845 -122.481197891366 (37.7437831746845, -122.481197891366) 1 8 3 29491 35
152698 182095 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2345 24th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5988860.871 2099329.6345 37.7437172693608 -122.481193793904 (37.7437172693608, -122.481193793904) 1 8 3 29491 35
86184 182096 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2345 24th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5988861.2093 2099306.9704 37.7436550593577 -122.481190964904 (37.7436550593577, -122.481190964904) 1 8 3 29491 35
55268 120447 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 55 22nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988944.82314 2114949.71234 37.7866106225502 -122.482047561852 (37.7866106225502, -122.482047561852) 11 6 1 55 33
182302 120446 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 55 22nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988945.57573 2114940.19348 37.7865845302304 -122.482044260519 (37.7865845302304, -122.482044260519) 11 6 1 55 33
77000 120445 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 65 22nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988945.83143 2114929.73493 37.7865558288888 -122.482042609422 (37.7865558288888, -122.482042609422) 11 6 1 55 33
99039 120444 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 65 22nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988946.42808 2114912.85474 37.7865095153738 -122.482039308131 (37.7865095153738, -122.482039308131) 11 6 1 55 33
104587 120443 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 77 22nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5988946.9866 2114882.90892 37.786427325124 -122.482035181262 (37.786427325124, -122.482035181262) 11 6 1 55 33
149358 120442 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 77 22nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5988947.55811 2114864.8414 37.7863777500738 -122.482031879947 (37.7863777500738, -122.482031879947) 11 6 1 55 33
131188 12796 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2025 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/11/1990 12:00:00 AM 12 3X3   5989146.0199 2114666.32821 37.7858442295496 -122.481330717904 (37.7858442295496, -122.481330717904) 11 6 2 55 26
166930 33804 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1411 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/1997 12:00:00 AM 0   Permit Number 38506 5989260.68046067 2105731.95209097 37.761319566555 -122.480279867052 (37.761319566555, -122.480279867052) 1 8 3 56 35
189397 120714 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 124 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5989311.18086 2114513.57102 37.7854344024084 -122.480748126321 (37.7854344024084, -122.480748126321) 11 6 2 55 26
112433 120713 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 124 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5989311.23496 2114525.11793 37.7854661101097 -122.480748784796 (37.7854661101097, -122.480748784796) 11 6 2 55 26
182760 120715 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 126 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5989312.46235 2114493.28759 37.7853787843152 -122.480742207337 (37.7853787843152, -122.480742207337) 11 6 2 55 26
184281 120736 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 718 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5989459.46048 2110420.19517 37.7742037514814 -122.479935471669 (37.7742037514814, -122.479935471669) 11 6 2 55 26
54119 44796 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1427 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 1   Permit Number 43890 5989579.5364 2105634.5108 37.7610705422286 -122.47916996271 (37.7610705422286, -122.47916996271) 1 8 3 56 35
107338 82373 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 514 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM 1 3x3 Permit Number 51520 5989717.71202 2111819.54187 37.7780609712261 -122.479144526651 (37.7780609712261, -122.479144526651) 11 6 2 55 26
145239 12765 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1809 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2003 12:00:00 AM 6 4x4   5989831.1491 2114690.64776 37.7859508134222 -122.478962167728 (37.7859508134222, -122.478962167728) 11 6 2 55 26
164491 251061 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 5418 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990182.6788 2112719.9143 37.7805601365444 -122.477601885097 (37.7805601365444, -122.477601885097) 11 6 2 55 26
5543 121277 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
36998 121281 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
62537 121276 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
77980 121283 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
80724 121284 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 17 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
93654 121280 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
128498 121278 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 11 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
149736 121282 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
152002 121279 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
159558 43812 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 193 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/26/2000 12:00:00 AM 1   Permit Number 43443 5990206.91027 2114192.65817 37.7846052867946 -122.477625737803 (37.7846052867946, -122.477625737803) 11 6 2 55 26
91905 43813 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 193 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM 3 3x3 Permit Number 50629 5990207.24302 2114208.40208 37.784648534476 -122.477625737794 (37.784648534476, -122.477625737794) 11 6 2 55 26
140487 43811 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 193 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/26/2000 12:00:00 AM 4   Permit Number 43443 5990208.52089 2114170.80069 37.784545365735 -122.477618567464 (37.784545365735, -122.477618567464) 11 6 2 55 26
190043 122047 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 193 18th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5990208.67805 2114141.58816 37.7844651654196 -122.477615887766 (37.7844651654196, -122.477615887766) 11 6 2 55 26
135099 122048 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 193 18th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5990208.73434 2114159.22808 37.784513602972 -122.477616982832 (37.784513602972, -122.477616982832) 11 6 2 55 26
35140 122046 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 193 18th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5990208.911 2114122.68237 37.7844132689265 -122.477613699483 (37.7844132689265, -122.477613699483) 11 6 2 55 26
193648 147591 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990250.17652 2113053.797 37.7814808023322 -122.477392789959 (37.7814808023322, -122.477392789959) 11 6 2 55 26
134962 147590 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990251.14725 2113004.86394 37.7813465020817 -122.477385854376 (37.7813465020817, -122.477385854376) 11 6 2 55 26
32980 147589 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990252.11416 2112971.56981 37.7812551417606 -122.477380075345 (37.7812551417606, -122.477380075345) 11 6 2 55 26
116306 147588 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990252.64201 2112933.29364 37.7811500766647 -122.477375451022 (37.7811500766647, -122.477375451022) 11 6 2 55 26
59424 43767 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 562 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 1   Permit Number 43402 5990349.33947 2111537.06728 37.7773220357394 -122.476938878751 (37.7773220357394, -122.476938878751) 11 6 2 55 26
159586 68360 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 716 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 2   Permit Number 32180 5990389.00128 2110476.58792 37.7744125517402 -122.476724178706 (37.7744125517402, -122.476724178706) 11 6 2 55 26
127816 68313 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 125 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/27/1993 12:00:00 AM 4   Permit Number 32126 5990505.89446 2114550.40815 37.7856049140313 -122.476617509135 (37.7856049140313, -122.476617509135) 11 6 2 55 26
8230 105663 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 263 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x2   5990541.50647 2113621.53342 37.783056548593 -122.476426424914 (37.783056548593, -122.476426424914) 11 6 2 55 26
102476 46647 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 118 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2013 12:00:00 AM 1   Permit Number 770374 5990550.1058 2114607.23395 37.7857635060004 -122.476468705016 (37.7857635060004, -122.476468705016) 11 6 2 54 26
69093 64385 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 315 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1988 12:00:00 AM 6   Permit Number 25226 5990554.51497 2113259.89684 37.7820643495075 -122.476354996263 (37.7820643495075, -122.476354996263) 11 6 2 55 26
105285 122087 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 643 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5990635.16079 2111007.92405 37.7758857303963 -122.47591148725 (37.7758857303963, -122.47591148725) 11 6 2 55 26
20653 67417 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 787 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/30/1992 12:00:00 AM 4   Permit Number 30916 5990669.84727 2110037.89934 37.7732243191199 -122.475720648254 (37.7732243191199, -122.475720648254) 11 6 2 55 26
91869 219079 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2674 Ocean Ave 1 : Tree Private 2     1 Width 3ft   5990725.25402 2095140.06488 37.7323219940584 -122.474441593613 (37.7323219940584, -122.474441593613) 1 8 4 64 40
29433 219017 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1247 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5990773.84618 2106908.19715 37.7646370327924 -122.475132388063 (37.7646370327924, -122.475132388063) 11 8 3 56 12
10664 260923 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 47 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2019 12:00:00 AM 3     5990807.95481 2114868.4417 37.7864956605801 -122.475595709543 (37.7864956605801, -122.475595709543) 11 6 1 54 33
16453 260924 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 47 16th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/28/2019 12:00:00 AM 3     5990807.95481 2114868.4417 37.7864956605801 -122.475595709543 (37.7864956605801, -122.475595709543) 11 6 1 54 33
29922 122120 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 127 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990816.32296 2114544.74752 37.7856073718539 -122.475543114189 (37.7856073718539, -122.475543114189) 11 6 2 54 26
110749 53556 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 155 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1969 12:00:00 AM 5   Permit Number 6468 5990822.61349 2114386.11588 37.7851721782666 -122.47550976424 (37.7851721782666, -122.47550976424) 11 6 2 54 26
131859 44075 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 409 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2001 12:00:00 AM     Permit Number 43597 5990886.42545988 2112617.28955618 37.7803191707205 -122.475159822003 (37.7803191707205, -122.475159822003) 11 6 2 54 26
124784 12713 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1462 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/24/1990 12:00:00 AM 8 3X3   5990888.84892 2114785.41496 37.7862723815337 -122.475309775012 (37.7862723815337, -122.475309775012) 11 6 1 54 33
122267 12712 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1462 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/11/1994 12:00:00 AM 12 3X3   5990903.08198 2114785.23215 37.7862727045665 -122.475260519465 (37.7862727045665, -122.475260519465) 11 6 1 54 33
166451 12709 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1448 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/24/1990 12:00:00 AM 20 3X3   5990924.23041 2114788.11678 37.7862818507248 -122.47518756279 (37.7862818507248, -122.47518756279) 11 6 1 54 33
24674 12708 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1448 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/1992 12:00:00 AM 8 3X3   5990942.238 2114788.08158 37.7862827977651 -122.475125259251 (37.7862827977651, -122.475125259251) 11 6 1 54 33
93573 51270 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 628 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2014 12:00:00 AM 1   Permit Number 771154 5990988.32519 2111110.53073 37.7761879305973 -122.474697303645 (37.7761879305973, -122.474697303645) 11 6 2 54 26
164081 12702 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1415 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/1992 12:00:00 AM 6 3X3   5991067.52539 2114735.08687 37.7861445496005 -122.474687932397 (37.7861445496005, -122.474687932397) 11 6 2 54 26
101741 12698 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1400 Lake St 2 Sidewalk: Curb side : Cutout Tree DPW 1     4 3X3   5991072.89411 2114792.56605 37.7863026824924 -122.474673554881 (37.7863026824924, -122.474673554881) 11 6 1 54 33
190331 219018 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1371 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5991112.59614 2106090.92873 37.7624126595246 -122.473901124453 (37.7624126595246, -122.473901124453) 1 8 11 56 12
116984 12700 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1403 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/11/1994 12:00:00 AM 6 3X3   5991113.63066 2114737.21771 37.7861530717359 -122.474528577552 (37.7861530717359, -122.474528577552) 11 6 2 54 26
75581 219026 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1449 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991178.84607 2107216.25109 37.7655063309859 -122.473754089794 (37.7655063309859, -122.473754089794) 11 8 11 56 12
94973 121968 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 44 15th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1     5991181.38701 2114863.262 37.7865030798053 -122.474303361826 (37.7865030798053, -122.474303361826) 11 6 1 54 33
72889 219028 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1490 16th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   5991185.31027 2105281.92134 37.7601955518899 -122.473590620024 (37.7601955518899, -122.473590620024) 1 8 4 56 12
94448 219027 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1443 Lincoln Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5991203.05325 2107216.60124 37.7655086943909 -122.473670389004 (37.7655086943909, -122.473670389004) 11 8 11 56 12
56661 65808 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2300 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/1990 12:00:00 AM     Permit Number 28776 5991285.24152373 2099744.65687546 37.7449974586831 -122.472841240296 (37.7449974586831, -122.472841240296) 1 8 4 29491 40
14854 74616 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2350 Anza St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5991316.62714 2112033.26872 37.7787405344574 -122.473628955238 (37.7787405344574, -122.473628955238) 11 6 2 54 26
122608 219051 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2642 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5991454.81179 2097430.44339 37.7386530359974 -122.472086252978 (37.7386530359974, -122.472086252978) 1 8 4 29491 40
119817 219020 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1418 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5991492.50726 2105759.2792 37.7615240358153 -122.472562984513 (37.7615240358153, -122.472562984513) 1 8 4 56 12
153104 219019 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1418 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5991493.85585 2105743.6549 37.7614812136945 -122.472557181186 (37.7614812136945, -122.472557181186) 1 8 4 56 12
166633 51261 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 483 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/2004 12:00:00 AM 2   Permit Number 47638 5991555.86746 2112145.30882 37.779062018233 -122.472809509339 (37.779062018233, -122.472809509339) 11 6 2 54 26
81819 251309 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2111 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991606.08126 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742) 1 8 4 29491 40
191827 219050 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2226 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5991760.48852 2100259.76764 37.746439321329 -122.471235460155 (37.746439321329, -122.471235460155) 1 8 4 29491 40
15540 124027 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 201 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   5991798.47727 2113998.77869 37.7841651786362 -122.47210536759 (37.7841651786362, -122.47210536759) 11 6 2 54 11
1566 124023 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 301 Funston Ave 3 Sidewalk: Curb side : Yard Tree Private 2     16 Width 3ft   5991830.31416 2113050.03169 37.781562022994 -122.471926053077 (37.781562022994, -122.471926053077) 11 6 2 54 11
157728 68699 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 162 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM     Permit Number 772824 5991833.16910244 2114366.69190669 37.7851773741741 -122.472012172388 (37.7851773741741, -122.472012172388) 11 6 2 54 11
186635 68700 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 168 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM 4   Permit Number 32612 5991833.50014 2114340.31773 37.7851049771354 -122.472009104115 (37.7851049771354, -122.472009104115) 11 6 2 54 11
17856 68790 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2339 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1993 12:00:00 AM     Permit Number 32727 5991985.43941061 2099518.6478439 37.744417405952 -122.470403648157 (37.744417405952, -122.470403648157) 1 8 4 29491 40
67347 60847 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 2345 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1993 12:00:00 AM     Permit Number 32728 5991986.7837073 2099479.42782761 37.7443097955565 -122.470396144192 (37.7443097955565, -122.470396144192) 1 8 4 29491 40
58294 219100 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2339 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991987.82564 2099493.58724 37.744348733921 -122.470393572423 (37.744348733921, -122.470393572423) 1 8 4 29491 40
135467 219101 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2345 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991990.11619 2099461.86688 37.744261770371 -122.470383342635 (37.744261770371, -122.470383342635) 1 8 4 29491 40
90803 219057 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 2043 Monterey Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5992040.14931 2095397.21608 37.7331041614161 -122.469914455893 (37.7331041614161, -122.469914455893) 9 8 4 59 40
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
66917 104418 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1125 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2013 12:00:00 AM     Permit Number 770463 5992112 2110623.1 37.7749146251824 -122.47077473048 (37.7749146251824, -122.47077473048) 11 6 2 54 11
103669 219021 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1346 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992113.21789 2106275.98534 37.7629786829377 -122.470453853963 (37.7629786829377, -122.470453853963) 1 8 11 56 12
61826 67724 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 1346 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1992 12:00:00 AM     Permit Number 31342 5992116.05706304 2106274.73338322 37.7629754095582 -122.470443943147 (37.7629754095582, -122.470443943147) 1 8 11 56 12
27585 47159 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 200 San Fernando Way 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52542 5992116.68521556 2095408.98560737 37.7331409014555 -122.469650709796 (37.7331409014555, -122.469650709796) 9 8 4 59 40
147874 47160 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 200 San Fernando Way 2 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52542 5992116.68521556 2095408.98560737 37.7331409014555 -122.469650709796 (37.7331409014555, -122.469650709796) 9 8 4 59 40
189451 67448 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1125 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/02/2013 12:00:00 AM 1   Permit Number 770463 5992116.86908 2110647.4153 37.7749816699887 -122.470759658967 (37.7749816699887, -122.470759658967) 11 6 2 54 11
137237 123780 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 1101 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   5992128.66987 2110647.16676 37.7749816699912 -122.470718819766 (37.7749816699912, -122.470718819766) 11 6 2 54 11
117852 43667 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 335 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM 3   Permit Number 43310 5992137.1928 2113155.35284 37.7818689583158 -122.470872084018 (37.7818689583158, -122.470872084018) 11 6 2 54 11
170606 68689 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 162 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM 4   Permit Number 32599 5992138.9687 2114381.7472 37.7852364025335 -122.47095530753 (37.7852364025335, -122.47095530753) 11 6 2 54 11

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);