trees
858 rows where qSpecies_id = 85 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
48698 | 108284 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
91178 | 245305 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002140.10278 | 2096079.88738 | 37.7355572745451 | -122.435045080864 | (37.7355572745451, -122.435045080864) | 2 | 7 | 5 | 63 | 7 | |||
102191 | 245306 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1 Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002154.22585 | 2096093.86351 | 37.735596451704 | -122.434997251342 | (37.735596451704, -122.434997251342) | 2 | 7 | 5 | 63 | 7 | |||
42937 | 136556 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Cedar St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006852.77873 | 2114483.71843 | 37.7863563769807 | -122.420057179305 | (37.7863563769807, -122.420057179305) | 13 | 9 | 10 | 28858 | 36 | |||
53928 | 136555 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Cedar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006874.57787 | 2114487.03447 | 37.7863667101899 | -122.419981995093 | (37.7863667101899, -122.419981995093) | 13 | 9 | 10 | 28858 | 36 | |||
78069 | 245349 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004386.74931 | 2101635.76059 | 37.7509397410815 | -122.427673286801 | (37.7509397410815, -122.427673286801) | 2 | 4 | 5 | 28862 | 22 | |||
130790 | 245348 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004415.63351 | 2101637.39277 | 37.7509458564757 | -122.4275735187 | (37.7509458564757, -122.4275735187) | 2 | 4 | 5 | 28862 | 22 | |||
104684 | 245284 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006163.63049 | 2102542.62363 | 37.7535301285288 | -122.421593052282 | (37.7535301285288, -122.421593052282) | 2 | 4 | 5 | 28859 | 19 | |||
126882 | 117576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 100 Waverly Pl | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 3x3 | 6010746.80079 | 2117296.55701 | 37.7942983844173 | -122.406783100465 | (37.7942983844173, -122.406783100465) | 3 | 1 | 10 | 28857 | 4 | |||
1496 | 103826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006957.18445 | 2114384.03926 | 37.7860885642674 | -122.419688886254 | (37.7860885642674, -122.419688886254) | 13 | 9 | 9 | 28858 | 36 | ||
62198 | 142865 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006959.584 | 2114368.3394 | 37.7860455914687 | -122.419679470083 | (37.7860455914687, -122.419679470083) | 13 | 9 | 9 | 28858 | 36 | |||
179335 | 103827 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006958.82902 | 2114372.08795 | 37.7860558415396 | -122.419682348183 | (37.7860558415396, -122.419682348183) | 13 | 9 | 9 | 28858 | 36 | ||
72707 | 20138 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002950.7346 | 2111726.0933 | 37.7785640114636 | -122.433360117142 | (37.7785640114636, -122.433360117142) | 15 | 9 | 11 | 29490 | 41 | |||
107026 | 20139 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002949.1674 | 2111752.2131 | 37.7786356410017 | -122.433367405651 | (37.7786356410017, -122.433367405651) | 15 | 9 | 11 | 29490 | 41 | |||
142344 | 20140 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1000 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | Permit Number 770990 | 6002946.5554 | 2111769.9745 | 37.7786842611853 | -122.433377711101 | (37.7786842611853, -122.433377711101) | 15 | 9 | 11 | 29490 | 41 | ||
61453 | 142883 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 POLK ST | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006904.8517 | 2114389.9348 | 37.7861018038827 | -122.419870362438 | (37.7861018038827, -122.419870362438) | 13 | 9 | 9 | 28858 | 36 | |||
124615 | 142884 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 POLK ST | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 0ft | 6006908.0601 | 2114365.4705 | 37.7860348116628 | -122.419857525608 | (37.7860348116628, -122.419857525608) | 13 | 9 | 9 | 28858 | 36 | |||
53402 | 113232 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | 3x3 | 6006901.77113 | 2114384.86271 | 37.7860877036192 | -122.419880660363 | (37.7860877036192, -122.419880660363) | 13 | 9 | 9 | 28858 | 36 | |||
125797 | 113233 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1001 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 3x3 | 6006902.65077 | 2114366.34076 | 37.7860368964425 | -122.419876302244 | (37.7860368964425, -122.419876302244) | 13 | 9 | 9 | 28858 | 36 | |||
44241 | 245344 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1005 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 16 | Width 3ft | Permit Number 45840 | 6003175.28861 | 2102361.95423 | 37.7528650960514 | -122.431914479684 | (37.7528650960514, -122.431914479684) | 2 | 4 | 5 | 28862 | 22 | |
984 | 20145 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1006 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002942.8987 | 2111794.0047 | 37.7787500346576 | -122.433392078669 | (37.7787500346576, -122.433392078669) | 15 | 9 | 11 | 29490 | 41 | |||
107560 | 20146 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1006 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002941.3315 | 2111813.3334 | 37.7788030175273 | -122.433398881809 | (37.7788030175273, -122.433398881809) | 15 | 9 | 11 | 29490 | 41 | |||
105497 | 245322 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 101 Santa Marina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006225.9261 | 2097560.7974 | 37.7398546777457 | -122.421023925339 | (37.7398546777457, -122.421023925339) | 2 | 7 | 7 | 28859 | 2 | |||
53922 | 215171 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 101 Stanford Heights Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997803.80598 | 2096370.84816 | 37.7361090059307 | -122.450058203043 | (37.7361090059307, -122.450058203043) | 9 | 7 | 4 | 59 | 40 | |||
191224 | 142866 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1010 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006958.8566 | 2114380.7051 | 37.7860795036749 | -122.419682864396 | (37.7860795036749, -122.419682864396) | 13 | 9 | 9 | 28858 | 36 | |||
96742 | 58378 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1020 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2013 12:00:00 AM | 4 | Permit Number 769968 | 6011874.40937 | 2103617.93894 | 37.7568030681131 | -122.401919409461 | (37.7568030681131, -122.401919409461) | 10 | 3 | 8 | 28856 | 29 | ||
24859 | 103822 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1030 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.7 | 2114566.7 | 37.7865897969129 | -122.419720826278 | (37.7865897969129, -122.419720826278) | 13 | 9 | 9 | 28858 | 36 | ||
20367 | 52364 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1030@ CEDAR Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 8 | Permit Number 48499 | 6006935.64598 | 2114546.93824 | 37.7865346316038 | -122.419774966644 | (37.7865346316038, -122.419774966644) | 13 | 9 | 9 | 28858 | 36 | |
79374 | 52363 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1030@ CEDAR Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 11 | Permit Number 48499 | 6006937.73357 | 2114525.88261 | 37.7864769356114 | -122.41976624951 | (37.7864769356114, -122.41976624951) | 13 | 9 | 9 | 28858 | 36 | |
52289 | 103821 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1032 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006936.4893 | 2114526.0013 | 37.7864771914113 | -122.419770562808 | (37.7864771914113, -122.419770562808) | 13 | 9 | 9 | 28858 | 36 | ||
12364 | 142864 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6006888.1179 | 2114511.0898 | 37.7864335230518 | -122.419936857586 | (37.7864335230518, -122.419936857586) | 13 | 9 | 10 | 28858 | 36 | |||
27265 | 45778 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2001 12:00:00 AM | 14 | Permit Number 44419 | 6006891.87332 | 2114501.10639 | 37.7864063226311 | -122.41992315605 | (37.7864063226311, -122.41992315605) | 13 | 9 | 10 | 28858 | 36 | ||
54708 | 45779 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2005 12:00:00 AM | 13 | Permit Number 48205 | 6006884.42122 | 2114521.64488 | 37.7864622964456 | -122.419950396487 | (37.7864622964456, -122.419950396487) | 13 | 9 | 10 | 28858 | 36 | |
125303 | 45777 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2001 12:00:00 AM | Permit Number 44419 | 6006888.64433858 | 2114502.25167433 | 37.7864092853866 | -122.419934408834 | (37.7864092853866, -122.419934408834) | 13 | 9 | 10 | 28858 | 36 | |||
149675 | 103820 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006885.572 | 2114524.1828 | 37.7864693297842 | -122.419946595232 | (37.7864693297842, -122.419946595232) | 13 | 9 | 10 | 28858 | 36 | ||
29214 | 142860 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1034 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006934.3072 | 2114548.914 | 37.7865399811377 | -122.419779738746 | (37.7865399811377, -122.419779738746) | 13 | 9 | 9 | 28858 | 36 | |||
33656 | 179619 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 104 Burrows St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | 6011168.71552 | 2093496.29206 | 37.7289717927968 | -122.4036478336 | (37.7289717927968, -122.4036478336) | 10 | 3 | 7 | 309 | 28 | ||||
154017 | 179618 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 104 Burrows St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6011168.50385 | 2093508.14959 | 37.7290043392774 | -122.403649399324 | (37.7290043392774, -122.403649399324) | 10 | 3 | 7 | 309 | 28 | ||||
11346 | 261371 | Planning Code 138.1 required 2 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007217 | 2095358 | 37.7338620991787 | -122.417441127318 | (37.7338620991787, -122.417441127318) | 2 | 7 | 7 | 28859 | 2 | ||||
126409 | 179617 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 105 Burrows St | 3 | Side Yard : Yard | Tree | Private 2 | 4 | 6011176.00009 | 2093481.48046 | 37.7289315301509 | -122.403621608451 | (37.7289315301509, -122.403621608451) | 10 | 3 | 7 | 309 | 28 | ||||
152296 | 245256 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1069 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004447.76038 | 2102694.38274 | 37.7538499211567 | -122.427537715797 | (37.7538499211567, -122.427537715797) | 2 | 4 | 5 | 28862 | 22 | |||
119337 | 240854 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1072 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010485.0248 | 2102978.73078 | 37.7549703055524 | -122.40667939245 | (37.7549703055524, -122.40667939245) | 10 | 4 | 7 | 28859 | 19 | |||
108934 | 104726 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1079 Church St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770313 | 6004474.7 | 2102638.1 | 37.7536969056436 | -122.427440543051 | (37.7536969056436, -122.427440543051) | 2 | 4 | 5 | 28862 | 22 | ||||
37580 | 245253 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1090 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010233.17575 | 2102878.70236 | 37.7546815557325 | -122.40754330998 | (37.7546815557325, -122.40754330998) | 2 | 4 | 7 | 28859 | 19 | |||
158392 | 245252 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1090 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010233.59348 | 2102899.19356 | 37.7547378433872 | -122.407543309979 | (37.7547378433872, -122.407543309979) | 2 | 4 | 7 | 28859 | 19 | |||
39651 | 142885 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1100 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006912.0707 | 2114700.1497 | 37.7869539845455 | -122.419867407304 | (37.7869539845455, -122.419867407304) | 13 | 9 | 10 | 28858 | 21 | |||
92078 | 103819 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.7870957589339 | -122.41982320605 | (37.7870957589339, -122.41982320605) | 13 | 9 | 10 | 28858 | 21 | ||
143520 | 103818 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1100 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006909.68769 | 2114740.53907 | 37.787064749582 | -122.4198785191 | (37.787064749582, -122.4198785191) | 13 | 9 | 10 | 28858 | 21 | ||
189481 | 31963 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 10 | Permit Number 35365 | 6006912.23136 | 2114707.29251 | 37.786973605998 | -122.419867358497 | (37.786973605998, -122.419867358497) | 13 | 9 | 10 | 28858 | 21 | |
126050 | 142893 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6006863.4429 | 2114692.0283 | 37.7869289455534 | -122.420035072225 | (37.7869289455534, -122.420035072225) | 13 | 9 | 10 | 28858 | 21 | |||
135628 | 103812 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.420150214034 | (37.787052526526, -122.420150214034) | 13 | 9 | 10 | 28858 | 21 | ||
168233 | 103813 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1101 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.420150214034 | (37.787052526526, -122.420150214034) | 13 | 9 | 10 | 28858 | 21 | ||
104595 | 50002 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014257.86563 | 2105244.06654 | 37.7614007945303 | -122.393790293612 | (37.7614007945303, -122.393790293612) | 10 | 3 | 8 | 28856 | 29 |
108105 | 49999 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014232.027 | 2105242.25356 | 37.7613943805613 | -122.393879532433 | (37.7613943805613, -122.393879532433) | 10 | 3 | 8 | 28856 | 29 |
137182 | 50003 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1101X 19th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 11 | 0 | Permit Number 46740 | 6014266.61344 | 2105244.3143 | 37.7614019609488 | -122.393760055695 | (37.7614019609488, -122.393760055695) | 10 | 3 | 8 | 28856 | 29 |
139234 | 142892 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1107 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6006862.6408 | 2114709.6747 | 37.7869773530396 | -122.420039100076 | (37.7869773530396, -122.420039100076) | 13 | 9 | 10 | 28858 | 21 | |||
88693 | 142886 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1116 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6006907.1209 | 2114732.1255 | 37.787041503382 | -122.419886802387 | (37.787041503382, -122.419886802387) | 13 | 9 | 10 | 28858 | 21 | |||
161990 | 65601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 112 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 12 | Permit Number 28503 | 6004142.9253 | 2093740.45732 | 37.7292472461511 | -122.427953908572 | (37.7292472461511, -122.427953908572) | 9 | 7 | 6 | 28861 | 5 | |
27985 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 6007603.98274 | 2103104.14442 | 37.7551530486792 | -122.416651764192 | (37.7551530486792, -122.416651764192) | 2 | 4 | 7 | 28859 | 19 | ||||
43628 | 136547 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1127 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006861.97682 | 2114694.93906 | 37.7869368551843 | -122.42004035118 | (37.7869368551843, -122.42004035118) | 13 | 9 | 10 | 28858 | 21 | |||
112563 | 136545 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1127 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6006847.68823 | 2114784.64257 | 37.7871823539217 | -122.420096155013 | (37.7871823539217, -122.420096155013) | 13 | 9 | 10 | 28858 | 21 | |||
181870 | 136546 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1127 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006858.02887 | 2114712.15261 | 37.7869838969287 | -122.420055232258 | (37.7869838969287, -122.420055232258) | 13 | 9 | 10 | 28858 | 21 | |||
35207 | 245324 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1139 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009488.18332 | 2102546.37168 | 37.7537273210842 | -122.410096245168 | (37.7537273210842, -122.410096245168) | 2 | 4 | 7 | 28859 | 19 | |||
82759 | 35347 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1141 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2014 12:00:00 AM | 10 | Permit Number 773064 | 6012246.4084 | 2103087.65437 | 37.7553677771151 | -122.400595641589 | (37.7553677771151, -122.400595641589) | 10 | 3 | 8 | 28856 | 29 | |
62041 | 245323 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1145 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009489.63091 | 2102518.12221 | 37.7536498354966 | -122.410089244835 | (37.7536498354966, -122.410089244835) | 2 | 4 | 7 | 28859 | 19 | |||
133879 | 103807 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1145 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
158761 | 103808 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1145 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
66206 | 215177 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 115 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5998455.14668 | 2097038.32931 | 37.7379789995273 | -122.44785430284 | (37.7379789995273, -122.44785430284) | 9 | 7 | 4 | 59 | 40 | |||
69487 | 215176 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 115 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998441.46818 | 2097042.42128 | 37.7379894532555 | -122.447901890481 | (37.7379894532555, -122.447901890481) | 9 | 7 | 4 | 59 | 40 | |||
47458 | 113229 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1150 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | 13 | 9 | 10 | 28858 | 21 | ||||
175585 | 113230 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1150 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | 13 | 9 | 10 | 28858 | 21 | ||||
17041 | 197764 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 9 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015565.1078 | 2103547.12613 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | 10 | 3 | 8 | 28856 | 29 | |||
36252 | 197767 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 14 | Median : Yard | Tree | DPW 1 | 14 | Width 8ft | 6015569.44669 | 2103464.91746 | 37.756588430534 | -122.38912981161 | (37.756588430534, -122.38912981161) | 10 | 3 | 8 | 28856 | 29 | |||
52850 | 197768 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 15 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | 10 | 3 | 8 | 28856 | 29 | |||
137880 | 197765 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 11 | Median : Yard | Tree | DPW 1 | 12 | Width 8ft | 6015567.05153 | 2103517.02147 | 37.756731364291 | -122.389141732999 | (37.756731364291, -122.389141732999) | 10 | 3 | 8 | 28856 | 29 | |||
184695 | 197766 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1150x Tennessee St | 13 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6015570.19786 | 2103483.29331 | 37.756638928352 | -122.389128496797 | (37.756638928352, -122.389128496797) | 10 | 3 | 8 | 28856 | 29 | |||
62992 | 103798 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1157 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
136272 | 103799 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1157 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
32439 | 136549 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1160 Polk St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6006876.35083 | 2114950.02533 | 37.7876380691922 | -122.420008729221 | (37.7876380691922, -122.420008729221) | 13 | 9 | 10 | 28858 | 21 | |||
188944 | 136548 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1160 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6006881.24187 | 2114926.36789 | 37.7875733872447 | -122.419990127669 | (37.7875733872447, -122.419990127669) | 13 | 9 | 10 | 28858 | 21 | |||
132411 | 142874 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1168 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006878.7832 | 2114929.3518 | 37.7875814418062 | -122.419998846029 | (37.7875814418062, -122.419998846029) | 13 | 9 | 10 | 28858 | 21 | |||
81410 | 136544 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1177 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6006828.33355 | 2114915.67486 | 37.7875410458324 | -122.42017242114 | (37.7875410458324, -122.42017242114) | 13 | 9 | 10 | 28858 | 21 | |||
179146 | 136543 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1177 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 6006827.65402 | 2114934.96307 | 37.7875939682209 | -122.420176141611 | (37.7875939682209, -122.420176141611) | 13 | 9 | 10 | 28858 | 21 | |||
25066 | 142875 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1178 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 6006878.3822 | 2114950.2065 | 37.7876386810883 | -122.420001713925 | (37.7876386810883, -122.420001713925) | 13 | 9 | 10 | 28858 | 21 | |||
184913 | 142877 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1187 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 0ft | 6006832.261 | 2114920.1275 | 37.7875534929777 | -122.420159149048 | (37.7875534929777, -122.420159149048) | 13 | 9 | 10 | 28858 | 21 | |||
121775 | 142876 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1197 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 6006828.381 | 2114947.7967 | 37.7876292471714 | -122.420174537563 | (37.7876292471714, -122.420174537563) | 13 | 9 | 10 | 28858 | 21 | |||
72361 | 215174 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998431.33624 | 2097088.3182 | 37.7381148960726 | -122.447940224956 | (37.7381148960726, -122.447940224956) | 9 | 7 | 4 | 59 | 40 | |||
119740 | 215173 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 5998452.61028 | 2097081.78391 | 37.7380981704837 | -122.447866199984 | (37.7380981704837, -122.447866199984) | 9 | 7 | 4 | 59 | 40 | |||
163572 | 215175 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998426.00188 | 2097089.19076 | 37.7381169869985 | -122.447958731229 | (37.7381169869985, -122.447958731229) | 9 | 7 | 4 | 59 | 40 | |||
25892 | 136559 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1200 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009435.38581 | 2117472.07438 | 37.794706848389 | -122.411333170001 | (37.794706848389, -122.411333170001) | 3 | 1 | 10 | 28857 | 4 | |||
164347 | 103797 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1201 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006813.15784 | 2115040.73173 | 37.7878835661122 | -122.420233805246 | (37.7878835661122, -122.420233805246) | 13 | 9 | 10 | 28858 | 21 | ||
185983 | 103796 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1201 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006810.24067 | 2115055.78241 | 37.7879247271976 | -122.420244966752 | (37.7879247271976, -122.420244966752) | 13 | 9 | 10 | 28858 | 21 | ||
59868 | 184889 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1201 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984679.4382 | 2106701.786 | 37.7637151826251 | -122.496195774698 | (37.7637151826251, -122.496195774698) | 1 | 8 | 3 | 56 | 35 | |||
115412 | 45711 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1202X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066 | 2116562 | 37.7921311104068 | -122.416006962529 | (37.7921311104068, -122.416006962529) | 5 | 1 | 10 | 28858 | 21 | |
182993 | 45710 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1202X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066 | 2116562 | 37.7921311104068 | -122.416006962529 | (37.7921311104068, -122.416006962529) | 5 | 1 | 10 | 28858 | 21 | |
59220 | 142862 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1203 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6006813.0104 | 2115061.2984 | 37.7879400288134 | -122.420235775611 | (37.7879400288134, -122.420235775611) | 13 | 9 | 10 | 28858 | 21 | |||
108875 | 142863 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1203 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6006816.2189 | 2115040.4436 | 37.787882947459 | -122.420223194063 | (37.787882947459, -122.420223194063) | 13 | 9 | 10 | 28858 | 21 | |||
59554 | 136565 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1218 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007807.75264 | 2118217.01551 | 37.7966608503694 | -122.41701782152 | (37.7966608503694, -122.41701782152) | 5 | 1 | 10 | 28858 | 32 | |||
137724 | 136566 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1218 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6007796.91649 | 2118215.26217 | 37.796655426568 | -122.41705519284 | (37.796655426568, -122.41705519284) | 5 | 1 | 10 | 28858 | 32 | |||
42424 | 197761 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Harrison St | 7 | : | Tree | Private 2 | 7 | Width 3ft | 6010003.68567 | 2109694.36237 | 37.773382957679 | -122.408817777045 | (37.773382957679, -122.408817777045) | 14 | 2 | 9 | 28853 | 34 |
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) );