Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13833 | 13833 | 95855 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010497.41028 | 2112077.91159 | 37.7799552706525 | -122.407277965014 | (37.7799552706525, -122.407277965014) | |||
| 14065 | 14065 | 95854 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010514.67057 | 2112059.04775 | 37.779904440962504 | -122.407216923546 | (37.7799044409625, -122.407216923546) | |||
| 17383 | 17383 | 15397 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2023 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006842.046 | 2106580.1715 | 37.7646545293596 | -122.41953337107799 | (37.7646545293596, -122.419533371078) | |||
| 17590 | 17590 | 15399 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2027 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006845.0791 | 2106513.4435 | 37.7644714807654 | -122.419518145883 | (37.7644714807654, -122.419518145883) | |||
| 17608 | 17608 | 15472 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2480 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006923.7988 | 2103940.4395 | 37.7574110439022 | -122.419063359319 | (37.7574110439022, -122.419063359319) | ||
| 17702 | 17702 | 15454 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006889.3715 | 2104582.8537 | 37.7591730259049 | -122.419227992101 | (37.7591730259049, -122.419227992101) | ||
| 18122 | 18122 | 15443 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2230 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006851.2872 | 2105349.6458 | 37.7612763139256 | -122.419414104618 | (37.7612763139256, -122.419414104618) | |||
| 18291 | 18291 | 15395 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2023 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006844.3209 | 2106537.7082 | 37.764538063234795 | -122.419522489923 | (37.7645380632348, -122.419522489923) | |||
| 18494 | 18494 | 15456 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2389 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6006956.5453 | 2104486.5788 | 37.758912460169505 | -122.418988843881 | (37.7589124601695, -122.418988843881) | |||
| 19316 | 19316 | 15543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2830 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 18 | 3X3 | 6007038.8586 | 2101864.2983 | 37.7517169147733 | -122.418518220595 | (37.7517169147733, -122.418518220595) | ||
| 19517 | 19517 | 15447 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2268 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006864.2573 | 2105151.4928 | 37.7607329624144 | -122.41935518891 | (37.7607329624144, -122.41935518891) | |||
| 19865 | 19865 | 15432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2128 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006812.3772 | 2105921.7678 | 37.7628450358121 | -122.419589270998 | (37.7628450358121, -122.419589270998) | |||
| 20054 | 20054 | 15449 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2290 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006865.6984 | 2105042.6887 | 37.7604342928211 | -122.41934248602502 | (37.7604342928211, -122.419342486025) | ||
| 20108 | 20108 | 15398 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2029 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006849.6288 | 2106465.6722 | 37.7643405682415 | -122.41949902025699 | (37.7643405682415, -122.419499020257) | |||
| 20301 | 20301 | 15438 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006822.465 | 2105789.9059 | 37.762483542066704 | -122.419545024984 | (37.7624835420667, -122.419545024984) | ||
| 20499 | 20499 | 31376 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 634 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2004 12:00:00 AM | 18 | 3x3 | Permit Number 34978 | 5991167.871719999 | 2099111.64976 | 37.7432525889424 | -122.47320092310301 | (37.7432525889424, -122.473200923103) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 44869 | 44869 | 199502 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1012 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6010449.4105 | 2111969.43782 | 37.7796547406221 | -122.40743636892 | (37.7796547406221, -122.40743636892) | |||
| 46634 | 46634 | 84745 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 18 | Permit No. 49304 | 6015113.5864699995 | 2111549.96085 | 37.7787629081139 | -122.39127150119499 | (37.7787629081139, -122.391271501195) | ||
| 48576 | 48576 | 181244 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 80 Blanken Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6011665.41223 | 2087374.1682099998 | 37.7121894208913 | -122.40150061225701 | (37.7121894208913, -122.401500612257) | |||
| 49321 | 49321 | 244833 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 3048 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6007096.09954 | 2100647.8514900003 | 37.7483800502086 | -122.41823403678998 | (37.7483800502086, -122.41823403679) | |||
| 51291 | 51291 | 100875 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 995 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6010609.42845 | 2112029.4559299997 | 37.7798284914364 | -122.406887026109 | (37.7798284914364, -122.406887026109) | ||||
| 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) | ||
| 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) | |
| 57434 | 57434 | 199481 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015507.548169999 | 2109003.40137 | 37.77179247697679 | -122.389730708003 | (37.7717924769768, -122.389730708003) | |||
| 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) | |||
| 68878 | 68878 | 199460 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015600.77794 | 2108970.35206 | 37.771706900189294 | -122.389405908858 | (37.7717069001893, -122.389405908858) | |||
| 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) | |||
| 77903 | 77903 | 25222 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1975 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993747.869419999 | 2092685.5092 | 37.7257570464481 | -122.463813701632 | (37.7257570464481, -122.463813701632) | ||
| 81528 | 81528 | 25268 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1770 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5994565.40331 | 2092391.5082200002 | 37.724996868228104 | -122.460966269529 | (37.7249968682281, -122.460966269529) | ||
| 82761 | 82761 | 28581 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 83511 | 83511 | 15402 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2035 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006860.91141 | 2106484.2261799998 | 37.764392148614505 | -122.41946131318501 | (37.7643921486145, -122.419461313185) | |||
| 83918 | 83918 | 28625 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1299 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 18 | 3X3 | 5996025.31382 | 2091881.53932 | 37.7236805140054 | -122.455882701682 | (37.7236805140054, -122.455882701682) | ||
| 84411 | 84411 | 678 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3323X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006894.8894879995 | 2102019.509041 | 37.7521349819704 | -122.41902709370001 | (37.7521349819704, -122.4190270937) | |||
| 85226 | 85226 | 28451 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1931 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993990.72994 | 2092568.10284 | 37.725448669232605 | -122.462965643186 | (37.7254486692326, -122.462965643186) | ||
| 87014 | 87014 | 28580 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 87403 | 87403 | 28607 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 18 | 3X3 | 5995745.87048 | 2091965.2251799998 | 37.723894253245895 | -122.456854733097 | (37.7238942532459, -122.456854733097) | ||
| 88145 | 88145 | 28395 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994199.42088 | 2092532.99697 | 37.725364295675995 | -122.462241677747 | (37.725364295676, -122.462241677747) | ||
| 89453 | 89453 | 28583 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 89640 | 89640 | 28591 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5995836.7436481 | 2092012.5698365 | 37.7240294680883 | -122.45654402330901 | (37.7240294680883, -122.456544023309) | ||
| 90307 | 90307 | 87716 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1490 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 3x4 | 5995451.1237 | 2092197.4835700002 | 37.724515049874505 | -122.457890417782 | (37.7245150498745, -122.457890417782) | ||
| 93041 | 93041 | 619 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3146 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 18 | 3x3 | 6008066.00463 | 2102184.1145200003 | 37.752652829489705 | -122.414988836945 | (37.7526528294897, -122.414988836945) | ||
| 96271 | 96271 | 28480 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2127 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993065.7807 | 2093038.61214 | 37.7266872508023 | -122.466197260481 | (37.7266872508023, -122.466197260481) | ||
| 97244 | 97244 | 87718 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1405X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4x4 | 5995623.94864 | 2092020.8189400001 | 37.724039898691004 | -122.457280214367 | (37.724039898691, -122.457280214367) | ||
| 97375 | 97375 | 25262 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1712 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994776.63019 | 2092332.44962 | 37.724846859825895 | -122.46023180975901 | (37.7248468598259, -122.460231809759) | ||
| 97655 | 97655 | 87715 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1490 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4x3 | 5995451.1237 | 2092197.4835700002 | 37.724515049874505 | -122.457890417782 | (37.7245150498745, -122.457890417782) | ||
| 98043 | 98043 | 637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 3205 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1991 12:00:00 AM | 18 | 3X3 | 6007653.0 | 2102067.0 | 37.7523080428222 | -122.41640878881701 | (37.7523080428222, -122.416408788817) | ||
| 99556 | 99556 | 679 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3323X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006894.8894879995 | 2102019.509041 | 37.7521349819704 | -122.41902709370001 | (37.7521349819704, -122.4190270937) | |||
| 100260 | 100260 | 28408 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1649 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994840.68599 | 2092241.1236 | 37.724599784912 | -122.460003765056 | (37.724599784912, -122.460003765056) | ||
| 100682 | 100682 | 28407 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1649 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994828.46401 | 2092243.5478700001 | 37.7246057384269 | -122.460046190114 | (37.7246057384269, -122.460046190114) | ||
| 101268 | 101268 | 28418 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1942 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993852.42214 | 2092713.3110099998 | 37.7258394078668 | -122.463454290216 | (37.7258394078668, -122.463454290216) | ||
| 101404 | 101404 | 28450 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1933 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 18 | 3X3 | 5993979.747380001 | 2092573.4533099998 | 37.7254627277081 | -122.463003996644 | (37.7254627277081, -122.463003996644) | ||
| 102619 | 102619 | 28582 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 103297 | 103297 | 28477 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2159X Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5992865.63839 | 2093261.95996 | 37.7272889595155 | -122.46690537001601 | (37.7272889595155, -122.466905370016) | ||
| 104996 | 104996 | 28405 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1735 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994613.7507 | 2092228.8598200001 | 37.724553056880296 | -122.46078735712 | (37.7245530568803, -122.46078735712) | ||
| 105853 | 105853 | 28478 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2159X Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5992874.48639 | 2093252.14618 | 37.7272625239656 | -122.46687406965 | (37.7272625239656, -122.46687406965) | ||
| 105855 | 105855 | 667 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3297X 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/1992 12:00:00 AM | 18 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | ||
| 106224 | 106224 | 28592 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1338 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 4X4 | 5995676.5171 | 2092067.1693 | 37.7241701848162 | -122.457101845697 | (37.7241701848162, -122.457101845697) | ||
| 106919 | 106919 | 15440 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2224 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006834.95821 | 2105372.78301 | 37.7613389236012 | -122.419472221327 | (37.7613389236012, -122.419472221327) | ||
| 111111 | 111111 | 25275 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994210.04485 | 2092528.0363900003 | 37.725351286848394 | -122.462204592351 | (37.7253512868484, -122.462204592351) | ||
| 115639 | 115639 | 666 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3297X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/1992 12:00:00 AM | 18 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) | ||
| 116359 | 116359 | 28593 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1344 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 3x3 | 5995646.9889 | 2092076.7179900003 | 37.7241947074129 | -122.457204610061 | (37.7241947074129, -122.457204610061) | ||
| 117641 | 117641 | 15428 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2109 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1994 12:00:00 AM | 18 | 3X3 | 6006867.61446 | 2106023.64726 | 37.7631278842618 | -122.419405452183 | (37.7631278842618, -122.419405452183) | ||
| 117717 | 117717 | 28609 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1117 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5996444.46775 | 2091779.60617 | 37.723424677500205 | -122.454426406995 | (37.7234246775002, -122.454426406995) | ||
| 119225 | 119225 | 28631 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1051 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5x5 | 5996604.51775 | 2091735.3595900002 | 37.7233123645372 | -122.45386995284099 | (37.7233123645372, -122.453869952841) | ||
| 120120 | 120120 | 28479 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2127 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 3x3 | 5993065.7807 | 2093038.61214 | 37.7266872508023 | -122.466197260481 | (37.7266872508023, -122.466197260481) | ||
| 120536 | 120536 | 28419 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1942 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 3X3 | 5993841.789969999 | 2092731.1764 | 37.7258878492945 | -122.463492340527 | (37.7258878492945, -122.463492340527) | ||
| 122285 | 122285 | 87719 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1405X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 5995623.94864 | 2092020.8189400001 | 37.724039898691004 | -122.457280214367 | (37.724039898691, -122.457280214367) | |||
| 122736 | 122736 | 28400 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1801 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994353.33294 | 2092393.96345 | 37.7249914043353 | -122.461699545917 | (37.7249914043353, -122.461699545917) | ||
| 124610 | 124610 | 28406 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1735 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994613.7507 | 2092228.8598200001 | 37.724553056880296 | -122.46078735712 | (37.7245530568803, -122.46078735712) | ||
| 127723 | 127723 | 28596 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1712 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5994768.91993 | 2092335.30302 | 37.724854251069395 | -122.46025866967501 | (37.7248542510694, -122.460258669675) | ||
| 128162 | 128162 | 28610 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1107 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 5X5 | 5996451.82773 | 2091748.4966099998 | 37.7233396801105 | -122.45439871889799 | (37.7233396801105, -122.454398718898) | ||
| 139974 | 139974 | 28632 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1051 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2003 12:00:00 AM | 18 | 5X5 | 5996612.56003 | 2091733.27597 | 37.723307104505295 | -122.453842001957 | (37.7233071045053, -122.453842001957) | ||
| 141877 | 141877 | 28584 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1150 Ocean Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 3X3 | 5996037.5543 | 2091961.1786900002 | 37.72389988729329 | -122.455846143025 | (37.7238998872933, -122.455846143025) | ||
| 142630 | 142630 | 28401 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1801 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994365.43766 | 2092389.56598 | 37.7249800267364 | -122.46165738286001 | (37.7249800267364, -122.46165738286) | ||
| 142832 | 142832 | 25269 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1770 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994556.12855 | 2092394.0919599999 | 37.725003428856 | -122.460998518302 | (37.725003428856, -122.460998518302) | ||
| 143878 | 143878 | 28445 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1975 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993756.7813099995 | 2092682.5740099999 | 37.725749500685 | -122.463782681191 | (37.725749500685, -122.463782681191) | ||
| 152407 | 152407 | 203210 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6013290.0727699995 | 2107397.08786 | 37.7672586860712 | -122.397288494465 | (37.7672586860712, -122.397288494465) | |||
| 155111 | 155111 | 244859 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 149 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009972.47509 | 2099891.7648 | 37.746465489806496 | -122.408234232143 | (37.7464654898065, -122.408234232143) | |||
| 156009 | 156009 | 102420 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 101 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6010175.35097 | 2112415.36622 | 37.780863811667295 | -122.408415926663 | (37.7808638116673, -122.408415926663) | |||
| 163780 | 163780 | 199471 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015471.47006 | 2109635.49599 | 37.773526068606294 | -122.389899666361 | (37.7735260686063, -122.389899666361) | |||
| 168704 | 168704 | 199467 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015455.2503 | 2109935.9180799997 | 37.774350061636795 | -122.389976763437 | (37.7743500616368, -122.389976763437) | |||
| 173007 | 173007 | 199449 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015644.40714 | 2108197.8403 | 37.769588171184296 | -122.3892010406 | (37.7695881711843, -122.3892010406) | |||
| 175604 | 175604 | 203184 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 Arkansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6012812.5292 | 2106977.67983 | 37.766080486952795 | -122.398910820196 | (37.7660804869528, -122.398910820196) | |||
| 183818 | 183818 | 124559 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995921.75191 | 2113853.09729 | 37.7840029226817 | -122.45782985493 | (37.7840029226817, -122.45782985493) | |||
| 184524 | 184524 | 199454 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015626.42459 | 2108505.26742 | 37.7704313017932 | -122.38928471262 | (37.7704313017932, -122.38928471262) | |||
| 184841 | 184841 | 199445 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015653.75387 | 2108031.46585 | 37.769131861479394 | -122.38915709163 | (37.7691318614794, -122.38915709163) | |||
| 184973 | 184973 | 62210 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 18 | Permit Number 22332 | 6000793.821959999 | 2093620.4443599998 | 37.7287276772231 | -122.439523423176 | (37.7287276772231, -122.439523423176) |
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");