trees
336 rows where qLegalStatus_id = 1 and 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 81319 | 206582 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765799 | -122.464803087101 | (37.745215765799, -122.464803087101) | 1 | 8 | 4 | 29491 | 40 | |||
| 106812 | 206577 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993636.26419 | 2099712.16168 | 37.7450440573323 | -122.464709533316 | (37.7450440573323, -122.464709533316) | 1 | 8 | 4 | 29491 | 40 | |||
| 133810 | 206583 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993643.85712 | 2099778.24608 | 37.7452259461282 | -122.464688076401 | (37.7452259461282, -122.464688076401) | 1 | 8 | 4 | 29491 | 40 | |||
| 180178 | 206664 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 San Marcos Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993646.4962 | 2100328.84926 | 37.7467379151376 | -122.464718926731 | (37.7467379151376, -122.464718926731) | 1 | 8 | 4 | 29491 | 40 | |||
| 103424 | 206620 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993657.15968 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | 1 | 8 | 4 | 29491 | 40 | |||
| 182208 | 206584 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993659.8453 | 2099783.10112 | 37.7452401985713 | -122.464633144905 | (37.7452401985713, -122.464633144905) | 1 | 8 | 4 | 29491 | 40 | |||
| 172753 | 206576 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993684.51151 | 2099645.64672 | 37.7448642055102 | -122.464537875235 | (37.7448642055102, -122.464537875235) | 1 | 8 | 4 | 29491 | 40 | |||
| 186941 | 206575 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993692.18131 | 2099632.63233 | 37.744828913423 | -122.464510409921 | (37.744828913423, -122.464510409921) | 1 | 8 | 4 | 29491 | 40 | |||
| 152214 | 206574 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993698.09593 | 2099619.5133 | 37.7447932328356 | -122.464489006068 | (37.7447932328356, -122.464489006068) | 1 | 8 | 4 | 29491 | 40 | |||
| 35026 | 206591 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993709.62503 | 2099698.37793 | 37.7450104397813 | -122.464454865994 | (37.7450104397813, -122.464454865994) | 1 | 8 | 4 | 29491 | 40 | |||
| 157023 | 206592 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993721.8716 | 2099672.65516 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) | 1 | 8 | 4 | 29491 | 40 | |||
| 61980 | 206497 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1616 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5993722.38757 | 2104477.64501 | 37.7581338201448 | -122.464757733396 | (37.7581338201448, -122.464757733396) | 1 | 8 | 4 | 56 | 12 | |||
| 140979 | 206548 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Dorantes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993741.10567 | 2099827.07051 | 37.7453656117262 | -122.464355354239 | (37.7453656117262, -122.464355354239) | 1 | 8 | 4 | 29491 | 40 | |||
| 62897 | 206623 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 1964 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993824.3832 | 2102096.20379 | 37.7516008749812 | -122.464232103026 | (37.7516008749812, -122.464232103026) | 1 | 8 | 4 | 29491 | 12 | |||
| 64571 | 206665 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 11 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993870.76921 | 2100887.71242 | 37.7482853390143 | -122.463983980089 | (37.7482853390143, -122.463983980089) | 1 | 8 | 4 | 29491 | 40 | |||
| 50752 | 206547 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993889.30878 | 2099967.60077 | 37.7457600139093 | -122.463853094571 | (37.7457600139093, -122.463853094571) | 1 | 8 | 4 | 29491 | 40 | |||
| 161052 | 206555 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993893.29504 | 2101174.89341 | 37.7490751632062 | -122.463926929805 | (37.7490751632062, -122.463926929805) | 1 | 8 | 4 | 29491 | 40 | |||
| 77345 | 206554 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993895.61602 | 2101166.11299 | 37.7490511881613 | -122.463918266634 | (37.7490511881613, -122.463918266634) | 1 | 8 | 4 | 29491 | 40 | |||
| 146225 | 206556 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 32 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5993935.86279 | 2101082.16601 | 37.7488230103837 | -122.463773001819 | (37.7488230103837, -122.463773001819) | 1 | 8 | 4 | 29491 | 40 | |||
| 59731 | 206585 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 368 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993961.34204 | 2099692.54098 | 37.745008919941 | -122.463584056983 | (37.745008919941, -122.463584056983) | 1 | 8 | 4 | 29491 | 40 | |||
| 184544 | 206666 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993976.53914 | 2100938.08553 | 37.7484297458427 | -122.463621888759 | (37.7484297458427, -122.463621888759) | 1 | 8 | 4 | 29491 | 40 | |||
| 117873 | 206667 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993986.73582 | 2100929.3593 | 37.7484063733597 | -122.463585995905 | (37.7484063733597, -122.463585995905) | 1 | 8 | 4 | 29491 | 40 | |||
| 12800 | 206586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.7450940434634 | -122.463461028807 | (37.7450940434634, -122.463461028807) | 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) );