Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 40135 | 40135 | 206582 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765798996 | -122.464803087101 | (37.745215765799, -122.464803087101) | |||
| 136744 | 136744 | 206664 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 135 San Marcos Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5993646.4962 | 2100328.84926 | 37.7467379151376 | -122.464718926731 | (37.7467379151376, -122.464718926731) | |||
| 106851 | 106851 | 94159 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 1831 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53536 | 5993712.5 | 2103021.2 | 37.754134227954005 | -122.464686168912 | (37.754134227954, -122.464686168912) | ||
| 44246 | 44246 | 206584 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993659.8453 | 2099783.1011200002 | 37.745240198571295 | -122.464633144905 | (37.7452401985713, -122.464633144905) | |||
| 153258 | 153258 | 206575 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Montalvo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993692.18131 | 2099632.63233 | 37.744828913423 | -122.464510409921 | (37.744828913423, -122.464510409921) | |||
| 101018 | 101018 | 33392 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37511 | 5993609.77804843 | 2093900.82209008 | 37.729086039701 | -122.464379267011 | (37.729086039701, -122.464379267011) | ||
| 58785 | 58785 | 206665 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 11 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993870.76921 | 2100887.71242 | 37.748285339014295 | -122.463983980089 | (37.7482853390143, -122.463983980089) | |||
| 76722 | 76722 | 206547 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993889.308780001 | 2099967.60077 | 37.7457600139093 | -122.463853094571 | (37.7457600139093, -122.463853094571) | |||
| 27341 | 27341 | 206556 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 32 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5993935.86279 | 2101082.16601 | 37.7488230103837 | -122.463773001819 | (37.7488230103837, -122.463773001819) | |||
| 49358 | 49358 | 206666 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 15 Sotelo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5993976.53914 | 2100938.08553 | 37.74842974584271 | -122.46362188875901 | (37.7484297458427, -122.463621888759) | |||
| 115230 | 115230 | 52741 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 409@ ALTON Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48790 | 5994026.96721275 | 2101530.61038788 | 37.750059574115895 | -122.46349050523399 | (37.7500595741159, -122.463490505234) | |||
| 43524 | 43524 | 206628 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 20 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994037.30563 | 2101977.91794 | 37.7512883623694 | -122.463487212563 | (37.7512883623694, -122.463487212563) | |||
| 34016 | 34016 | 206586 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.745094043463396 | -122.46346102880699 | (37.7450940434634, -122.463461028807) | |||
| 145633 | 145633 | 47755 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 364St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2002 12:00:00 AM | Permit Number 45535 | 5994004.07072151 | 2099729.00956261 | 37.7451115153754 | -122.463438956035 | (37.7451115153754, -122.463438956035) | |||
| 39280 | 39280 | 206536 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 401 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994052.44062 | 2101520.15999 | 37.7500323476354 | -122.463401659183 | (37.7500323476354, -122.463401659183) | |||
| 97036 | 97036 | 47756 | Permitted Site 1 | Crataegus laevigata :: English Hawthorn 66 | 360St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2002 12:00:00 AM | Permit Number 45536 | 5994029.42937676 | 2099753.03047002 | 37.7451789317369 | -122.463353013703 | (37.7451789317369, -122.463353013703) | |||
| 186378 | 186378 | 206627 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 40 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994076.75455 | 2101874.6545700002 | 37.751007100296604 | -122.463343302157 | (37.7510071002966, -122.463343302157) | |||
| 158121 | 158121 | 206588 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 348 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994058.29292 | 2099782.40477 | 37.7452612490171 | -122.463255340382 | (37.7452612490171, -122.463255340382) | |||
| 51397 | 51397 | 206539 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.46316740736499 | (37.749759810788, -122.463167407365) | |||
| 64063 | 64063 | 122404 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5994085.0 | 2099826.0 | 37.74538248907739 | -122.46316615516001 | (37.7453824890774, -122.46316615516) | ||||
| 133979 | 133979 | 206590 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994099.18491 | 2099823.6206900002 | 37.745376773231 | -122.463116933812 | (37.745376773231, -122.463116933812) | |||
| 27743 | 27743 | 206657 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994149.03126 | 2101531.53277 | 37.7500691388799 | -122.463068471138 | (37.7500691388799, -122.463068471138) | |||
| 56091 | 56091 | 206541 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 375 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994147.31458 | 2101302.53521 | 37.7494402708691 | -122.463057794403 | (37.7494402708691, -122.463057794403) | |||
| 174659 | 174659 | 206543 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 347 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994159.12368 | 2101087.0695700003 | 37.7488493371331 | -122.463001327749 | (37.7488493371331, -122.463001327749) | |||
| 68999 | 68999 | 206663 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 390 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994181.82756 | 2101452.31219 | 37.7498535084399 | -122.46294931367399 | (37.7498535084399, -122.462949313674) | |||
| 35264 | 35264 | 206544 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 337 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994178.74316 | 2101030.22278 | 37.7486943803622 | -122.462929360401 | (37.7486943803622, -122.462929360401) | |||
| 102428 | 102428 | 206562 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1478 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994313.38923 | 2105462.92602 | 37.76087320276021 | -122.462785287235 | (37.7608732027602, -122.462785287235) | |||
| 59046 | 59046 | 206654 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994247.90783 | 2101537.24109 | 37.7500905076701 | -122.46272696707399 | (37.7500905076701, -122.462726967074) | |||
| 174439 | 174439 | 206625 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374828999 | (37.7507963531822, -122.46262374829) | |||
| 165454 | 165454 | 206630 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 81 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994323.8061 | 2101846.4166200003 | 37.7509437961254 | -122.46248693172701 | (37.7509437961254, -122.462486931727) | |||
| 52949 | 52949 | 206549 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 308 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994338.43004 | 2100748.81738 | 37.7479309089808 | -122.462356761175 | (37.7479309089808, -122.462356761175) | |||
| 72564 | 72564 | 206631 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 89 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994365.2652199995 | 2101880.85976 | 37.7510407556506 | -122.462346061026 | (37.7510407556506, -122.462346061026) | |||
| 58009 | 58009 | 206641 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994436.73351 | 2100801.00946 | 37.748079875384796 | -122.462020618849 | (37.7480798753848, -122.462020618849) | |||
| 150435 | 150435 | 206545 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 265 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994446.422040001 | 2100465.35227 | 37.747158803252 | -122.461962779858 | (37.747158803252, -122.461962779858) | |||
| 170709 | 170709 | 206644 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994467.924 | 2100831.48615 | 37.748165352368105 | -122.46191497372 | (37.7481653523681, -122.46191497372) | |||
| 29674 | 29674 | 206651 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994510.63767 | 2100971.03236 | 37.7485509699531 | -122.461777389118 | (37.7485509699531, -122.461777389118) | |||
| 156496 | 156496 | 206639 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994510.39425 | 2100823.8744099997 | 37.748146897381794 | -122.461767562235 | (37.7481468973818, -122.461767562235) |
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");