trees
1,024 rows where qSpecies_id = 72 sorted by rowid descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194266 | 15786 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4840 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/04/2013 12:00:00 AM | 12 | 3x3 | Permit Number 785142 | 6001077.7653 | 2090502.844 | 37.7201836118857 | -122.43831855702 | (37.7201836118857, -122.43831855702) | 9 | 7 | 6 | 28861 | 25 | |
| 194261 | 15784 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2015 02:53:00 PM | 3 | 3X3 | Permit Number 785142 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | 9 | 7 | 6 | 28861 | 25 | |
| 193407 | 244833 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3048 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007096.09954 | 2100647.85149 | 37.7483800502086 | -122.41823403679 | (37.7483800502086, -122.41823403679) | 2 | 4 | 7 | 28859 | 19 | |||
| 193347 | 28459 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2160X Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 19 | 3x3 | 5992788.04983 | 2093457.91659 | 37.727822529658 | -122.467187832651 | (37.727822529658, -122.467187832651) | 9 | 8 | 4 | 59 | 40 | ||
| 192706 | 244856 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1599x Alabama St | 1 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 6009332.07458 | 2100182.02874 | 37.7472266103242 | -122.410469167039 | (37.7472266103242, -122.410469167039) | 2 | 7 | 7 | 28859 | 2 | |||
| 192472 | 187521 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 100x Mary Teresa St | 1 | Median : Yard | Tree | DPW 1 | 15 | Width 9ft | 6012597.41848 | 2087914.40308 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | 10 | 3 | 8 | 309 | 1 | |||
| 192210 | 247653 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 9 | : | Tree | Private 2 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | 15 | 5 | 5 | 29492 | 9 | |||
| 191949 | 15544 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2831 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6007105.1669 | 2101841.7215 | 37.7516586567519 | -122.418287316619 | (37.7516586567519, -122.418287316619) | 2 | 4 | 7 | 28859 | 19 | |||
| 191738 | 102441 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1007X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010078.92624 | 2112396.71132 | 37.7808071894337 | -122.408748191999 | (37.7808071894337, -122.408748191999) | 14 | 2 | 9 | 28853 | 34 | |||
| 191736 | 181993 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2488 30th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5987080.4247 | 2098320.1899 | 37.7408419339653 | -122.487275940676 | (37.7408419339653, -122.487275940676) | 1 | 8 | 3 | 29491 | 35 | |||
| 191552 | 101904 | Property Tree 8 | Washingtonia robusta :: Mexican Fan Palm 72 | 1100 Ocean Ave | 5 | Front Yard : Yard | Tree | DPW 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | 9 | 7 | 4 | 28861 | 40 | ||||
| 191132 | 245978 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2889 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6007119.1949 | 2101563.056 | 37.7508942943071 | -122.418219050821 | (37.7508942943071, -122.418219050821) | 2 | 4 | 7 | 28859 | 19 | |||
| 190954 | 1794 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2000 Bay Shore Blvd | 2 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6012280.2141 | 2088145.30834 | 37.7143411037303 | -122.399429765893 | (37.7143411037303, -122.399429765893) | 10 | 3 | 8 | 309 | 39 | |||
| 190852 | 21868 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015630.42851 | 2106799.74819 | 37.7657485399863 | -122.389151757746 | (37.7657485399863, -122.389151757746) | 14 | 3 | 9 | 310 | 29 | ||
| 190635 | 248076 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 405 Holladay Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6010319.42422 | 2098700.6468 | 37.7432143605434 | -122.406950576731 | (37.7432143605434, -122.406950576731) | 10 | 7 | 7 | 28859 | 2 | |||
| 190532 | 6107 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 600X El Camino Del Mar | 1 | Median : Cutout | Tree | DPW 1 | 24 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
| 190378 | 15487 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2637 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007039.9554 | 2102983.6811 | 37.7547905457997 | -122.4185937981 | (37.7547905457997, -122.4185937981) | 2 | 4 | 7 | 28859 | 19 | ||
| 190334 | 181269 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 37 Alpha St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6011324.26316 | 2088509.61111 | 37.7152880772715 | -122.402759532751 | (37.7152880772715, -122.402759532751) | 10 | 7 | 8 | 309 | 39 | |||
| 190208 | 15476 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2540 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006952.2887 | 2103573.3458 | 37.7564046935445 | -122.418938794072 | (37.7564046935445, -122.418938794072) | 2 | 4 | 7 | 28859 | 19 | ||
| 190149 | 32560 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 727 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | Permit Number 37045 | 6009321.36769465 | 2104857.59081295 | 37.7600640559522 | -122.410836353614 | (37.7600640559522, -122.410836353614) | 2 | 4 | 7 | 28859 | 19 | |||
| 190124 | 15404 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2040 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006793.6148 | 2106462.6587 | 37.764329138697 | -122.419692543556 | (37.764329138697, -122.419692543556) | 8 | 4 | 7 | 28859 | 19 | |||
| 189765 | 243923 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1x Bartlett St | 2 | Median : Yard | Tree | DPW 1 | 12 | Width 10ft | 6006672.06961 | 2103729.13284 | 37.7568166658685 | -122.419918946309 | (37.7568166658685, -122.419918946309) | 2 | 4 | 7 | 28859 | 19 | |||
| 189711 | 203198 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 101 Market St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.396090087604 | (37.7933092533841, -122.396090087604) | 12 | 2 | 9 | 28855 | 6 | |||
| 189704 | 26855 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006730.05548 | 2107572.97238 | 37.7673742180997 | -122.41999117589 | (37.7673742180997, -122.41999117589) | 8 | 4 | 7 | 28853 | 19 | ||
| 189666 | 15552 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2846 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6007045.846 | 2101751.2294 | 37.751406846694 | -122.418486040429 | (37.751406846694, -122.418486040429) | 2 | 4 | 7 | 28859 | 19 | |||
| 189262 | 15437 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2148 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006821.0239 | 2105826.6543 | 37.7625843634163 | -122.419552616574 | (37.7625843634163, -122.419552616574) | 8 | 4 | 7 | 28859 | 19 | ||
| 189145 | 181285 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 55 Stoneyford Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6006176.18741 | 2094039.87064 | 37.7301841895453 | -122.420945981966 | (37.7301841895453, -122.420945981966) | 9 | 7 | 7 | 28861 | 5 | ||||
| 189080 | 28548 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 5095 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000516.105 | 2089501.9034 | 37.7174032930481 | -122.440188283496 | (37.7174032930481, -122.440188283496) | 9 | 7 | 6 | 28861 | 5 | ||
| 188893 | 15523 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2777 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6007081.6604 | 2102211.0006 | 37.7526712897583 | -122.418394786513 | (37.7526712897583, -122.418394786513) | 2 | 4 | 7 | 28859 | 19 | |||
| 188619 | 118014 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 472 37th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 5984415.81444 | 2112632.82053 | 37.7799846626847 | -122.49754547051 | (37.7799846626847, -122.49754547051) | 11 | 6 | 2 | 55 | 26 | |||
| 188474 | 118483 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.509084778585 | (37.7788963529663, -122.509084778585) | 11 | 6 | 2 | 55 | 26 | ||||
| 188222 | 247650 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 6 | : | Tree | Private 2 | 15 | Width 5ft | 6001564.47006 | 2108298.85523 | 37.7690749298967 | -122.437910181532 | (37.7690749298967, -122.437910181532) | 15 | 5 | 5 | 29492 | 9 | |||
| 188146 | 96035 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2032 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767674 | 6006483 | 2117763 | 37.7953396281575 | -122.421569509833 | (37.7953396281575, -122.421569509833) | 13 | 9 | 10 | 28858 | 32 | |
| 188141 | 244829 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 3038 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007106.51614 | 2100714.99964 | 37.7485650101733 | -122.418202776331 | (37.7485650101733, -122.418202776331) | 2 | 4 | 7 | 28859 | 19 | |||
| 187754 | 1803 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2020 Bay Shore Blvd | 5 | Median : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.3625688 | 2088370.0571879 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | 10 | 7 | 8 | 309 | 39 | ||
| 187707 | 15385 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2000X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006779.1887 | 2106674.7215 | 37.7649106007235 | -122.41975748758 | (37.7649106007235, -122.41975748758) | 8 | 4 | 7 | 28859 | 19 | |||
| 187618 | 253249 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.13768 | 37.7809123781536 | -122.409958002933 | (37.7809123781536, -122.409958002933) | 14 | 2 | 9 | 28853 | 34 | |
| 187266 | 15503 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2721 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6007064.9784 | 2102504.4523 | 37.7534761019861 | -122.418473282249 | (37.7534761019861, -122.418473282249) | 2 | 4 | 7 | 28859 | 19 | |||
| 186817 | 102428 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 184 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 4x4 | 6010438.87034 | 2112046.078 | 37.7798645866165 | -122.407478236832 | (37.7798645866165, -122.407478236832) | 14 | 2 | 9 | 28853 | 34 | |||
| 186409 | 115490 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 280 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259 | 2091739 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | 9 | 8 | 4 | 28861 | 24 | |
| 185994 | 15772 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4769 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2007 12:00:00 AM | 3 | 3x3 | 6001557.6417 | 2091157.3044 | 37.7220078957558 | -122.436706610694 | (37.7220078957558, -122.436706610694) | 9 | 7 | 6 | 28861 | 5 | ||
| 185989 | 28424 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2390X Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992122.7651 | 2094324.99132 | 37.7301648752963 | -122.469550807661 | (37.7301648752963, -122.469550807661) | 9 | 8 | 4 | 59 | 40 | ||
| 185778 | 15546 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 2834 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6007035.77096 | 2101848.49078 | 37.7516733371001 | -122.418527777286 | (37.7516733371001, -122.418527777286) | 2 | 4 | 7 | 28859 | 19 | |||
| 185679 | 28469 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400X Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 16 | 3x3 | 5991803.10743 | 2094513.52119 | 37.7306640516002 | -122.470669622002 | (37.7306640516002, -122.470669622002) | 9 | 8 | 4 | 59 | 40 | ||
| 185208 | 1808 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2000 Bay Shore Blvd | 5 | Median : Cutout | Tree | DPW 1 | 15 | 6 | 6012226.45062 | 2088069.67407 | 37.7141304303483 | -122.399610287683 | (37.7141304303483, -122.399610287683) | 10 | 3 | 8 | 309 | 39 | |||
| 185172 | 137502 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1360 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008496.5924 | 2117239.72456 | 37.7940161753676 | -122.414565081618 | (37.7940161753676, -122.414565081618) | 5 | 1 | 10 | 28857 | 21 | |||
| 184823 | 199493 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 281 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6010934.97193 | 2111623.29262 | 37.7787314723253 | -122.405732204886 | (37.7787314723253, -122.405732204886) | 14 | 2 | 9 | 28853 | 34 | |||
| 184563 | 181998 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2476 30th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 5987077.3789 | 2098389.2279 | 37.7410313164056 | -122.487291541461 | (37.7410313164056, -122.487291541461) | 1 | 8 | 3 | 29491 | 35 | |||
| 184495 | 217464 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 127 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) | 9 | 8 | 6 | 64 | 24 | |||
| 184479 | 28584 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1150 Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2003 12:00:00 AM | 18 | 3X3 | 5996037.5543 | 2091961.17869 | 37.7238998872933 | -122.455846143025 | (37.7238998872933, -122.455846143025) | 9 | 8 | 4 | 28861 | 40 | ||
| 184470 | 217462 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1x Minerva St | 48 | Median : Cutout | Tree | DPW 1 | 16 | Width 0ft | 5996487.36469 | 2088998.47396 | 37.7157908018916 | -122.454077353311 | (37.7157908018916, -122.454077353311) | 9 | 8 | 6 | 28861 | 24 | |||
| 184384 | 28401 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1801 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994365.43766 | 2092389.56598 | 37.7249800267364 | -122.46165738286 | (37.7249800267364, -122.46165738286) | 9 | 8 | 4 | 28861 | 24 | ||
| 184351 | 199456 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.7712642152147 | -122.389359890563 | (37.7712642152147, -122.389359890563) | 14 | 3 | 9 | 310 | 20 | |||
| 184347 | 15480 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2601 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1994 12:00:00 AM | 12 | 4X4 | 6007030.0978 | 2103104.2466 | 37.7551210360206 | -122.418636437773 | (37.7551210360206, -122.418636437773) | 2 | 4 | 7 | 28859 | 19 | ||
| 184220 | 99841 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44828 | 5992070 | 2105943 | 37.7620618943588 | -122.470579074603 | (37.7620618943588, -122.470579074603) | 1 | 8 | 11 | 56 | 12 | ||||
| 183997 | 203187 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2209 25th St | 1 | Front Yard : Yard | Tree | Private 2 | 18 | 6012122.25902 | 2101859.12536 | 37.7519875798856 | -122.400938678078 | (37.7519875798856, -122.400938678078) | 10 | 3 | 8 | 28856 | 29 | ||||
| 183868 | 96941 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 108 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 5995926.85193 | 2113670.95774 | 37.7835031091294 | -122.457799026544 | (37.7835031091294, -122.457799026544) | 11 | 6 | 1 | 54 | 31 | ||||
| 183659 | 244849 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 300 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006696.49 | 2104313.33702 | 37.7584221311058 | -122.419875945215 | (37.7584221311058, -122.419875945215) | 2 | 4 | 7 | 28859 | 19 | |||
| 183516 | 203183 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 03rd St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6015658.44629 | 2106386.75714 | 37.7646161091615 | -122.38902601186 | (37.7646161091615, -122.38902601186) | 14 | 3 | 9 | 310 | 29 | |||
| 183344 | 116595 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 800x SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002075 | 2111247 | 37.7771988203893 | -122.436355315705 | (37.7771988203893, -122.436355315705) | 15 | 5 | 11 | 29492 | 41 | ||||
| 182444 | 187461 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4900 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6000966.6486 | 2090329.2095 | 37.7197005299847 | -122.438690214146 | (37.7197005299847, -122.438690214146) | 9 | 7 | 6 | 28861 | 25 | |||
| 182425 | 48630 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1501 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45927 | 5991498.56479756 | 2105191.60606182 | 37.7599657064663 | -122.472500646803 | (37.7599657064663, -122.472500646803) | 1 | 8 | 4 | 56 | 12 | ||
| 182377 | 104926 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 810 Gonzalez Dr | 1 | Median : Yard | Tree | Private 2 | 5990385 | 2090588 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | 1 | 8 | 4 | 64 | 14 | |||||
| 182287 | 199464 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1530 03rd St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6015598.48485 | 2107402.18483 | 37.7674009291493 | -122.389304316962 | (37.7674009291493, -122.389304316962) | 14 | 3 | 9 | 310 | 20 | |||
| 182277 | 1802 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2020 Bay Shore Blvd | 4 | Median : Cutout | Tree | DPW 1 | 03/11/2007 12:00:00 AM | 12 | 6 | 6012311.3625688 | 2088370.0571879 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | 10 | 7 | 8 | 309 | 39 | ||
| 182217 | 217830 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2400 Ocean Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 5991664.0561 | 2094598.00072 | 37.730887969306 | -122.471156491586 | (37.730887969306, -122.471156491586) | 9 | 8 | 4 | 59 | 40 | ||||
| 182210 | 246271 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2097 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6006863.2777 | 2106174.4953 | 37.7635418334379 | -122.419431153874 | (37.7635418334379, -122.419431153874) | 8 | 4 | 7 | 28859 | 19 | |||
| 182104 | 247324 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2998 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6006942.8105 | 2106758.6304 | 37.7651502108552 | -122.419197512578 | (37.7651502108552, -122.419197512578) | 8 | 4 | 7 | 28853 | 19 | |||
| 182084 | 203200 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 189 Hubbell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013014.64692 | 2107133.40427 | 37.7665193318293 | -122.398222657156 | (37.7665193318293, -122.398222657156) | 14 | 3 | 8 | 28856 | 20 | |
| 182019 | 217477 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5994377.24851 | 2101823.40778 | 37.750883697139 | -122.462300455497 | (37.750883697139, -122.462300455497) | 1 | 8 | 4 | 29491 | 40 | |||
| 182015 | 15367 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1950X Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | 8 | 4 | 7 | 28853 | 19 | |||
| 181550 | 247655 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 11 | : | Tree | Private 2 | 14 | Width 5ft | 6001504.48718 | 2108295.83572 | 37.7690632279191 | -122.438117441986 | (37.7690632279191, -122.438117441986) | 15 | 5 | 5 | 29492 | 9 | |||
| 181013 | 199436 | Planning Code 138.1 required 2 | Washingtonia robusta :: Mexican Fan Palm 72 | 189 Hubbell St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013326.10031 | 2107431.53826 | 37.767355284933 | -122.397166295486 | (37.767355284933, -122.397166295486) | 14 | 3 | 8 | 28856 | 20 | |
| 181006 | 247645 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900 Duboce Ave | 1 | : | Tree | Private 2 | 14 | Width 5ft | 6001626.84914 | 2108303.83597 | 37.7690921528084 | -122.437694773193 | (37.7690921528084, -122.437694773193) | 15 | 5 | 5 | 29492 | 9 | |||
| 180979 | 181288 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 701 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6002649.9412 | 2087357.15211 | 37.7116355320158 | -122.432659488848 | (37.7116355320158, -122.432659488848) | 9 | 7 | 6 | 28861 | 5 | |||
| 180976 | 15439 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2162 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006823.9061 | 2105762.5248 | 37.7624084411332 | -122.419538098029 | (37.7624084411332, -122.419538098029) | 8 | 4 | 7 | 28859 | 19 | ||
| 180632 | 15357 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 1930 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006758.13881 | 2107137.81381 | 37.7661809574571 | -122.419863157304 | (37.7661809574571, -122.419863157304) | 8 | 4 | 7 | 28853 | 19 | |||
| 180323 | 1799 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2020 Bay Shore Blvd | 1 | Median : Cutout | Tree | DPW 1 | 12 | 6 | 6012311.3625688 | 2088370.0571879 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | 10 | 7 | 8 | 309 | 39 | |||
| 180177 | 28537 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4716 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001661.0091 | 2091431.1044 | 37.7227655627881 | -122.436368881923 | (37.7227655627881, -122.436368881923) | 9 | 7 | 6 | 28861 | 25 | ||
| 180148 | 28429 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2499 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991627.58277 | 2094536.00687 | 37.7307156399791 | -122.471278069527 | (37.7307156399791, -122.471278069527) | 9 | 8 | 4 | 59 | 40 | ||
| 180097 | 24579 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2862 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007054.1039 | 2101659.758 | 37.751156151933 | -122.418450998256 | (37.751156151933, -122.418450998256) | 2 | 4 | 7 | 28859 | 19 | |||
| 179860 | 246360 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1932 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6006755.8259 | 2107130.7038 | 37.7661613047432 | -122.419870652653 | (37.7661613047432, -122.419870652653) | 8 | 4 | 7 | 28853 | 19 | |||
| 179263 | 181247 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2200x Bay Shore Blvd | 6 | Median : Cutout | Tree | DPW 1 | 14 | Width 6ft | 6011190.75371 | 2087265.8089 | 37.7118653915605 | -122.403133563489 | (37.7118653915605, -122.403133563489) | 9 | 7 | 8 | 309 | 1 | |||
| 178831 | 181282 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 239 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004063.89485 | 2092132.64778 | 37.7248280873336 | -122.428112590334 | (37.7248280873336, -122.428112590334) | 9 | 7 | 6 | 28861 | 5 | |||
| 178771 | 199472 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6015475.23167 | 2109575.21201 | 37.7733607507341 | -122.389882442542 | (37.7733607507341, -122.389882442542) | 14 | 3 | 9 | 310 | 20 | |||
| 178561 | 15742 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4534 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | 12 | 3X3 | 6002267.3808 | 2092395.6017 | 37.7254482915062 | -122.434341710076 | (37.7254482915062, -122.434341710076) | 9 | 7 | 6 | 28861 | 25 | ||
| 178462 | 15777 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 4826 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2013 12:00:00 AM | 14 | 3X3 | 6001241.8395 | 2090763.6886 | 37.7209091632567 | -122.437770080734 | (37.7209091632567, -122.437770080734) | 9 | 7 | 6 | 28861 | 25 | ||
| 177967 | 46765 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 46 Admiral Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 14 | Permit Number 44862 | 6003326.43729 | 2094178.57402 | 37.7304039901516 | -122.430807830618 | (37.7304039901516, -122.430807830618) | 9 | 7 | 6 | 28861 | 25 | |
| 177896 | 15377 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1979 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006845.42112 | 2106936.21263 | 37.7656323248047 | -122.419546959621 | (37.7656323248047, -122.419546959621) | 8 | 4 | 7 | 28853 | 19 | |||
| 177828 | 203174 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 331 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 7ft | 6014370.72377 | 2105559.7788 | 37.7622739427176 | -122.39342205629 | (37.7622739427176, -122.39342205629) | 10 | 3 | 8 | 28856 | 29 | |||
| 177439 | 15346 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6006752.3955 | 2107277.3553 | 37.7665637819511 | -122.419892925221 | (37.7665637819511, -122.419892925221) | 8 | 4 | 7 | 28853 | 19 | |||
| 177323 | 15398 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 2029 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006849.6288 | 2106465.6722 | 37.7643405682415 | -122.419499020257 | (37.7643405682415, -122.419499020257) | 8 | 4 | 7 | 28859 | 19 | |||
| 177172 | 49324 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 650 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2003 12:00:00 AM | Permit Number 46321 | 6013145.06683573 | 2110537.17362663 | 37.775872581057 | -122.398010359546 | (37.775872581057, -122.398010359546) | 14 | 2 | 9 | 28856 | 20 | |||
| 177074 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014575 | 2115523 | 37.789642061391 | -122.393412811769 | (37.789642061391, -122.393412811769) | 6 | 2 | 9 | 28855 | 6 | ||||
| 176948 | 124342 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 105 Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5995870.42219 | 2113701.84259 | 37.7835846686773 | -122.457996486135 | (37.7835846686773, -122.457996486135) | 11 | 6 | 1 | 54 | 31 | |||
| 176629 | 217437 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 601x Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12 | Width 4ft | 5997794.81955 | 2094706.79322 | 37.7315393941054 | -122.449969377904 | (37.7315393941054, -122.449969377904) | 9 | 7 | 4 | 59 | 40 | |||
| 176584 | 244814 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 45 Hoff St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 6ft | 6006569.6779 | 2106452.55606 | 37.7642887820295 | -122.420466362743 | (37.7642887820295, -122.420466362743) | 8 | 4 | 7 | 28859 | 19 | |||
| 176147 | 28413 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 530X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998569.7206668 | 2094722.0869744 | 37.7316256964467 | -122.447291505966 | (37.7316256964467, -122.447291505966) | 9 | 7 | 4 | 59 | 40 | ||
| 176055 | 25056 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 900X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291723 | (37.7540464140318, -122.42537291723) | 2 | 4 | 5 | 28862 | 22 | |||
| 176053 | 30858 | Permitted Site 7 | Washingtonia robusta :: Mexican Fan Palm 72 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 |
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) );