Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84119 | 84119 | 108284 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 57671 | 57671 | 245306 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1 Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002154.22585 | 2096093.8635099998 | 37.735596451704 | -122.434997251342 | (37.735596451704, -122.434997251342) | |||
| 168511 | 168511 | 245305 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002140.10278 | 2096079.88738 | 37.7355572745451 | -122.43504508086399 | (37.7355572745451, -122.435045080864) | |||
| 167427 | 167427 | 136556 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Cedar St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006852.77873 | 2114483.71843 | 37.786356376980706 | -122.420057179305 | (37.7863563769807, -122.420057179305) | |||
| 176603 | 176603 | 136555 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Cedar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006874.57787 | 2114487.0344700003 | 37.7863667101899 | -122.419981995093 | (37.7863667101899, -122.419981995093) | |||
| 61628 | 61628 | 245348 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004415.63351 | 2101637.3927700003 | 37.7509458564757 | -122.42757351870002 | (37.7509458564757, -122.4275735187) | |||
| 170157 | 170157 | 245349 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004386.74931 | 2101635.76059 | 37.7509397410815 | -122.427673286801 | (37.7509397410815, -122.427673286801) | |||
| 136048 | 136048 | 245284 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006163.63049 | 2102542.62363 | 37.753530128528794 | -122.421593052282 | (37.7535301285288, -122.421593052282) | |||
| 73092 | 73092 | 117576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Waverly Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6010746.80079 | 2117296.5570099996 | 37.794298384417296 | -122.40678310046499 | (37.7942983844173, -122.406783100465) | |||
| 4713 | 4713 | 103826 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006957.18445 | 2114384.03926 | 37.786088564267395 | -122.41968888625401 | (37.7860885642674, -122.419688886254) | ||
| 6945 | 6945 | 103827 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006958.82902 | 2114372.08795 | 37.7860558415396 | -122.419682348183 | (37.7860558415396, -122.419682348183) | ||
| 135107 | 135107 | 142865 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6006959.584 | 2114368.3394 | 37.7860455914687 | -122.41967947008301 | (37.7860455914687, -122.419679470083) | |||
| 6353 | 6353 | 20138 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002950.7346 | 2111726.0933 | 37.7785640114636 | -122.43336011714199 | (37.7785640114636, -122.433360117142) | |||
| 7183 | 7183 | 20140 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | Permit Number 770990 | 6002946.5554 | 2111769.9745 | 37.7786842611853 | -122.433377711101 | (37.7786842611853, -122.433377711101) | ||
| 7593 | 7593 | 20139 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1000 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002949.1674 | 2111752.2131 | 37.7786356410017 | -122.433367405651 | (37.7786356410017, -122.433367405651) | |||
| 66560 | 66560 | 142884 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006908.0601 | 2114365.4705 | 37.786034811662795 | -122.41985752560801 | (37.7860348116628, -122.419857525608) | |||
| 156999 | 156999 | 142883 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006904.8517 | 2114389.9348 | 37.7861018038827 | -122.41987036243799 | (37.7861018038827, -122.419870362438) | |||
| 37006 | 37006 | 113232 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6006901.77113 | 2114384.86271 | 37.7860877036192 | -122.419880660363 | (37.7860877036192, -122.419880660363) | |||
| 148838 | 148838 | 113233 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 3x3 | 6006902.650769999 | 2114366.34076 | 37.786036896442496 | -122.41987630224399 | (37.7860368964425, -122.419876302244) | |||
| 3088 | 3088 | 245344 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1005 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 16 | Width 3ft | Permit Number 45840 | 6003175.28861 | 2102361.95423 | 37.752865096051394 | -122.431914479684 | (37.7528650960514, -122.431914479684) | |
| 6554 | 6554 | 20146 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1006 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002941.3315 | 2111813.3334 | 37.7788030175273 | -122.43339888180901 | (37.7788030175273, -122.433398881809) | |||
| 8779 | 8779 | 20145 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1006 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002942.8987 | 2111794.0047 | 37.778750034657605 | -122.433392078669 | (37.7787500346576, -122.433392078669) | |||
| 163321 | 163321 | 245322 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 101 Santa Marina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006225.9261 | 2097560.7974 | 37.739854677745704 | -122.421023925339 | (37.7398546777457, -122.421023925339) | |||
| 74173 | 74173 | 215171 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 101 Stanford Heights Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997803.805980001 | 2096370.8481599998 | 37.73610900593071 | -122.450058203043 | (37.7361090059307, -122.450058203043) | |||
| 26971 | 26971 | 142866 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1010 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006958.8566 | 2114380.7051 | 37.7860795036749 | -122.419682864396 | (37.7860795036749, -122.419682864396) | |||
| 148580 | 148580 | 58378 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1020 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2013 12:00:00 AM | 4 | Permit Number 769968 | 6011874.40937 | 2103617.9389400003 | 37.7568030681131 | -122.401919409461 | (37.7568030681131, -122.401919409461) | ||
| 125049 | 125049 | 103822 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1030 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006951.7 | 2114566.7 | 37.7865897969129 | -122.419720826278 | (37.7865897969129, -122.419720826278) | ||
| 54016 | 54016 | 52363 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1030@ CEDAR Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 11 | Permit Number 48499 | 6006937.73357 | 2114525.8826099997 | 37.786476935611404 | -122.41976624951 | (37.7864769356114, -122.41976624951) | |
| 68460 | 68460 | 52364 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1030@ CEDAR Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 8 | Permit Number 48499 | 6006935.6459800005 | 2114546.93824 | 37.7865346316038 | -122.419774966644 | (37.7865346316038, -122.419774966644) | |
| 2322 | 2322 | 103821 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1032 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006936.4893 | 2114526.0013 | 37.786477191411294 | -122.419770562808 | (37.7864771914113, -122.419770562808) | ||
| 52476 | 52476 | 142864 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6006888.1179 | 2114511.0898 | 37.7864335230518 | -122.41993685758601 | (37.7864335230518, -122.419936857586) | |||
| 7733 | 7733 | 103820 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006885.572000001 | 2114524.1828 | 37.786469329784204 | -122.41994659523199 | (37.7864693297842, -122.419946595232) | ||
| 56545 | 56545 | 45779 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2005 12:00:00 AM | 13 | Permit Number 48205 | 6006884.42122 | 2114521.64488 | 37.786462296445606 | -122.41995039648701 | (37.7864622964456, -122.419950396487) | |
| 108265 | 108265 | 45777 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | Permit Number 44419 | 6006888.64433858 | 2114502.25167433 | 37.786409285386604 | -122.419934408834 | (37.7864092853866, -122.419934408834) | |||
| 155405 | 155405 | 45778 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1033 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2001 12:00:00 AM | 14 | Permit Number 44419 | 6006891.873319999 | 2114501.1063900003 | 37.7864063226311 | -122.41992315604999 | (37.7864063226311, -122.41992315605) | ||
| 39482 | 39482 | 142860 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1034 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006934.3072 | 2114548.914 | 37.78653998113771 | -122.419779738746 | (37.7865399811377, -122.419779738746) | |||
| 31566 | 31566 | 179618 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 104 Burrows St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011168.50385 | 2093508.14959 | 37.729004339277395 | -122.403649399324 | (37.7290043392774, -122.403649399324) | ||||
| 165025 | 165025 | 179619 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 104 Burrows St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011168.71552 | 2093496.29206 | 37.7289717927968 | -122.4036478336 | (37.7289717927968, -122.4036478336) | ||||
| 132985 | 132985 | 179617 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 105 Burrows St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011176.00009 | 2093481.4804599998 | 37.7289315301509 | -122.403621608451 | (37.7289315301509, -122.403621608451) | ||||
| 54026 | 54026 | 245256 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1069 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004447.76038 | 2102694.3827400003 | 37.7538499211567 | -122.427537715797 | (37.7538499211567, -122.427537715797) | |||
| 61397 | 61397 | 240854 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1072 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010485.0248 | 2102978.73078 | 37.7549703055524 | -122.40667939245 | (37.7549703055524, -122.40667939245) | |||
| 98681 | 98681 | 104726 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1079 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770313 | 6004474.7 | 2102638.1 | 37.7536969056436 | -122.42744054305099 | (37.7536969056436, -122.427440543051) | ||||
| 34314 | 34314 | 245253 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1090 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010233.17575 | 2102878.70236 | 37.754681555732496 | -122.40754330998001 | (37.7546815557325, -122.40754330998) | |||
| 179707 | 179707 | 245252 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1090 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010233.59348 | 2102899.19356 | 37.754737843387204 | -122.407543309979 | (37.7547378433872, -122.407543309979) | |||
| 153432 | 153432 | 142885 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6006912.0707 | 2114700.1497 | 37.7869539845455 | -122.419867407304 | (37.7869539845455, -122.419867407304) | |||
| 6969 | 6969 | 103818 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006909.68769 | 2114740.53907 | 37.787064749582 | -122.4198785191 | (37.787064749582, -122.4198785191) | ||
| 36321 | 36321 | 31963 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35365 | 6006912.23136 | 2114707.29251 | 37.786973605998 | -122.41986735849702 | (37.786973605998, -122.419867358497) | |
| 96602 | 96602 | 103819 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1100 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006925.9 | 2114751.5 | 37.787095758933894 | -122.41982320605 | (37.7870957589339, -122.41982320605) | ||
| 129077 | 129077 | 142893 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1101 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006863.4429 | 2114692.0283 | 37.7869289455534 | -122.420035072225 | (37.7869289455534, -122.420035072225) | |||
| 110547 | 110547 | 103812 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.42015021403401 | (37.787052526526, -122.420150214034) | ||
| 118049 | 118049 | 103813 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006831.1 | 2114737.7 | 37.787052526526 | -122.42015021403401 | (37.787052526526, -122.420150214034) | ||
| 13435 | 13435 | 50002 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101X 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014257.86563 | 2105244.06654 | 37.761400794530296 | -122.393790293612 | (37.7614007945303, -122.393790293612) |
| 14509 | 14509 | 49999 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101X 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46740 | 6014232.027000001 | 2105242.2535599996 | 37.76139438056129 | -122.39387953243299 | (37.7613943805613, -122.393879532433) |
| 23126 | 23126 | 50003 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1101X 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 11 | 0 | Permit Number 46740 | 6014266.61344 | 2105244.3143 | 37.761401960948795 | -122.393760055695 | (37.7614019609488, -122.393760055695) |
| 38766 | 38766 | 142892 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1107 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006862.6408 | 2114709.6747 | 37.7869773530396 | -122.42003910007601 | (37.7869773530396, -122.420039100076) | |||
| 64475 | 64475 | 142886 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1116 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6006907.1209 | 2114732.1255 | 37.787041503382 | -122.41988680238701 | (37.787041503382, -122.419886802387) | |||
| 182671 | 182671 | 65601 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 112 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 12 | Permit Number 28503 | 6004142.9253 | 2093740.45732 | 37.7292472461511 | -122.42795390857201 | (37.7292472461511, -122.427953908572) | |
| 4182 | 4182 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 142 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Width 3ft | 6007603.98274 | 2103104.1444200003 | 37.755153048679205 | -122.41665176419201 | (37.7551530486792, -122.416651764192) | ||||
| 72785 | 72785 | 136545 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1127 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006847.68823 | 2114784.64257 | 37.78718235392171 | -122.42009615501301 | (37.7871823539217, -122.420096155013) | |||
| 133124 | 133124 | 136547 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1127 Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006861.9768199995 | 2114694.93906 | 37.7869368551843 | -122.42004035118 | (37.7869368551843, -122.42004035118) | |||
| 158038 | 158038 | 136546 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1127 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006858.02887 | 2114712.1526099998 | 37.7869838969287 | -122.420055232258 | (37.7869838969287, -122.420055232258) | |||
| 76241 | 76241 | 245324 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1139 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009488.18332 | 2102546.37168 | 37.753727321084206 | -122.410096245168 | (37.7537273210842, -122.410096245168) | |||
| 64975 | 64975 | 35347 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1141 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2014 12:00:00 AM | 10 | Permit Number 773064 | 6012246.4084 | 2103087.65437 | 37.755367777115104 | -122.40059564158899 | (37.7553677771151, -122.400595641589) | |
| 157550 | 157550 | 245323 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1145 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009489.63091 | 2102518.1222099997 | 37.7536498354966 | -122.41008924483499 | (37.7536498354966, -122.410089244835) | |||
| 113799 | 113799 | 103807 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1145 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.42020072617599 | (37.7874934070669, -122.420200726176) | ||
| 120477 | 120477 | 103808 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1145 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.42020072617599 | (37.7874934070669, -122.420200726176) | ||
| 70675 | 70675 | 215176 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 115 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998441.46818 | 2097042.42128 | 37.7379894532555 | -122.44790189048099 | (37.7379894532555, -122.447901890481) | |||
| 130750 | 130750 | 215177 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 115 Bella Vista Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5998455.14668 | 2097038.32931 | 37.7379789995273 | -122.44785430283999 | (37.7379789995273, -122.44785430284) | |||
| 84192 | 84192 | 113229 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 138787 | 138787 | 113230 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 27523 | 27523 | 197764 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015565.1078 | 2103547.1261299998 | 37.7568139175333 | -122.389150557161 | (37.7568139175333, -122.389150557161) | |||
| 29638 | 29638 | 197767 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6015569.446690001 | 2103464.9174599997 | 37.756588430534 | -122.38912981161002 | (37.756588430534, -122.38912981161) | |||
| 49253 | 49253 | 197768 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6015570.7208 | 2103442.3208 | 37.7565264555391 | -122.389123827518 | (37.7565264555391, -122.389123827518) | |||
| 162901 | 162901 | 197765 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 8ft | 6015567.051530001 | 2103517.02147 | 37.756731364291 | -122.389141732999 | (37.756731364291, -122.389141732999) | |||
| 178786 | 178786 | 197766 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6015570.19786 | 2103483.2933099996 | 37.756638928352 | -122.38912849679701 | (37.756638928352, -122.389128496797) | |||
| 85533 | 85533 | 103798 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1157 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.787518325661296 | -122.42006782447201 | (37.7875183256613, -122.420067824472) | ||
| 115173 | 115173 | 103799 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1157 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.787518325661296 | -122.42006782447201 | (37.7875183256613, -122.420067824472) | ||
| 156434 | 156434 | 136548 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1160 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6006881.24187 | 2114926.3678900003 | 37.7875733872447 | -122.419990127669 | (37.7875733872447, -122.419990127669) | |||
| 163984 | 163984 | 136549 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1160 Polk St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6006876.35083 | 2114950.02533 | 37.787638069192205 | -122.420008729221 | (37.7876380691922, -122.420008729221) | |||
| 67281 | 67281 | 142874 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1168 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006878.7832 | 2114929.3518 | 37.7875814418062 | -122.41999884602899 | (37.7875814418062, -122.419998846029) | |||
| 133966 | 133966 | 136543 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1177 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006827.654019999 | 2114934.96307 | 37.7875939682209 | -122.42017614161101 | (37.7875939682209, -122.420176141611) | |||
| 134852 | 134852 | 136544 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1177 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006828.33355 | 2114915.6748599997 | 37.7875410458324 | -122.42017242113998 | (37.7875410458324, -122.42017242114) | |||
| 91838 | 91838 | 142875 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1178 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 0ft | 6006878.3822 | 2114950.2065 | 37.787638681088296 | -122.420001713925 | (37.7876386810883, -122.420001713925) | |||
| 40961 | 40961 | 142877 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1187 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006832.261 | 2114920.1275 | 37.78755349297771 | -122.420159149048 | (37.7875534929777, -122.420159149048) | |||
| 168975 | 168975 | 142876 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1197 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 0ft | 6006828.381 | 2114947.7967 | 37.787629247171395 | -122.420174537563 | (37.7876292471714, -122.420174537563) | |||
| 53434 | 53434 | 215174 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 120 Bella Vista Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998431.33624 | 2097088.3182 | 37.7381148960726 | -122.447940224956 | (37.7381148960726, -122.447940224956) | |||
| 68351 | 68351 | 215175 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 120 Bella Vista Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5998426.00188 | 2097089.19076 | 37.7381169869985 | -122.447958731229 | (37.7381169869985, -122.447958731229) | |||
| 171224 | 171224 | 215173 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 120 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5998452.610280001 | 2097081.7839099998 | 37.7380981704837 | -122.44786619998399 | (37.7380981704837, -122.447866199984) | |||
| 29925 | 29925 | 136559 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1200 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009435.38581 | 2117472.07438 | 37.794706848389 | -122.41133317000099 | (37.794706848389, -122.411333170001) | |||
| 5370 | 5370 | 103797 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1201 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006813.15784 | 2115040.73173 | 37.78788356611221 | -122.42023380524599 | (37.7878835661122, -122.420233805246) | ||
| 7313 | 7313 | 103796 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1201 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006810.240669999 | 2115055.78241 | 37.7879247271976 | -122.420244966752 | (37.7879247271976, -122.420244966752) | ||
| 26088 | 26088 | 184889 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1201 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984679.4382 | 2106701.786 | 37.763715182625106 | -122.49619577469801 | (37.7637151826251, -122.496195774698) | |||
| 106075 | 106075 | 45711 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1202X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066.0 | 2116562.0 | 37.79213111040679 | -122.416006962529 | (37.7921311104068, -122.416006962529) | |
| 139723 | 139723 | 45710 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1202X Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 14 | 3x3 | Permit Number 47519 | 6008066.0 | 2116562.0 | 37.79213111040679 | -122.416006962529 | (37.7921311104068, -122.416006962529) | |
| 58263 | 58263 | 142863 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1203 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006816.2189 | 2115040.4436 | 37.787882947459 | -122.420223194063 | (37.787882947459, -122.420223194063) | |||
| 61379 | 61379 | 142862 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1203 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006813.0104 | 2115061.2984 | 37.7879400288134 | -122.420235775611 | (37.7879400288134, -122.420235775611) | |||
| 31871 | 31871 | 136566 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1218 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007796.91649 | 2118215.26217 | 37.796655426567995 | -122.41705519283998 | (37.796655426568, -122.41705519284) | |||
| 34845 | 34845 | 136565 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1218 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007807.752640001 | 2118217.01551 | 37.7966608503694 | -122.41701782152 | (37.7966608503694, -122.41701782152) | |||
| 44665 | 44665 | 197758 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Harrison St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009958.32307 | 2109652.80645 | 37.773266313822205 | -122.408971760735 | (37.7732663138222, -122.408971760735) | |||
| 48865 | 48865 | 197760 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Harrison St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6009984.84437 | 2109679.97053 | 37.773342385672 | -122.408881936452 | (37.773342385672, -122.408881936452) |
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");