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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20857 | 20857 | 15519 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2768 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007027.5439 | 2102261.5951 | 37.7528071641561 | -122.41858551881901 | (37.7528071641561, -122.418585518819) | |||
| 20884 | 20884 | 15410 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2065 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006857.2115 | 2106321.6003 | 37.7639454076577 | -122.41946257191601 | (37.7639454076577, -122.419462571916) | |||
| 20945 | 20945 | 15473 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2501 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6007001.2834 | 2103755.6033 | 37.7569078893914 | -122.41878227799101 | (37.7569078893914, -122.418782277991) | ||
| 21082 | 21082 | 28787 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2518 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006949.0139999995 | 2103676.1713 | 37.7566868442816 | -122.418957411892 | (37.7566868442816, -122.418957411892) | |||
| 21136 | 21136 | 15424 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2101 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006867.8273 | 2106045.5888 | 37.763188142588604 | -122.419406272714 | (37.7631881425886, -122.419406272714) | |||
| 21146 | 21146 | 15506 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2738 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2006 12:00:00 AM | 3 | 3x3 | 6007021.0573 | 2102399.0391 | 37.753184188782 | -122.41861769652 | (37.753184188782, -122.41861769652) | ||
| 21205 | 21205 | 15439 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2162 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006823.9061 | 2105762.5248 | 37.7624084411332 | -122.41953809802901 | (37.7624084411332, -122.419538098029) | ||
| 21244 | 21244 | 15551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007105.1669 | 2101800.0164 | 37.751544144042 | -122.418284359977 | (37.751544144042, -122.418284359977) | |||
| 21306 | 21306 | 15355 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1924 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006751.5378 | 2107181.3028 | 37.766299996101 | -122.41988907525 | (37.766299996101, -122.41988907525) | |||
| 21352 | 21352 | 15530 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2799X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007090.0014 | 2102107.8754 | 37.752388601025295 | -122.418358630452 | (37.7523886010253, -122.418358630452) | |||
| 21432 | 21432 | 15474 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2515 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6007000.5252 | 2103706.3156 | 37.756772514034 | -122.418781404781 | (37.756772514034, -122.418781404781) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |||
| 41031 | 41031 | 182386 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1538 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985306.5492 | 2104723.6759 | 37.758320556835606 | -122.493881037718 | (37.7583205568356, -122.493881037718) | |||
| 41272 | 41272 | 243941 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 701 Church St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 3ft | 6004362.39063 | 2104350.06977 | 37.758391218686796 | -122.4279509174 | (37.7583912186868, -122.4279509174) | |||
| 43297 | 43297 | 181269 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 37 Alpha St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6011324.26316 | 2088509.61111 | 37.7152880772715 | -122.402759532751 | (37.7152880772715, -122.402759532751) | |||
| 43355 | 43355 | 41527 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 19 | Permit Number 42067 | 6018424.261969999 | 2095097.67116 | 37.7337714988594 | -122.378675747684 | (37.7337714988594, -122.378675747684) | ||
| 44144 | 44144 | 184617 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1758 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981057.9764 | 2103098.1394 | 37.753607806054 | -122.508453540189 | (37.753607806054, -122.508453540189) | |||
| 44198 | 44198 | 246412 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3032 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007104.9213 | 2100736.786 | 37.7486247408195 | -122.41820983567499 | (37.7486247408195, -122.418209835675) | |||
| 44242 | 44242 | 181222 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 578 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002385.20268 | 2090560.3971799999 | 37.720415918045795 | -122.43380329969101 | (37.7204159180458, -122.433803299691) | |||
| 44370 | 44370 | 137500 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 52 Iris Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5997635.71873 | 2114163.76026 | 37.78495423950061 | -122.451922604659 | (37.7849542395006, -122.451922604659) | |||
| 44429 | 44429 | 244865 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005730.73165 | 2096631.6868599998 | 37.737275621771104 | -122.42267009385401 | (37.7372756217711, -122.422670093854) | |||
| 45056 | 45056 | 217450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996493.32654 | 2090728.3649400002 | 37.720541019141706 | -122.454181619786 | (37.7205410191417, -122.454181619786) | |||
| 45244 | 45244 | 124344 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 105 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5995869.2461 | 2113758.79509 | 37.7837409774514 | -122.458004677882 | (37.7837409774514, -122.458004677882) | |||
| 45399 | 45399 | 181238 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6011635.346940001 | 2087388.95322 | 37.7122283399444 | -122.401605565857 | (37.7122283399444, -122.401605565857) | |||
| 46987 | 46987 | 102441 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1007X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010078.92624 | 2112396.7113200002 | 37.7808071894337 | -122.408748191999 | (37.7808071894337, -122.408748191999) | |||
| 47898 | 47898 | 248076 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Holladay Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6010319.424219999 | 2098700.6468 | 37.7432143605434 | -122.40695057673099 | (37.7432143605434, -122.406950576731) | |||
| 48613 | 48613 | 244810 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1346 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010313.90218 | 2101409.39253 | 37.750651674745995 | -122.407160569311 | (37.750651674746, -122.407160569311) | |||
| 48660 | 48660 | 243926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 41 Bartlett St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 6ft | 6006689.91006 | 2103386.78803 | 37.7558776711221 | -122.41983295584299 | (37.7558776711221, -122.419832955843) | |||
| 48922 | 48922 | 181271 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 40 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6009195.7252 | 2086405.87787 | 37.7093925805717 | -122.409968299499 | (37.7093925805717, -122.409968299499) | |||
| 49819 | 49819 | 49090 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Permit Number 46240 | 6005000.86531 | 2092599.96167 | 37.7261641966181 | -122.424906823795 | (37.7261641966181, -122.424906823795) | |||
| 50033 | 50033 | 246413 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2214 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6006845.3803 | 2105424.2757 | 37.7614808975479 | -122.419439828815 | (37.7614808975479, -122.419439828815) | |||
| 50210 | 50210 | 182350 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5985255.7552 | 2104953.475 | 37.7589485494212 | -122.49407363959699 | (37.7589485494212, -122.494073639597) | |||
| 50542 | 50542 | 56949 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | ||
| 50846 | 50846 | 124333 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 172 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995945.982919999 | 2113131.373 | 37.782022652324294 | -122.45769378533001 | (37.7820226523243, -122.45769378533) | |||
| 51238 | 51238 | 244854 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 633 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6010136.631019999 | 2105337.9481099998 | 37.7614286878927 | -122.40805061214199 | (37.7614286878927, -122.408050612142) | |||
| 51345 | 51345 | 217449 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5995950.204940001 | 2090812.4665700002 | 37.7207407828315 | -122.45606508435101 | (37.7207407828315, -122.456065084351) | |||
| 51490 | 51490 | 67305 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2317 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1992 12:00:00 AM | 18 | Permit Number 30786 | 6000748.48964 | 2119604.08725 | 37.800069752172604 | -122.44154398128299 | (37.8000697521726, -122.441543981283) | ||
| 51670 | 51670 | 181284 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 75 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6006132.8407 | 2093885.45886 | 37.7297577652023 | -122.421084877777 | (37.7297577652023, -122.421084877777) | ||||
| 52185 | 52185 | 246415 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3040 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007103.0157 | 2100696.7673 | 37.7485147512594 | -122.41821358836799 | (37.7485147512594, -122.418213588368) | |||
| 53512 | 53512 | 33314 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 18 | Permit Number 37460 | 6005325.69823 | 2120590.66128 | 37.803038340517396 | -122.425775331487 | (37.8030383405174, -122.425775331487) | |
| 53739 | 53739 | 107420 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 62 Naples St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 23 | 6004646.42863 | 2093164.0318599998 | 37.727692982045205 | -122.426172231973 | (37.7276929820452, -122.426172231973) | ||||
| 54015 | 54015 | 250212 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011360.92473 | 2120092.038 | 37.8020084404915 | -122.404855058325 | (37.8020084404915, -122.404855058325) | |||
| 54238 | 54238 | 181285 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 55 Stoneyford Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6006176.18741 | 2094039.87064 | 37.7301841895453 | -122.420945981966 | (37.7301841895453, -122.420945981966) | ||||
| 54279 | 54279 | 33558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2001 12:00:00 AM | 14 | Permit Number 37664 | 5996252.18034 | 2110425.94618 | 37.7746118487481 | -122.456438795749 | (37.7746118487481, -122.456438795749) | |
| 54749 | 54749 | 137504 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2521 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6007440.32409 | 2121045.18765 | 37.8044056238841 | -122.41848985342399 | (37.8044056238841, -122.418489853424) | |||
| 54820 | 54820 | 199491 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 991 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6010160.462780001 | 2112475.94927 | 37.7810293246804 | -122.408471707117 | (37.7810293246804, -122.408471707117) | |||
| 55472 | 55472 | 181221 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 577 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003118.4058300005 | 2090123.02436 | 37.719256567824104 | -122.43123765172199 | (37.7192565678241, -122.431237651722) | |||
| 55931 | 55931 | 181279 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 164 Otsego Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000580.61226 | 2092352.75488 | 37.725234756259105 | -122.440169631943 | (37.7252347562591, -122.440169631943) | ||||
| 55947 | 55947 | 203200 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013014.646919999 | 2107133.4042700003 | 37.76651933182929 | -122.398222657156 | (37.7665193318293, -122.398222657156) | |||
| 59002 | 59002 | 181991 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2492 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5987080.0862 | 2098302.9304 | 37.740794524211104 | -122.48727584365601 | (37.7407945242111, -122.487275843656) | |||
| 59728 | 59728 | 244843 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 9ft | 6006632.98295 | 2103729.04135 | 37.7568142125173 | -122.4200541162 | (37.7568142125173, -122.4200541162) | |||
| 60522 | 60522 | 247645 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6001626.8491400005 | 2108303.83597 | 37.7690921528084 | -122.437694773193 | (37.7690921528084, -122.437694773193) | |||
| 62394 | 62394 | 243927 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 183 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005367.86151 | 2099016.78698 | 37.7438040882932 | -122.424094272857 | (37.7438040882932, -122.424094272857) | |||
| 62584 | 62584 | 246277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2027 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6006848.1122 | 2106486.1456 | 37.764396697974796 | -122.419505718376 | (37.7643966979748, -122.419505718376) | |||
| 62711 | 62711 | 203188 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2212 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 9ft | 6012161.98551 | 2101908.2137 | 37.752124581703896 | -122.400804745651 | (37.7521245817039, -122.400804745651) | |||
| 62816 | 62816 | 244860 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 149 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009958.276269999 | 2099883.84977 | 37.746442961793 | -122.40828277213001 | (37.746442961793, -122.40828277213) | |||
| 63685 | 63685 | 84744 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015122.21866 | 2111558.9441 | 37.7787880531604 | -122.391242266936 | (37.7787880531604, -122.391242266936) | ||
| 65852 | 65852 | 243939 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 52 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 2ft | 6000277.85355 | 2106550.76339 | 37.7642018571482 | -122.44223499246401 | (37.7642018571482, -122.442234992464) | |||
| 66149 | 66149 | 181268 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1116 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011841.7145 | 2089718.86782 | 37.7186373306372 | -122.401055901109 | (37.7186373306372, -122.401055901109) | |||
| 67120 | 67120 | 217465 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 270 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991973.319019999 | 2090312.5132 | 37.719138962561395 | -122.469775446797 | (37.7191389625614, -122.469775446797) | |||
| 67531 | 67531 | 108537 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 400-422X Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6012472.22935 | 2086696.28114 | 37.710373062836794 | -122.39866445541 | (37.7103730628368, -122.39866445541) | ||||
| 67895 | 67895 | 203190 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1471 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012043.2307 | 2101521.0685 | 37.7510549406325 | -122.401188218373 | (37.7510549406325, -122.401188218373) | ||||
| 69461 | 69461 | 49325 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 16 | Permit Number 46321 | 6013241.30936 | 2110424.30224 | 37.7755680215912 | -122.397669511153 | (37.7755680215912, -122.397669511153) | ||
| 70487 | 70487 | 217481 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 47 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999774.01899 | 2095479.90508 | 37.7337752292392 | -122.443182429144 | (37.7337752292392, -122.443182429144) | |||
| 71965 | 71965 | 50023 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1704 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 9 | Permit Number 46757 | 6005976.3873 | 2092403.4615900002 | 37.7256797039307 | -122.421520544445 | (37.7256797039307, -122.421520544445) | |
| 72211 | 72211 | 28774 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4626 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001950.98602 | 2092007.07057 | 37.724363508667295 | -122.43540767631 | (37.7243635086673, -122.43540767631) | |||
| 72545 | 72545 | 247324 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2998 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6006942.8105 | 2106758.6304 | 37.765150210855204 | -122.419197512578 | (37.7651502108552, -122.419197512578) | |||
| 73403 | 73403 | 243919 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1203 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6009251.77945 | 2102094.62591 | 37.752473675130794 | -122.410881883003 | (37.7524736751308, -122.410881883003) | |||
| 74085 | 74085 | 218197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5993480.75094 | 2097837.1493599997 | 37.7398867790468 | -122.465111106706 | (37.7398867790468, -122.465111106706) | ||||
| 74492 | 74492 | 187444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5025 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000645.4005 | 2089706.7167 | 37.7179730245698 | -122.43975604576299 | (37.7179730245698, -122.439756045763) | |||
| 75551 | 75551 | 217473 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2007 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5993456.042669999 | 2101836.9547200003 | 37.7508678061099 | -122.465487029605 | (37.7508678061099, -122.465487029605) |
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");