trees
493 rows where qSpecies_id = 133 sorted by XCoord
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 146015 | 68553 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 724 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/1996 12:00:00 AM | Permit Number 32442 | 5982311.44586787 | 2110822.57803578 | 37.7748906946614 | -122.50469113477 | (37.7748906946614, -122.50469113477) | 11 | 6 | 2 | 55 | 26 | ||
| 146470 | 63003 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1239 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 3 | Permit Number 23411 | 5983024.3565 | 2106665.5091 | 37.763518489811 | -122.501917412441 | (37.763518489811, -122.501917412441) | 1 | 8 | 3 | 56 | 35 | ||
| 110106 | 63000 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1251 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23408 | 5983028.2339 | 2106580.2336 | 37.7632845753318 | -122.501897691969 | (37.7632845753318, -122.501897691969) | 1 | 8 | 3 | 56 | 35 | ||
| 179616 | 63086 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1209 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1986 12:00:00 AM | 3 | Permit Number 23570 | 5983326.3714 | 2106866.623 | 37.7640884282736 | -122.500887729919 | (37.7640884282736, -122.500887729919) | 1 | 8 | 3 | 56 | 35 | ||
| 9249 | 183317 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1209 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983329.0993 | 2106834.4338 | 37.7640002060456 | -122.500875914404 | (37.7640002060456, -122.500875914404) | 1 | 8 | 3 | 56 | 35 | |||
| 144997 | 69148 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2478 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33183 | 5983358.82084368 | 2098279.8149921 | 37.7405133500226 | -122.500140666527 | (37.7405133500226, -122.500140666527) | 1 | 8 | 3 | 29491 | 35 | ||
| 132897 | 61351 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2435 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33180 | 5983606.72733818 | 2098575.39773775 | 37.7413394866654 | -122.499305352528 | (37.7413394866654, -122.499305352528) | 1 | 8 | 3 | 29491 | 35 | ||
| 701 | 52560 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1742 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 7 | Permit Number 48656 | 5984113.6499 | 2103302.6049 | 37.7543488257224 | -122.497901608629 | (37.7543488257224, -122.497901608629) | 1 | 8 | 3 | 56 | 35 | |
| 138408 | 82688 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1875 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51093 | 5984404.185 | 2102433.03 | 37.7519782422196 | -122.496832705614 | (37.7519782422196, -122.496832705614) | 1 | 8 | 3 | 56 | 35 | |
| 168589 | 183679 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 3627 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5984438.7811 | 2106305.4338 | 37.7626128114068 | -122.496998863919 | (37.7626128114068, -122.496998863919) | 1 | 8 | 3 | 56 | 35 | |||
| 170107 | 95910 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1863 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767611 | 5986268.2408 | 2102571.6706 | 37.7524679589822 | -122.490396818222 | (37.7524679589822, -122.490396818222) | 1 | 8 | 3 | 56 | 35 |
| 119747 | 38530 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2550 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1998 12:00:00 AM | 3 | Permit Number 40512 | 5986784.3655 | 2097886.9498 | 37.7396351026284 | -122.48826775932 | (37.7396351026284, -122.48826775932) | 1 | 8 | 3 | 29491 | 35 | ||
| 55272 | 95906 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1323 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767607 | 5987385.7768 | 2106255.5896 | 37.7626482044987 | -122.486802739667 | (37.7626482044987, -122.486802739667) | 1 | 8 | 3 | 56 | 35 |
| 47724 | 184366 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987606.9921 | 2099709.6419 | 37.7446876937291 | -122.485557233352 | (37.7446876937291, -122.485557233352) | 1 | 8 | 3 | 29491 | 35 | |||
| 4849 | 43803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 762 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | Permit Number 43433 | 5988853.6653409 | 2110130.11231626 | 37.7733720498685 | -122.482009746097 | (37.7733720498685, -122.482009746097) | 11 | 6 | 2 | 55 | 26 | ||
| 1328 | 65972 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2090 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1990 12:00:00 AM | 2 | Permit Number 28996 | 5989155.2561 | 2101119.0911 | 37.7486477564753 | -122.480306841406 | (37.7486477564753, -122.480306841406) | 1 | 8 | 3 | 29491 | 35 | |
| 23516 | 50918 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2477 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | 3 | Permit Number 47420 | 5989820.2795 | 2098517.5722 | 37.7415432867093 | -122.477817075256 | (37.7415432867093, -122.477817075256) | 1 | 8 | 3 | 29491 | 35 | |
| 10338 | 31751 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 9 | Permit Number 35238 | 5989883.0648 | 2098033.3774 | 37.7402174568148 | -122.477564605136 | (37.7402174568148, -122.477564605136) | 1 | 8 | 3 | 29491 | 35 | |
| 104910 | 31750 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2546 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 5 | Permit Number 35238 | 5989885.0953 | 2098017.81 | 37.7401748305885 | -122.477556447005 | (37.7401748305885, -122.477556447005) | 1 | 8 | 3 | 29491 | 35 | |
| 33901 | 183040 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5989885.4338 | 2097934.2198 | 37.739945333152 | -122.477549168466 | (37.739945333152, -122.477549168466) | 1 | 8 | 3 | 29491 | 35 | |||
| 89550 | 65967 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2562 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 7 | Permit Number 28991 | 5989886.449 | 2097917.9756 | 37.7399007896882 | -122.477544471364 | (37.7399007896882, -122.477544471364) | 1 | 8 | 3 | 29491 | 35 | |
| 110892 | 31752 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 7 | Permit Number 35239 | 5989905.4007 | 2097381.577 | 37.7384290772799 | -122.477439751256 | (37.7384290772799, -122.477439751256) | 1 | 8 | 3 | 29491 | 35 | |
| 123013 | 31753 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2642 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 6 | Permit Number 35239 | 5989905.4007 | 2097364.9943 | 37.738383545459 | -122.477438539611 | (37.738383545459, -122.477438539611) | 1 | 8 | 3 | 29491 | 35 | |
| 18348 | 98409 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 55 19th Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 5990099.2 | 2106073.1 | 37.7623049568555 | -122.477404745944 | (37.7623049568555, -122.477404745944) | 1 | 8 | 3 | 56 | 35 | |||||
| 171037 | 182595 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 955 Rivera St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990177.9035 | 2100379.6188 | 37.7466767317389 | -122.4767165565 | (37.7466767317389, -122.4767165565) | 1 | 8 | 3 | 29491 | 35 | |||
| 123636 | 182596 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 945 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5990197.9307 | 2100380.5725 | 37.7466805119975 | -122.47664737489 | (37.7466805119975, -122.47664737489) | 1 | 8 | 3 | 29491 | 35 | |||
| 109592 | 60142 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1600 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/13/1997 12:00:00 AM | Permit Number 19672 | 5990905.68098297 | 2104491.51831194 | 37.7580091169986 | -122.474500032297 | (37.7580091169986, -122.474500032297) | 1 | 8 | 4 | 56 | 12 | ||
| 159595 | 206508 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990927.20691 | 2104481.04629 | 37.7579816107755 | -122.474424823051 | (37.7579816107755, -122.474424823051) | 1 | 8 | 4 | 56 | 12 | |||
| 168392 | 68613 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1921 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32518 | 5990927.53246028 | 2102322.02893789 | 37.7520535368402 | -122.474266156198 | (37.7520535368402, -122.474266156198) | 1 | 8 | 4 | 29491 | 12 | ||
| 181496 | 68621 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1945 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32526 | 5990932.87525798 | 2102165.34703457 | 37.7516236388925 | -122.474236248389 | (37.7516236388925, -122.474236248389) | 1 | 8 | 4 | 29491 | 12 | ||
| 14448 | 206509 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5990938.9472 | 2104480.79856 | 37.7579816107664 | -122.474384202485 | (37.7579816107664, -122.474384202485) | 1 | 8 | 4 | 56 | 12 | |||
| 43073 | 206510 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990951.63934 | 2104480.53076 | 37.7579816107816 | -122.474340288587 | (37.7579816107816, -122.474340288587) | 1 | 8 | 4 | 56 | 12 | |||
| 63353 | 206511 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990966.24876 | 2104480.85465 | 37.7579833464788 | -122.474289787164 | (37.7579833464788, -122.474289787164) | 1 | 8 | 4 | 56 | 12 | |||
| 130434 | 206512 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990980.22345 | 2104481.19226 | 37.7579850830548 | -122.474241481884 | (37.7579850830548, -122.474241481884) | 1 | 8 | 4 | 56 | 12 | |||
| 117905 | 206513 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990992.34085 | 2104483.78156 | 37.757992894562 | -122.47419976413 | (37.757992894562, -122.47419976413) | 1 | 8 | 4 | 56 | 12 | |||
| 137146 | 65803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28771 | 5991002.61160286 | 2100125.98772668 | 37.7460281288142 | -122.4738463283 | (37.7460281288142, -122.4738463283) | 1 | 8 | 4 | 29491 | 40 | ||
| 9241 | 65804 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.473841275381 | (37.7459566686168, -122.473841275381) | 1 | 8 | 4 | 29491 | 40 | ||
| 155534 | 206514 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1023 Lawton St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5991006.3222 | 2104484.4348 | 37.7579954981234 | -122.474151458838 | (37.7579954981234, -122.474151458838) | 1 | 8 | 4 | 56 | 12 | |||
| 181480 | 206515 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5991033.61709 | 2104484.17502 | 37.7579963659675 | -122.474057043516 | (37.7579963659675, -122.474057043516) | 1 | 8 | 4 | 56 | 12 | |||
| 27614 | 65799 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.7467507369343 | -122.473717291816 | (37.7467507369343, -122.473717291816) | 1 | 8 | 4 | 29491 | 40 | ||
| 101256 | 206522 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.473708385358 | (37.7465686447317, -122.473708385358) | 1 | 8 | 4 | 29491 | 40 | |||
| 22339 | 206516 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991047.26108 | 2104483.88717 | 37.7579963659448 | -122.474009836278 | (37.7579963659448, -122.474009836278) | 1 | 8 | 4 | 56 | 12 | |||
| 73036 | 206517 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991060.29058 | 2104484.56084 | 37.7579989703891 | -122.473964824336 | (37.7579989703891, -122.473964824336) | 1 | 8 | 4 | 56 | 12 | |||
| 167985 | 206518 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1019 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5991072.98938 | 2104484.60902 | 37.7579998382313 | -122.473920910448 | (37.7579998382313, -122.473920910448) | 1 | 8 | 4 | 56 | 12 | |||
| 134005 | 81908 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1601 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50503 | 5991112.7626616 | 2104504.97362674 | 37.7580580577361 | -122.47378484454 | (37.7580580577361, -122.47378484454) | 1 | 8 | 4 | 56 | 12 | ||
| 180333 | 68592 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1612 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32493 | 5991166.83201474 | 2104447.27401218 | 37.7579027613113 | -122.473593642621 | (37.7579027613113, -122.473593642621) | 1 | 8 | 4 | 56 | 12 | ||
| 185843 | 68598 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1926 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32501 | 5991291.13136145 | 2102295.45546455 | 37.7520016305294 | -122.473006852086 | (37.7520016305294, -122.473006852086) | 1 | 8 | 4 | 29491 | 12 | ||
| 49813 | 206568 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991380.56657 | 2098286.24678 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | 1 | 8 | 4 | 29491 | 40 | |||
| 81847 | 206567 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991381.76089 | 2098233.80223 | 37.7408546267459 | -122.472397375252 | (37.7408546267459, -122.472397375252) | 1 | 8 | 4 | 29491 | 40 | |||
| 150332 | 31296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 431 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34940 | 5991578.61319 | 2097704.4347 | 37.7394125098801 | -122.471678172112 | (37.7394125098801, -122.471678172112) | 1 | 8 | 4 | 29491 | 40 | |
| 126854 | 47123 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1818 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45108 | 5991595.47197715 | 2102975.75176021 | 37.7538871618551 | -122.472003987589 | (37.7538871618551, -122.472003987589) | 1 | 8 | 4 | 56 | 12 | ||
| 138610 | 31913 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2281 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42222 | 5991689.25479737 | 2099914.99470572 | 37.7454885429424 | -122.471456657987 | (37.7454885429424, -122.471456657987) | 1 | 8 | 4 | 29491 | 40 | ||
| 13518 | 31915 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2287 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 4 | Permit Number 35339 | 5991692.93382 | 2099879.32999 | 37.745390829638 | -122.471441338374 | (37.745390829638, -122.471441338374) | 1 | 8 | 4 | 29491 | 40 | |
| 128259 | 206521 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991723.00262 | 2099864.63418 | 37.7453522181485 | -122.471336295754 | (37.7453522181485, -122.471336295754) | 1 | 8 | 4 | 29491 | 40 | |||
| 148811 | 206520 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991725.72943 | 2099875.90905 | 37.7453833337792 | -122.471327688331 | (37.7453833337792, -122.471327688331) | 1 | 8 | 4 | 29491 | 40 | |||
| 151946 | 65810 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28778 | 5991729.56779327 | 2099841.10556299 | 37.7452879943861 | -122.471311880679 | (37.7452879943861, -122.471311880679) | 1 | 8 | 4 | 29491 | 40 | ||
| 127094 | 31914 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2286 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 4 | Permit Number 42223 | 5991731.01436 | 2099907.3159 | 37.7454698746265 | -122.471311701978 | (37.7454698746265, -122.471311701978) | 1 | 8 | 4 | 29491 | 40 | |
| 190674 | 206519 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991734.05463 | 2099933.45812 | 37.7455418303067 | -122.471303093689 | (37.7455418303067, -122.471303093689) | 1 | 8 | 4 | 29491 | 40 | |||
| 32620 | 31228 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2651 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34914 | 5991736.03785 | 2097377.43168 | 37.7385237494811 | -122.47111005511 | (37.7385237494811, -122.47111005511) | 1 | 8 | 4 | 29491 | 40 | |
| 150864 | 206565 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2679 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991740.00006 | 2097213.72231 | 37.7380744742606 | -122.471084432514 | (37.7380744742606, -122.471084432514) | 1 | 8 | 4 | 29491 | 40 | |||
| 25175 | 65811 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28799 | 5991740.53584922 | 2099906.37764585 | 37.7454678491967 | -122.471278710139 | (37.7454678491967, -122.471278710139) | 1 | 8 | 4 | 29491 | 40 | ||
| 104682 | 206566 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991741.26483 | 2097200.972 | 37.7380395382962 | -122.471079130991 | (37.7380395382962, -122.471079130991) | 1 | 8 | 4 | 29491 | 40 | |||
| 45301 | 206523 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | 1 | 8 | 4 | 29491 | 40 | |||
| 82530 | 68702 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 178 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32614 | 5991836.89762768 | 2114262.80781602 | 37.7848923529415 | -122.471991698628 | (37.7848923529415, -122.471991698628) | 11 | 6 | 2 | 54 | 11 | ||
| 38958 | 40752 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
| 64516 | 40751 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
| 177522 | 35070 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1624 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38624 | 5992801.46807232 | 2104400.76142731 | 37.7578695806114 | -122.46793705016 | (37.7578695806114, -122.46793705016) | 1 | 8 | 4 | 56 | 12 | ||
| 63519 | 206524 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.7427160965819 | -122.467054169341 | (37.7427160965819, -122.467054169341) | 1 | 8 | 4 | 59 | 40 | |||
| 152874 | 206525 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992946.5083 | 2098897.01812 | 37.7427660898953 | -122.46703531413 | (37.7427660898953, -122.46703531413) | 1 | 8 | 4 | 59 | 40 | |||
| 71121 | 206526 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.7428116981042 | -122.467010912843 | (37.7428116981042, -122.467010912843) | 1 | 8 | 4 | 59 | 40 | |||
| 125070 | 206527 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992983.90563 | 2098997.49136 | 37.7430441224891 | -122.466913308501 | (37.7430441224891, -122.466913308501) | 1 | 8 | 4 | 59 | 40 | |||
| 74614 | 206528 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992986.65204 | 2099006.05822 | 37.7430678034305 | -122.466904434898 | (37.7430678034305, -122.466904434898) | 1 | 8 | 4 | 59 | 40 | |||
| 70998 | 206529 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992989.73242 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | 1 | 8 | 4 | 59 | 40 | |||
| 156649 | 251254 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 330 09th Ave | 1 | unknown : Cutout | Tree | MTA 3 | 3x3 | 5993109 | 2113253 | 37.7821932251036 | -122.467517213871 | (37.7821932251036, -122.467517213871) | 11 | 6 | 2 | 54 | 11 | ||||
| 83897 | 206503 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1957 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993135.46016 | 2102179.05998 | 37.7517886444405 | -122.46662048837 | (37.7517886444405, -122.46662048837) | 1 | 8 | 4 | 29491 | 12 | |||
| 177882 | 206504 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1959 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993136.05327 | 2102151.01657 | 37.7517116786758 | -122.466616399136 | (37.7517116786758, -122.466616399136) | 1 | 8 | 4 | 29491 | 12 | |||
| 54867 | 206505 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1965 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993138.76599 | 2102124.24037 | 37.7516383146611 | -122.466605072187 | (37.7516383146611, -122.466605072187) | 1 | 8 | 4 | 29491 | 12 | |||
| 188697 | 206506 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1985 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993143.71774 | 2101970.98373 | 37.7512177970674 | -122.466576810083 | (37.7512177970674, -122.466576810083) | 1 | 8 | 4 | 29491 | 12 | |||
| 151607 | 206507 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1985 10th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993144.62205 | 2101960.97627 | 37.751190371338 | -122.466572955586 | (37.751190371338, -122.466572955586) | 1 | 8 | 4 | 29491 | 12 | |||
| 129309 | 206564 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.466502884014 | (37.7501303674196, -122.466502884014) | 1 | 8 | 4 | 29491 | 12 | |||
| 155475 | 206563 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2047 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993157.06576 | 2101533.95115 | 37.750018588 | -122.466498890138 | (37.750018588, -122.466498890138) | 1 | 8 | 4 | 29491 | 12 | |||
| 169106 | 206621 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993175.25671 | 2102431.10448 | 37.7524829903015 | -122.466501185193 | (37.7524829903015, -122.466501185193) | 1 | 8 | 4 | 29491 | 12 | |||
| 98988 | 206622 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1912 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993175.38418 | 2102417.55667 | 37.7524457988584 | -122.466499759777 | (37.7524457988584, -122.466499759777) | 1 | 8 | 4 | 29491 | 12 | |||
| 108499 | 218322 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.7456970982494 | -122.466270063011 | (37.7456970982494, -122.466270063011) | 1 | 8 | 4 | 29491 | 40 | |||
| 57352 | 68501 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 1968 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32378 | 5993191.21227254 | 2102085.73019228 | 37.7515356020282 | -122.466420909066 | (37.7515356020282, -122.466420909066) | 1 | 8 | 4 | 29491 | 12 | ||
| 114209 | 206572 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | 1 | 8 | 4 | 29491 | 40 | |||
| 37635 | 206573 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | 1 | 8 | 4 | 29491 | 40 | |||
| 159238 | 206571 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993219.18082 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | 1 | 8 | 4 | 29491 | 40 | |||
| 157044 | 206570 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 4 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993230.10677 | 2099675.67045 | 37.7449204374235 | -122.46611129043 | (37.7449204374235, -122.46611129043) | 1 | 8 | 4 | 29491 | 40 | |||
| 126946 | 206580 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993286.92729 | 2099684.15258 | 37.7449470052046 | -122.465915433344 | (37.7449470052046, -122.465915433344) | 1 | 8 | 4 | 29491 | 40 | |||
| 88461 | 206579 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257 | -122.465873376566 | (37.744949720257, -122.465873376566) | 1 | 8 | 4 | 29491 | 40 | |||
| 176132 | 206578 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993312.03833 | 2099686.0969 | 37.7449537923783 | -122.465828745912 | (37.7449537923783, -122.465828745912) | 1 | 8 | 4 | 29491 | 40 | |||
| 186101 | 206532 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993345.96317 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | 9 | 8 | 4 | 59 | 40 | |||
| 194155 | 206531 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.7308792440863 | -122.465330088014 | (37.7308792440863, -122.465330088014) | 9 | 8 | 4 | 59 | 40 | |||
| 114669 | 206502 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993453.26762 | 2104570.92091 | 37.7583744121607 | -122.465695235269 | (37.7583744121607, -122.465695235269) | 1 | 8 | 4 | 56 | 12 | |||
| 114457 | 206501 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993462.44278 | 2104571.82213 | 37.7583774159051 | -122.465663569242 | (37.7583774159051, -122.465663569242) | 1 | 8 | 4 | 56 | 12 | |||
| 32203 | 206500 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5993474.54652 | 2104572.66216 | 37.7583804205467 | -122.465621770525 | (37.7583804205467, -122.465621770525) | 1 | 8 | 4 | 56 | 12 | |||
| 35595 | 206499 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993488.07663 | 2104571.64852 | 37.7583784177465 | -122.46557490416 | (37.7583784177465, -122.46557490416) | 1 | 8 | 4 | 56 | 12 | |||
| 62155 | 206498 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 245 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993516.66966 | 2104572.87128 | 37.7583834242608 | -122.465476106443 | (37.7583834242608, -122.465476106443) | 1 | 8 | 4 | 56 | 12 | |||
| 189913 | 206581 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 190 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993591.13879 | 2099773.66773 | 37.7452103357006 | -122.464870033553 | (37.7452103357006, -122.464870033553) | 1 | 8 | 4 | 29491 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );