Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 181853 | 181853 | 201499 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6018416.79538 | 2095102.4725900001 | 37.7337842710237 | -122.37870189547701 | (37.7337842710237, -122.378701895477) | ||||
| 87949 | 87949 | 96848 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 1486 Innes Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 6016133.4 | 2096820.6 | 37.7383757570157 | -122.386716118251 | (37.7383757570157, -122.386716118251) | ||||||
| 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) | |||
| 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) | |||
| 61712 | 61712 | 203182 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015656.28581 | 2106435.78787 | 37.7647506171774 | -122.38903690803998 | (37.7647506171774, -122.38903690804) | |||
| 153721 | 153721 | 203181 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015653.76081 | 2106475.1848299997 | 37.7648586527362 | -122.389048392363 | (37.7648586527362, -122.389048392363) | |||
| 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) | |||
| 16634 | 16634 | 21880 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015651.4577 | 2106526.92513 | 37.765000592730395 | -122.389059971145 | (37.7650005927304, -122.389059971145) | ||
| 59290 | 59290 | 199446 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6015650.90558 | 2108071.91419 | 37.7692427658814 | -122.38916976848199 | (37.7692427658814, -122.389169768482) | |||
| 149287 | 149287 | 199447 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015650.089459999 | 2108116.21417 | 37.7693643586962 | -122.389175685108 | (37.7693643586962, -122.389175685108) | |||
| 14750 | 14750 | 21878 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015649.24797 | 2106571.51851 | 37.765122914002205 | -122.389070727941 | (37.7651229140022, -122.389070727941) | ||
| 156855 | 156855 | 199448 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1515 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015646.98681 | 2108156.1809400003 | 37.7694739267051 | -122.389189208225 | (37.7694739267051, -122.389189208225) | |||
| 14545 | 14545 | 21876 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 3 | 3X3 | 6015645.96934 | 2106615.37755 | 37.7652431596794 | -122.389085130597 | (37.7652431596794, -122.389085130597) | ||
| 15554 | 15554 | 21874 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015644.57338 | 2106657.85439 | 37.7653597144938 | -122.38909292500901 | (37.7653597144938, -122.389092925009) | ||
| 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) | |||
| 13825 | 13825 | 21872 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015641.71858 | 2106711.03714 | 37.7655055845439 | -122.38910651286601 | (37.7655055845439, -122.389106512866) | ||
| 16399 | 16399 | 21870 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015638.72465 | 2106753.7729 | 37.765622761707604 | -122.38911985249399 | (37.7656227617076, -122.389119852494) | ||
| 132521 | 132521 | 199450 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1455 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015636.18722 | 2108347.40225 | 37.7699983798625 | -122.389239918305 | (37.7699983798625, -122.389239918305) | |||
| 173828 | 173828 | 199451 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1455 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6015633.06498 | 2108386.39567 | 37.77010527416 | -122.389253441416 | (37.77010527416, -122.389253441416) | |||
| 167534 | 167534 | 199452 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015631.41317 | 2108425.60277 | 37.7702128366907 | -122.38926189323799 | (37.7702128366907, -122.389261893238) | |||
| 16861 | 16861 | 21868 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015630.42851 | 2106799.74819 | 37.7657485399863 | -122.38915175774599 | (37.7657485399863, -122.389151757746) | ||
| 52239 | 52239 | 199453 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015629.79574 | 2108466.51232 | 37.7703250756792 | -122.389270345061 | (37.7703250756792, -122.389270345061) | |||
| 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) | |||
| 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) | |||
| 15167 | 15167 | 21867 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/2008 12:00:00 AM | 3 | 3X3 | 6015621.91024 | 2106888.57721 | 37.765991972979606 | -122.389187423983 | (37.7659919729796, -122.389187423983) | ||
| 15971 | 15971 | 21858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1830 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6015621.795940001 | 2107069.76565 | 37.7664894707397 | -122.389200472218 | (37.7664894707397, -122.389200472218) | ||
| 13652 | 13652 | 21866 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015620.2045 | 2106919.86703 | 37.766077793471396 | -122.38919550889099 | (37.7660777934714, -122.389195508891) | ||
| 13848 | 13848 | 21865 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015619.46662 | 2106949.47478 | 37.7661590490173 | -122.38920012868601 | (37.7661590490173, -122.389200128686) | ||
| 149340 | 149340 | 203180 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1800 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015618.5764 | 2107110.17004 | 37.7666002339304 | -122.38921442971399 | (37.7666002339304, -122.389214429714) | |||
| 177566 | 177566 | 203179 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1800 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015617.1468 | 2107140.95711 | 37.7666846892774 | -122.38922152448099 | (37.7666846892774, -122.389221524481) | |||
| 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) | |||
| 64963 | 64963 | 199457 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015609.11002 | 2108848.45381 | 37.7713726563476 | -122.389368573515 | (37.7713726563476, -122.389368573515) | |||
| 77203 | 77203 | 199458 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6015604.63296 | 2108887.78773 | 37.77148041042871 | -122.389386807278 | (37.7714804104287, -122.389386807278) | |||
| 157503 | 157503 | 199466 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015602.95639 | 2107310.9230400003 | 37.7671505920487 | -122.38928247692499 | (37.7671505920487, -122.389282476925) | |||
| 65089 | 65089 | 199459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015601.45578 | 2108929.3451900003 | 37.7715943419254 | -122.389400699999 | (37.7715943419254, -122.389400699999) | |||
| 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) | |||
| 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) | |||
| 56235 | 56235 | 199464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015598.48485 | 2107402.1848299997 | 37.7674009291493 | -122.389304316962 | (37.7674009291493, -122.389304316962) | |||
| 148816 | 148816 | 199461 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015597.30963 | 2109009.9155099997 | 37.7718153404253 | -122.389420669423 | (37.7718153404253, -122.389420669423) | |||
| 91617 | 91617 | 121443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 104061 | 104061 | 121442 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 110672 | 110672 | 121440 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 115552 | 115552 | 121441 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 126644 | 126644 | 121439 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1750 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6015597.0 | 2107388.0 | 37.767361898376606 | -122.389308462256 | (37.7673618983766, -122.389308462256) | ||||
| 44421 | 44421 | 199463 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1530 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015595.21944 | 2107438.50948 | 37.7675004876899 | -122.38931814851999 | (37.7675004876899, -122.38931814852) | |||
| 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) | |||
| 164636 | 164636 | 199489 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1500 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015558.23281 | 2108115.16925 | 37.7693563969951 | -122.389493342767 | (37.7693563969951, -122.389493342767) | |||
| 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) | |||
| 65873 | 65873 | 199487 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015516.37079 | 2108841.48357 | 37.7713483755645 | -122.38968887873399 | (37.7713483755645, -122.389688878734) | |||
| 131078 | 131078 | 199486 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015515.33955 | 2108860.86593 | 37.771401538077704 | -122.389693799846 | (37.7714015380777, -122.389693799846) | |||
| 63273 | 63273 | 199485 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015513.12326 | 2108880.27223 | 37.7714547006117 | -122.389702821822 | (37.7714547006117, -122.389702821822) | |||
| 177521 | 177521 | 199484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015511.156140001 | 2108923.75767 | 37.7715739929801 | -122.38971266400401 | (37.7715739929801, -122.389712664004) | |||
| 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) | |||
| 149805 | 149805 | 199482 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015508.8068699995 | 2108983.54244 | 37.7717380185256 | -122.38972496674 | (37.7717380185256, -122.38972496674) | |||
| 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) | |||
| 175922 | 175922 | 199480 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015500.51903 | 2109136.7123 | 37.7721581296349 | -122.389764335453 | (37.7721581296349, -122.389764335453) | |||
| 156118 | 156118 | 199479 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015497.26335 | 2109186.83428 | 37.772295573003895 | -122.389779098738 | (37.7722955730039, -122.389779098738) | |||
| 167263 | 167263 | 199478 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015495.305819999 | 2109230.7911799997 | 37.7724161604052 | -122.38978894091801 | (37.7724161604052, -122.389788940918) | |||
| 151765 | 151765 | 199477 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015494.09745 | 2109276.6214799997 | 37.772541933290206 | -122.389796322564 | (37.7725419332902, -122.389796322564) | |||
| 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) | |||
| 152448 | 152448 | 199475 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1240 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015486.6604 | 2109366.2584700002 | 37.7727876442643 | -122.38982831052799 | (37.7727876442643, -122.389828310528) | |||
| 189141 | 189141 | 199474 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015480.23631 | 2109482.55519 | 37.7731066131226 | -122.389858657266 | (37.7731066131226, -122.389858657266) | |||
| 132921 | 132921 | 199473 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6015478.1467 | 2109531.70871 | 37.7732414619454 | -122.389869319627 | (37.7732414619454, -122.389869319627) | |||
| 156279 | 156279 | 199472 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015475.23167 | 2109575.21201 | 37.7733607507341 | -122.389882442542 | (37.7733607507341, -122.389882442542) | |||
| 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) | |||
| 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) | |||
| 77197 | 77197 | 199469 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6015461.94108 | 2109832.83992 | 37.7740674029079 | -122.389946416702 | (37.7740674029079, -122.389946416702) | |||
| 66564 | 66564 | 199468 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6015459.06425 | 2109878.23066 | 37.77419187628129 | -122.38995953961799 | (37.7741918762813, -122.389959539618) | |||
| 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) | |||
| 184842 | 184842 | 203176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015380.59839 | 2102345.27771 | 37.753503666864205 | -122.38970472391199 | (37.7535036668642, -122.389704723912) | ||||
| 51983 | 51983 | 203178 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6015363.87101 | 2102334.663 | 37.75347359354279 | -122.38976182994 | (37.7534735935428, -122.38976182994) | ||||
| 174438 | 174438 | 203177 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6015358.55131 | 2102374.09965 | 37.7535815832452 | -122.38978298111401 | (37.7535815832452, -122.389782981114) | ||||
| 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) | ||
| 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) | ||
| 75228 | 75228 | 84746 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 22 | Permit No. 49304 | 6015095.84023 | 2111532.74661 | 37.778714656793 | -122.391331689209 | (37.778714656793, -122.391331689209) | ||
| 47057 | 47057 | 84747 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 19 | Permit No. 49304 | 6015084.20168 | 2111522.58673 | 37.7786861141091 | -122.391371241385 | (37.7786861141091, -122.391371241385) | ||
| 154180 | 154180 | 84748 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 20 | Permit No. 49304 | 6015067.98121 | 2111507.0743 | 37.7786426202078 | -122.391426270004 | (37.7786426202078, -122.391426270004) | ||
| 165043 | 165043 | 84749 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 21 | Permit No. 49304 | 6015056.82948 | 2111496.40969 | 37.7786127186366 | -122.391464102698 | (37.7786127186366, -122.391464102698) | ||
| 17840 | 17840 | 105162 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X OAKDALE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6015006.0 | 2095503.0 | 37.734695414582795 | -122.390522107646 | (37.7346954145828, -122.390522107646) | |||
| 9740 | 9740 | 173671 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 9752 | 9752 | 173678 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 75 | 299x Beale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 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) | |||
| 43216 | 43216 | 203186 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 25th St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014234.68411 | 2101965.33677 | 37.752396820871894 | -122.393640982742 | (37.7523968208719, -122.393640982742) | ||||
| 156331 | 156331 | 202029 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1331 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 7ft | 6013954.19623 | 2091006.8516900002 | 37.7222914964254 | -122.39384396154199 | (37.7222914964254, -122.393843961542) | |||
| 47352 | 47352 | 203175 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2338 Lane St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6013915.08418 | 2092868.40903 | 37.7274007851107 | -122.394109422506 | (37.7274007851107, -122.394109422506) | ||||
| 42207 | 42207 | 203193 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 47 Ceres St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6013909.9694300005 | 2093925.2511200001 | 37.7303023748506 | -122.39420106345301 | (37.7303023748506, -122.394201063453) | |||
| 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) | |||
| 161827 | 161827 | 203197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 10ft | 6013808.49559 | 2116854.49545 | 37.7932554199655 | -122.39615821213499 | (37.7932554199655, -122.396158212135) | |||
| 165364 | 165364 | 203196 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 10ft | 6013792.252169999 | 2116838.17263 | 37.7932096975269 | -122.39621327133301 | (37.7932096975269, -122.396213271333) | |||
| 171005 | 171005 | 203191 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 242 Texas St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 3ft | 6013713.77325 | 2105932.1269099996 | 37.7632598065236 | -122.395720307939 | (37.7632598065236, -122.395720307939) | |||
| 71109 | 71109 | 199442 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013442.0065 | 2107543.23317 | 37.7676684261738 | -122.396773220723 | (37.7676684261738, -122.396773220723) | |||
| 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) | |||
| 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) | |||
| 68422 | 68422 | 199439 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013405.93741 | 2107506.73149 | 37.7675661930534 | -122.396895420613 | (37.7675661930534, -122.396895420613) | |||
| 155690 | 155690 | 199438 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013354.61019 | 2107458.2254 | 37.767430148995295 | -122.39706955454099 | (37.7674301489953, -122.397069554541) | |||
| 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) | |||
| 174835 | 174835 | 199436 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013326.10031 | 2107431.53826 | 37.767355284933 | -122.39716629548599 | (37.767355284933, -122.397166295486) | |||
| 161570 | 161570 | 203212 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 189 Hubbell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6013314.65603 | 2107418.8705599997 | 37.7673198651342 | -122.397204991541 | (37.7673198651342, -122.397204991541) | |||
| 72808 | 72808 | 203199 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 690 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6013299.63411 | 2110362.29852 | 37.77540102106779 | -122.397463400913 | (37.7754010210678, -122.397463400913) |
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");