Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115800 | 115800 | 68553 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 724 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | Permit Number 32442 | 5982311.44586787 | 2110822.57803578 | 37.7748906946614 | -122.50469113477 | (37.7748906946614, -122.50469113477) | ||
| 131108 | 131108 | 63003 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1239 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 3 | Permit Number 23411 | 5983024.3565 | 2106665.5091 | 37.763518489811 | -122.501917412441 | (37.763518489811, -122.501917412441) | ||
| 186544 | 186544 | 63000 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.763284575331795 | -122.50189769196899 | (37.7632845753318, -122.501897691969) | ||
| 68623 | 68623 | 63086 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1209 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1986 12:00:00 AM | 3 | Permit Number 23570 | 5983326.3714 | 2106866.623 | 37.7640884282736 | -122.500887729919 | (37.7640884282736, -122.500887729919) | ||
| 57958 | 57958 | 183317 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1209 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983329.0993 | 2106834.4338 | 37.7640002060456 | -122.50087591440399 | (37.7640002060456, -122.500875914404) | |||
| 114985 | 114985 | 69148 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2478 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33183 | 5983358.82084368 | 2098279.8149921 | 37.7405133500226 | -122.500140666527 | (37.7405133500226, -122.500140666527) | ||
| 107739 | 107739 | 61351 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2435 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33180 | 5983606.72733818 | 2098575.39773775 | 37.741339486665396 | -122.499305352528 | (37.7413394866654, -122.499305352528) | ||
| 72290 | 72290 | 82688 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1875 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51093 | 5984404.185 | 2102433.03 | 37.7519782422196 | -122.496832705614 | (37.7519782422196, -122.496832705614) | |
| 173302 | 173302 | 183679 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.49699886391899 | (37.7626128114068, -122.496998863919) | |||
| 173694 | 173694 | 95910 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.75246795898221 | -122.49039681822201 | (37.7524679589822, -122.490396818222) |
| 50581 | 50581 | 38530 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | ||
| 29378 | 29378 | 95906 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1323 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767607 | 5987385.7768 | 2106255.5896 | 37.7626482044987 | -122.486802739667 | (37.7626482044987, -122.486802739667) |
| 55179 | 55179 | 184366 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | |||
| 124193 | 124193 | 43803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 762 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | Permit Number 43433 | 5988853.6653409 | 2110130.11231626 | 37.7733720498685 | -122.48200974609699 | (37.7733720498685, -122.482009746097) | ||
| 180708 | 180708 | 65972 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.74864775647529 | -122.480306841406 | (37.7486477564753, -122.480306841406) | |
| 184245 | 184245 | 50918 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | |
| 58192 | 58192 | 31751 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | |
| 73002 | 73002 | 31750 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | |
| 25343 | 25343 | 183040 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | |||
| 174016 | 174016 | 65967 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | |
| 34651 | 34651 | 31752 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.738429077279896 | -122.47743975125601 | (37.7384290772799, -122.477439751256) | |
| 160564 | 160564 | 31753 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2642 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35239 | 5989905.4007 | 2097364.9943 | 37.738383545459 | -122.477438539611 | (37.738383545459, -122.477438539611) | |
| 69957 | 69957 | 98409 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 55 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | |||||
| 137065 | 137065 | 182595 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 955 Rivera St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990177.9035 | 2100379.6188 | 37.746676731738894 | -122.4767165565 | (37.7466767317389, -122.4767165565) | |||
| 42406 | 42406 | 182596 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.746680511997496 | -122.47664737488998 | (37.7466805119975, -122.47664737489) | |||
| 99443 | 99443 | 60142 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1600 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/13/1997 12:00:00 AM | Permit Number 19672 | 5990905.68098297 | 2104491.51831194 | 37.7580091169986 | -122.474500032297 | (37.7580091169986, -122.474500032297) | ||
| 50270 | 50270 | 206508 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990927.20691 | 2104481.04629 | 37.7579816107755 | -122.474424823051 | (37.7579816107755, -122.474424823051) | |||
| 116961 | 116961 | 68613 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.75205353684021 | -122.474266156198 | (37.7520535368402, -122.474266156198) | ||
| 143418 | 143418 | 68621 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.47423624838899 | (37.7516236388925, -122.474236248389) | ||
| 153105 | 153105 | 206509 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.75798161076639 | -122.47438420248501 | (37.7579816107664, -122.474384202485) | |||
| 55765 | 55765 | 206510 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.757981610781606 | -122.474340288587 | (37.7579816107816, -122.474340288587) | |||
| 160435 | 160435 | 206511 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.757983346478795 | -122.474289787164 | (37.7579833464788, -122.474289787164) | |||
| 36423 | 36423 | 206512 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990980.22345 | 2104481.19226 | 37.7579850830548 | -122.47424148188401 | (37.7579850830548, -122.474241481884) | |||
| 119103 | 119103 | 206513 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | |||
| 113954 | 113954 | 65803 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28771 | 5991002.61160286 | 2100125.98772668 | 37.7460281288142 | -122.4738463283 | (37.7460281288142, -122.4738463283) | ||
| 20614 | 20614 | 65804 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.47384127538099 | (37.7459566686168, -122.473841275381) | ||
| 171944 | 171944 | 206514 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1023 Lawton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5991006.3222 | 2104484.4348 | 37.7579954981234 | -122.47415145883801 | (37.7579954981234, -122.474151458838) | |||
| 176247 | 176247 | 206515 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5991033.61709 | 2104484.17502 | 37.7579963659675 | -122.47405704351601 | (37.7579963659675, -122.474057043516) | |||
| 126800 | 126800 | 65799 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.746750736934295 | -122.473717291816 | (37.7467507369343, -122.473717291816) | ||
| 153437 | 153437 | 206522 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.47370838535801 | (37.7465686447317, -122.473708385358) | |||
| 171652 | 171652 | 206516 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991047.261080001 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | |||
| 181904 | 181904 | 206517 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5991060.290580001 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | |||
| 126746 | 126746 | 206518 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1019 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5991072.98938 | 2104484.60902 | 37.7579998382313 | -122.473920910448 | (37.7579998382313, -122.473920910448) | |||
| 111681 | 111681 | 81908 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50503 | 5991112.7626616 | 2104504.97362674 | 37.7580580577361 | -122.47378484453999 | (37.7580580577361, -122.47378484454) | ||
| 139629 | 139629 | 68592 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | ||
| 140639 | 140639 | 68598 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.47300685208599 | (37.7520016305294, -122.473006852086) | ||
| 75714 | 75714 | 206568 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991380.56657 | 2098286.2467799997 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | |||
| 185359 | 185359 | 206567 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991381.7608900005 | 2098233.80223 | 37.74085462674589 | -122.472397375252 | (37.7408546267459, -122.472397375252) | |||
| 74063 | 74063 | 31296 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 431 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34940 | 5991578.61319 | 2097704.4347 | 37.7394125098801 | -122.47167817211201 | (37.7394125098801, -122.471678172112) | |
| 106193 | 106193 | 47123 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.753887161855104 | -122.47200398758899 | (37.7538871618551, -122.472003987589) | ||
| 114879 | 114879 | 31913 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2281 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42222 | 5991689.25479737 | 2099914.99470572 | 37.7454885429424 | -122.471456657987 | (37.7454885429424, -122.471456657987) | ||
| 36017 | 36017 | 31915 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2287 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1996 12:00:00 AM | 4 | Permit Number 35339 | 5991692.93382 | 2099879.32999 | 37.745390829638 | -122.471441338374 | (37.745390829638, -122.471441338374) | |
| 62392 | 62392 | 206521 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991723.002619999 | 2099864.63418 | 37.7453522181485 | -122.471336295754 | (37.7453522181485, -122.471336295754) | |||
| 66610 | 66610 | 206520 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991725.72943 | 2099875.90905 | 37.7453833337792 | -122.47132768833099 | (37.7453833337792, -122.471327688331) | |||
| 121441 | 121441 | 65810 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28778 | 5991729.56779327 | 2099841.10556299 | 37.7452879943861 | -122.471311880679 | (37.7452879943861, -122.471311880679) | ||
| 65033 | 65033 | 31914 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2286 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 4 | Permit Number 42223 | 5991731.014359999 | 2099907.3159 | 37.7454698746265 | -122.471311701978 | (37.7454698746265, -122.471311701978) | |
| 51810 | 51810 | 206519 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991734.05463 | 2099933.45812 | 37.7455418303067 | -122.471303093689 | (37.7455418303067, -122.471303093689) | |||
| 35057 | 35057 | 31228 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2651 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34914 | 5991736.03785 | 2097377.43168 | 37.738523749481104 | -122.47111005511002 | (37.7385237494811, -122.47111005511) | |
| 75089 | 75089 | 206565 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991740.0000599995 | 2097213.7223099996 | 37.7380744742606 | -122.471084432514 | (37.7380744742606, -122.471084432514) | |||
| 125632 | 125632 | 65811 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28799 | 5991740.53584922 | 2099906.37764585 | 37.7454678491967 | -122.471278710139 | (37.7454678491967, -122.471278710139) | ||
| 186945 | 186945 | 206566 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991741.264830001 | 2097200.972 | 37.738039538296206 | -122.471079130991 | (37.7380395382962, -122.471079130991) | |||
| 132461 | 132461 | 206523 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | |||
| 97044 | 97044 | 68702 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 178 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32614 | 5991836.89762768 | 2114262.80781602 | 37.7848923529415 | -122.471991698628 | (37.7848923529415, -122.471991698628) | ||
| 171063 | 171063 | 206569 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2435 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992009.07535 | 2098867.5883299997 | 37.7426311295378 | -122.47027451837099 | (37.7426311295378, -122.470274518371) | |||
| 84031 | 84031 | 40752 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.726553703659995 | -122.46791340088001 | (37.72655370366, -122.46791340088) | ||
| 84739 | 84739 | 40751 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.726553703659995 | -122.46791340088001 | (37.72655370366, -122.46791340088) | ||
| 141520 | 141520 | 35070 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | ||
| 74719 | 74719 | 206524 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.742716096581894 | -122.467054169341 | (37.7427160965819, -122.467054169341) | |||
| 26843 | 26843 | 206525 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992946.5083 | 2098897.01812 | 37.7427660898953 | -122.46703531413 | (37.7427660898953, -122.46703531413) | |||
| 50429 | 50429 | 206526 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.742811698104205 | -122.467010912843 | (37.7428116981042, -122.467010912843) | |||
| 132226 | 132226 | 206527 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992983.90563 | 2098997.49136 | 37.7430441224891 | -122.46691330850099 | (37.7430441224891, -122.466913308501) | |||
| 50360 | 50360 | 206528 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992986.65204 | 2099006.05822 | 37.7430678034305 | -122.466904434898 | (37.7430678034305, -122.466904434898) | |||
| 148248 | 148248 | 206529 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992989.732419999 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | |||
| 249 | 249 | 251254 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 330 09th Ave | 1 | unknown : Cutout 12 | Tree 1 | MTA 6 | 3x3 | 5993109.0 | 2113253.0 | 37.782193225103605 | -122.467517213871 | (37.7821932251036, -122.467517213871) | ||||
| 167733 | 167733 | 206503 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.751788644440495 | -122.46662048837 | (37.7517886444405, -122.46662048837) | |||
| 26518 | 26518 | 206504 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1959 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993136.05327 | 2102151.01657 | 37.7517116786758 | -122.46661639913602 | (37.7517116786758, -122.466616399136) | |||
| 28309 | 28309 | 206505 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993138.76599 | 2102124.2403700002 | 37.7516383146611 | -122.46660507218701 | (37.7516383146611, -122.466605072187) | |||
| 33381 | 33381 | 206506 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993143.71774 | 2101970.98373 | 37.7512177970674 | -122.46657681008301 | (37.7512177970674, -122.466576810083) | |||
| 137122 | 137122 | 206507 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1985 10th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5993144.62205 | 2101960.97627 | 37.751190371338 | -122.46657295558599 | (37.751190371338, -122.466572955586) | |||
| 189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) | |||
| 64939 | 64939 | 206563 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2047 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993157.06576 | 2101533.95115 | 37.750018588 | -122.466498890138 | (37.750018588, -122.466498890138) | |||
| 132401 | 132401 | 206621 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993175.256709999 | 2102431.1044799997 | 37.7524829903015 | -122.46650118519301 | (37.7524829903015, -122.466501185193) | |||
| 49647 | 49647 | 206622 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.752445798858396 | -122.466499759777 | (37.7524457988584, -122.466499759777) | |||
| 44510 | 44510 | 218322 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.745697098249394 | -122.466270063011 | (37.7456970982494, -122.466270063011) | |||
| 83006 | 83006 | 68501 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1968 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32378 | 5993191.21227254 | 2102085.73019228 | 37.751535602028206 | -122.46642090906602 | (37.7515356020282, -122.466420909066) | ||
| 23989 | 23989 | 206572 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | |||
| 56319 | 56319 | 206573 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | |||
| 40559 | 40559 | 206571 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993219.180819999 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | |||
| 62866 | 62866 | 206570 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 4 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993230.1067699995 | 2099675.67045 | 37.7449204374235 | -122.46611129043 | (37.7449204374235, -122.46611129043) | |||
| 66424 | 66424 | 206580 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993286.92729 | 2099684.15258 | 37.7449470052046 | -122.46591543334401 | (37.7449470052046, -122.465915433344) | |||
| 133199 | 133199 | 206579 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257004 | -122.46587337656601 | (37.744949720257, -122.465873376566) | |||
| 33279 | 33279 | 206578 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993312.03833 | 2099686.0969 | 37.7449537923783 | -122.46582874591199 | (37.7449537923783, -122.465828745912) | |||
| 166442 | 166442 | 206532 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993345.963169999 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | |||
| 70255 | 70255 | 206531 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.730879244086296 | -122.46533008801399 | (37.7308792440863, -122.465330088014) | |||
| 73447 | 73447 | 206502 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | |||
| 32853 | 32853 | 206501 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993462.44278 | 2104571.8221299998 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | |||
| 185239 | 185239 | 206500 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993474.546519999 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | |||
| 157581 | 157581 | 206499 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993488.07663 | 2104571.6485200003 | 37.7583784177465 | -122.46557490416001 | (37.7583784177465, -122.46557490416) | |||
| 53148 | 53148 | 206498 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | |||
| 41542 | 41542 | 206581 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993591.13879 | 2099773.66773 | 37.745210335700605 | -122.46487003355301 | (37.7452103357006, -122.464870033553) |
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");