Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21517 | 21517 | 15533 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2799X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6007088.4849 | 2102162.4711 | 37.7525384229961 | -122.418367745483 | (37.7525384229961, -122.418367745483) | |||
| 21541 | 21541 | 15552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2846 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6007045.846 | 2101751.2294 | 37.751406846694 | -122.418486040429 | (37.751406846694, -122.418486040429) | |||
| 21592 | 21592 | 15389 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006783.5165 | 2106591.7718 | 37.764683084119895 | -122.419736632649 | (37.7646830841199, -122.419736632649) | |||
| 21610 | 21610 | 15437 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2148 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006821.0239 | 2105826.6543 | 37.762584363416295 | -122.419552616574 | (37.7625843634163, -122.419552616574) | ||
| 21745 | 21745 | 15549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007044.5756 | 2101802.0469 | 37.7515463084579 | -122.41849403667 | (37.7515463084579, -122.41849403667) | |||
| 21746 | 21746 | 28469 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 16 | 3x3 | 5991803.10743 | 2094513.5211900002 | 37.7306640516002 | -122.47066962200199 | (37.7306640516002, -122.470669622002) | ||
| 21785 | 21785 | 25131 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005285.7039 | 2098966.45887 | 37.74366125975121 | -122.42437477586901 | (37.7436612597512, -122.424374775869) | |||
| 21933 | 21933 | 15385 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006779.1887 | 2106674.7215 | 37.7649106007235 | -122.41975748758001 | (37.7649106007235, -122.41975748758) | |||
| 21999 | 21999 | 25056 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291722999 | (37.7540464140318, -122.42537291723) | |||
| 22032 | 22032 | 24579 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2862 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007054.1039 | 2101659.758 | 37.751156151932996 | -122.41845099825599 | (37.751156151933, -122.418450998256) | |||
| 22135 | 22135 | 15500 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2710 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102497.935 | 37.7534556236904 | -122.41863150374701 | (37.7534556236904, -122.418631503747) | |||
| 22193 | 22193 | 15487 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2637 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007039.9554 | 2102983.6811 | 37.7547905457997 | -122.41859379809999 | (37.7547905457997, -122.4185937981) | ||
| 22194 | 22194 | 15476 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2540 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006952.2887 | 2103573.3458 | 37.7564046935445 | -122.418938794072 | (37.7564046935445, -122.418938794072) | ||
| 22272 | 22272 | 26854 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006727.5247 | 2107586.953 | 37.76741246299579 | -122.42000092176201 | (37.7674124629958, -122.420000921762) | ||
| 23162 | 23162 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 367 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6002770.52649 | 2101500.0126900002 | 37.7504754543841 | -122.43325263672399 | (37.7504754543841, -122.433252636724) | ||||
| 23356 | 23356 | 1808 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 6 | 6012226.450619999 | 2088069.6740700002 | 37.7141304303483 | -122.39961028768299 | (37.7141304303483, -122.399610287683) | |||
| 23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
| 23753 | 23753 | 199483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015509.13182 | 2108964.41049 | 37.7716855044225 | -122.38972250619801 | (37.7716855044225, -122.389722506198) | |||
| 23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
| 23991 | 23991 | 246367 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1999 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6006824.8887 | 2106890.3369 | 37.7655052042839 | -122.41961472171002 | (37.7655052042839, -122.41961472171) | |||
| 24106 | 24106 | 246790 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 175 Brewster St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010136.6415 | 2098750.10917 | 37.74333994367979 | -122.40758608083901 | (37.7433399436798, -122.407586080839) | ||||
| 24199 | 24199 | 217439 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997627.34725 | 2094709.1564 | 37.7315362986663 | -122.450548529595 | (37.7315362986663, -122.450548529595) | |||
| 24537 | 24537 | 217484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 554 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5997767.10933 | 2095284.1068799999 | 37.7331229743458 | -122.450106772723 | (37.7331229743458, -122.450106772723) | ||||
| 24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
| 24710 | 24710 | 38696 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 442 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 8 | Permit Number 40608 | 6000200.5427 | 2110464.1107 | 37.7749425203696 | -122.442783410713 | (37.7749425203696, -122.442783410713) | |
| 24790 | 24790 | 199437 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013340.81155 | 2107445.60575 | 37.7673947300992 | -122.397116397514 | (37.7673947300992, -122.397116397514) | |||
| 25192 | 25192 | 203195 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1998 Revere Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6012994.723999999 | 2096005.499 | 37.735963390387 | -122.39751105148999 | (37.735963390387, -122.39751105149) | ||||
| 25234 | 25234 | 244842 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6006681.50629 | 2103383.71332 | 37.755868755243704 | -122.419861800707 | (37.7558687552437, -122.419861800707) | |||
| 25274 | 25274 | 203174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 331 Pennsylvania Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6014370.72377 | 2105559.7788 | 37.7622739427176 | -122.39342205628999 | (37.7622739427176, -122.39342205629) | |||
| 25608 | 25608 | 246285 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6006870.1021 | 2106021.3241 | 37.763121645518204 | -122.419396683437 | (37.7631216455182, -122.419396683437) | |||
| 26642 | 26642 | 27703 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995069.03366 | 2092243.1445 | 37.7246184644438 | -122.45921454824101 | (37.7246184644438, -122.459214548241) | ||
| 26802 | 26802 | 243938 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 315 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003592.012490001 | 2106424.54324 | 37.764043612453996 | -122.43076326292 | (37.764043612454, -122.43076326292) | |||
| 27009 | 27009 | 199444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015656.62698 | 2107992.23345 | 37.769024297155205 | -122.389144413879 | (37.7690242971552, -122.389144413879) | |||
| 27058 | 27058 | 247653 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001528.81511 | 2108296.30035 | 37.7690658872209 | -122.438033326596 | (37.7690658872209, -122.438033326596) | |||
| 27240 | 27240 | 73535 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2207 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 18 | 5987582.0279 | 2100272.2966 | 37.7462311393003 | -122.485684839892 | (37.7462311393003, -122.485684839892) | ||
| 27436 | 27436 | 244863 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 117 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006906.41702 | 2098789.62543 | 37.7432671013094 | -122.418758192246 | (37.7432671013094, -122.418758192246) | |||
| 27544 | 27544 | 217486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 134 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 10ft | 5999850.54516 | 2094099.6824900003 | 37.729989823555705 | -122.442818779256 | (37.7299898235557, -122.442818779256) | |||
| 27550 | 27550 | 217457 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 5996170.11239 | 2089001.42717 | 37.7157807141869 | -122.455174130483 | (37.7157807141869, -122.455174130483) | |||
| 27658 | 27658 | 246312 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1601 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007098.251 | 2109393.5574 | 37.7723938509682 | -122.418846769596 | (37.7723938509682, -122.418846769596) | |||
| 27734 | 27734 | 181258 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010956.04386 | 2086896.41565 | 37.7108380015362 | -122.403918812817 | (37.7108380015362, -122.403918812817) | |||
| 27968 | 27968 | 199441 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013426.97714 | 2107527.99953 | 37.767625761459705 | -122.39682413764 | (37.7676257614597, -122.39682413764) | |||
| 28011 | 28011 | 124342 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5995870.42219 | 2113701.84259 | 37.7835846686773 | -122.457996486135 | (37.7835846686773, -122.457996486135) | |||
| 28270 | 28270 | 217447 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 395 Faxon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 5994720.00419 | 2091109.04775 | 37.721484434931796 | -122.460338956771 | (37.7214844349318, -122.460338956771) | |||
| 28377 | 28377 | 48685 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2002 12:00:00 AM | 22 | Permit Number 45967 | 5995923.78548 | 2113769.63655 | 37.7837738786202 | -122.45781677815 | (37.7837738786202, -122.45781677815) | ||
| 28387 | 28387 | 199462 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015592.103080001 | 2107492.64638 | 37.7676489630463 | -122.389332708559 | (37.7676489630463, -122.389332708559) | |||
| 28662 | 28662 | 247652 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 8 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001539.54665 | 2108297.82153 | 37.7690706742937 | -122.437996315894 | (37.7690706742937, -122.437996315894) | |||
| 29208 | 29208 | 181257 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010977.11587 | 2086929.96483 | 37.7109312981009 | -122.40384834192801 | (37.7109312981009, -122.403848341928) | |||
| 29445 | 29445 | 124343 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995870.59128 | 2113726.09219 | 37.7836512613147 | -122.457997656644 | (37.7836512613147, -122.457997656644) | |||
| 29712 | 29712 | 244826 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 500x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6004940.864159999 | 2105188.02891 | 37.760724766043 | -122.42600994929501 | (37.760724766043, -122.426009949295) | ||||
| 29817 | 29817 | 245984 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2755 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6007074.8359 | 2102333.0826 | 37.7530061148801 | -122.418427042538 | (37.7530061148801, -122.418427042538) | |||
| 30281 | 30281 | 181242 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6011652.37664 | 2087363.09382 | 37.7121582854612 | -122.40154488951099 | (37.7121582854612, -122.401544889511) | |||
| 30691 | 30691 | 244835 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006729.90929 | 2107524.20157 | 37.7672402967355 | -122.41998822018101 | (37.7672402967355, -122.419988220181) | |||
| 31002 | 31002 | 203209 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013274.2221800005 | 2107384.36901 | 37.767222880462796 | -122.39734242771401 | (37.7672228804628, -122.397342427714) | |||
| 31642 | 31642 | 217485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 616 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5998040.52965 | 2095018.98025 | 37.7324106420337 | -122.449142396404 | (37.7324106420337, -122.449142396404) | |||
| 31746 | 31746 | 243915 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 527 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6009846.89705 | 2099022.9743 | 37.744072948723996 | -122.408607191783 | (37.744072948724, -122.408607191783) | |||
| 31881 | 31881 | 199455 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015625.9056 | 2108540.0716 | 37.7705268376657 | -122.389288938555 | (37.7705268376657, -122.389288938555) | |||
| 32638 | 32638 | 199456 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015610.82208 | 2108808.9255 | 37.77126421521471 | -122.38935989056299 | (37.7712642152147, -122.389359890563) | |||
| 32681 | 32681 | 181225 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 6012142.64872 | 2087966.32727 | 37.713841988985 | -122.399892688298 | (37.713841988985, -122.399892688298) | |||
| 32721 | 32721 | 217463 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1x Minerva St | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 5996525.6642 | 2088997.67416 | 37.7157908018682 | -122.45394491554701 | (37.7157908018682, -122.453944915547) | |||
| 32803 | 32803 | 243929 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1409 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6001410.85086 | 2099557.6127299997 | 37.745064858666 | -122.437815383076 | (37.745064858666, -122.437815383076) | |||
| 32830 | 32830 | 203205 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013159.72459 | 2107270.14751 | 37.7669028782866 | -122.397730448328 | (37.7669028782866, -122.397730448328) | |||
| 33231 | 33231 | 181999 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2474 30th Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5987078.0557 | 2098396.6732 | 37.7410517986936 | -122.487289748097 | (37.7410517986936, -122.487289748097) | |||
| 33282 | 33282 | 217464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) | |||
| 33283 | 33283 | 181264 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 6009517.64457 | 2087677.5938400002 | 37.712902490626895 | -122.40894535574499 | (37.7129024906269, -122.408945355745) | |||
| 33501 | 33501 | 199465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015601.020959999 | 2107350.5744 | 37.7672593587506 | -122.389291940488 | (37.7672593587506, -122.389291940488) | |||
| 33585 | 33585 | 137505 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007440.6556 | 2121042.48362 | 37.8043982179661 | -122.41848851434601 | (37.8043982179661, -122.418488514346) | |||
| 33699 | 33699 | 187438 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4760 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001460.7844 | 2091113.675 | 37.721882594303395 | -122.437038299541 | (37.7218825943034, -122.437038299541) | |||
| 33738 | 33738 | 181254 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011072.17285 | 2087082.1734200001 | 37.711354542437 | -122.403530502643 | (37.711354542437, -122.403530502643) | |||
| 33786 | 33786 | 199476 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015490.48538 | 2109320.84762 | 37.772663168207 | -122.389811906894 | (37.772663168207, -122.389811906894) | |||
| 34301 | 34301 | 96815 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2011 12:00:00 AM | Permit Number 767914 | 6002672.5 | 2105813.7 | 37.762314246216995 | -122.43389991802401 | (37.762314246217, -122.433899918024) | |||
| 34386 | 34386 | 199497 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 72 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010024.2102 | 2112481.0403 | 37.7810356721041 | -122.408943433887 | (37.7810356721041, -122.408943433887) | |||
| 34652 | 34652 | 243942 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 3ft | 6004361.46086 | 2104388.80864 | 37.7584975338534 | -122.427956893407 | (37.7584975338534, -122.427956893407) | |||
| 34846 | 34846 | 243945 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007159.400359999 | 2109389.15821 | 37.7723852147468 | -122.41863493565901 | (37.7723852147468, -122.418634935659) | |||
| 35169 | 35169 | 217430 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1113 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5991534.38297 | 2105188.62915 | 37.7599596057689 | -122.47237655325 | (37.7599596057689, -122.47237655325) | |||
| 35626 | 35626 | 199488 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015518.167640001 | 2108801.30732 | 37.7712381600557 | -122.38967985676099 | (37.7712381600557, -122.389679856761) | |||
| 35685 | 35685 | 244827 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1450x Dolores St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6005245.250469999 | 2099669.70272 | 37.745589922449604 | -122.424564667746 | (37.7455899224496, -122.424564667746) | ||||
| 35759 | 35759 | 117922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 683 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983174.6969099995 | 2111166.71748 | 37.775886344567496 | -122.501730482451 | (37.7758863445675, -122.501730482451) | |||
| 35882 | 35882 | 181250 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011135.05622 | 2087186.9706 | 37.7116458067799 | -122.403320528015 | (37.7116458067799, -122.403320528015) | |||
| 36034 | 36034 | 187450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5098 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000319.4478 | 2089309.2863 | 37.7168632117114 | -122.440854224757 | (37.7168632117114, -122.440854224757) | |||
| 36738 | 36738 | 181277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988402.74919 | 2089827.8491900002 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | ||||
| 36914 | 36914 | 247654 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6001517.12711 | 2108295.57391 | 37.7690632279012 | -122.438073702561 | (37.7690632279012, -122.438073702561) | |||
| 37483 | 37483 | 217487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 15 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 5999757.91748 | 2093744.86936 | 37.729010308071 | -122.44311353116501 | (37.729010308071, -122.443113531165) | |||
| 38080 | 38080 | 217478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 51 Keystone Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5994094.09681 | 2093023.21308 | 37.7267042448879 | -122.462641314769 | (37.7267042448879, -122.462641314769) | |||
| 38378 | 38378 | 203183 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015658.44629 | 2106386.7571400004 | 37.7646161091615 | -122.38902601186001 | (37.7646161091615, -122.38902601186) | |||
| 38493 | 38493 | 181278 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 46 Admiral Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003332.53306 | 2094181.6518 | 37.730412786411904 | -122.430786976247 | (37.7304127864119, -122.430786976247) | |||
| 38749 | 38749 | 181998 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2476 30th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987077.3789 | 2098389.2279 | 37.7410313164056 | -122.48729154146099 | (37.7410313164056, -122.487291541461) | |||
| 38867 | 38867 | 199498 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1008 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6010028.2471900005 | 2112434.38373 | 37.780907790314394 | -122.40892617503 | (37.7809077903144, -122.40892617503) | |||
| 39038 | 39038 | 203204 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013138.407819999 | 2107249.76439 | 37.766845723690096 | -122.397802750202 | (37.7668457236901, -122.397802750202) | |||
| 39171 | 39171 | 181241 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6011651.716019999 | 2087377.2812700002 | 37.712197204501294 | -122.401548169322 | (37.7121972045013, -122.401548169322) | |||
| 39215 | 39215 | 199440 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013418.56487 | 2107519.66805 | 37.767602416836 | -122.396852650636 | (37.767602416836, -122.396852650636) | |||
| 39492 | 39492 | 181267 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 3ft | 6009562.93662 | 2087661.4051599998 | 37.7128605768164 | -122.40878766951799 | (37.7128605768164, -122.408787669518) | |||
| 39669 | 39669 | 118709 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 4201 Balboa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5982467.72104 | 2110969.09723 | 37.7753021852736 | -122.504161410758 | (37.7753021852736, -122.504161410758) | |||
| 39861 | 39861 | 65881 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 122 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 19 | 3x3 | Permit Number 53867 | 5995930.99366 | 2113550.02665 | 37.783171302573 | -122.457775944343 | (37.783171302573, -122.457775944343) |
| 39967 | 39967 | 199470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543001 | (37.7739526530238, -122.38994067543) | |||
| 40393 | 40393 | 244837 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6006731.37022 | 2107461.01908 | 37.7670668948411 | -122.41997868286998 | (37.7670668948411, -122.41997868287) | |||
| 40464 | 40464 | 199494 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 281 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010924.085580001 | 2111634.58421 | 37.7787618676114 | -122.405770660782 | (37.7787618676114, -122.405770660782) | |||
| 40524 | 40524 | 246614 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6009136.11989 | 2100236.51166 | 37.7473652210349 | -122.411150613905 | (37.7473652210349, -122.411150613905) | |||
| 40665 | 40665 | 244841 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1880 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006736.38106 | 2107369.27612 | 37.766815272626296 | -122.41995484006901 | (37.7668152726263, -122.419954840069) | |||
| 40752 | 40752 | 181255 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011058.3910300005 | 2087059.24952 | 37.71129082818 | -122.403576524557 | (37.71129082818, -122.403576524557) | |||
| 40806 | 40806 | 217440 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 601x Monterey Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 4ft | 5997608.12096 | 2094709.9328599998 | 37.731537330169 | -122.450615054238 | (37.731537330169, -122.450615054238) |
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");