trees
34 rows where Zip Codes = 28856 and qSpecies_id = 95 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11959 | 80608 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1525 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013013.8761 | 2105640.89968 | 37.7624212021999 | -122.398120604778 | (37.7624212021999, -122.398120604778) | 10 | 3 | 8 | 28856 | 29 | |||
| 15032 | 194567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 382 Texas St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6013743.43847 | 2105323.69355 | 37.7615908320593 | -122.39557507463 | (37.7615908320593, -122.39557507463) | 10 | 3 | 8 | 28856 | 29 | |||
| 26065 | 194549 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 403 04th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012748.86682 | 2112225.44873 | 37.780486123384 | -122.399499481319 | (37.780486123384, -122.399499481319) | 6 | 2 | 9 | 28856 | 34 | |||
| 26580 | 194561 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 999 Kansas St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011649.57806 | 2103809.76096 | 37.7573172186375 | -122.402710453142 | (37.7573172186375, -122.402710453142) | 10 | 3 | 8 | 28856 | 29 | ||||
| 30717 | 194558 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2301 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6010916.08581 | 2105050.31946 | 37.7606825347817 | -122.405334531886 | (37.7606825347817, -122.405334531886) | 10 | 3 | 8 | 28856 | 29 | ||||
| 34265 | 3767 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1074 Carolina St | 5 | Median : Cutout | Tree | DPW 1 | 6 | 18 | 6012456.6037355 | 2102966.9856684 | 37.7550481677782 | -122.399860245008 | (37.7550481677782, -122.399860245008) | 10 | 3 | 8 | 28856 | 29 | |||
| 34766 | 62075 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 640 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1985 12:00:00 AM | Permit Number 22157 | 6013257.98331127 | 2104095.18342465 | 37.7581905974819 | -122.397167930647 | (37.7581905974819, -122.397167930647) | 10 | 3 | 8 | 28856 | 29 | ||
| 38101 | 194563 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 707 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6011584.56898 | 2105045.25921 | 37.7607059927056 | -122.403022180623 | (37.7607059927056, -122.403022180623) | 10 | 3 | 8 | 28856 | 29 | |||
| 39183 | 194568 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1790 23rd St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013278.79656 | 2102907.44302 | 37.7549304790786 | -122.397012671508 | (37.7549304790786, -122.397012671508) | 10 | 3 | 8 | 28856 | 29 | ||||
| 43700 | 194557 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 900x Carolina St | 69 | Median : Yard | Tree | DPW 1 | 11 | 6012516.26815 | 2102828.89594 | 37.7546723295715 | -122.399644211933 | (37.7546723295715, -122.399644211933) | 10 | 3 | 8 | 28856 | 29 | ||||
| 45005 | 67586 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 320 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31151 | 6014299.12968665 | 2105631.25303268 | 37.7624662173131 | -122.393674678003 | (37.7624662173131, -122.393674678003) | 10 | 3 | 8 | 28856 | 29 | ||
| 45334 | 101849 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1001X Rhode Island St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011941.50663 | 2103634.1121 | 37.7568512205105 | -122.401688497731 | (37.7568512205105, -122.401688497731) | 10 | 3 | 8 | 28856 | 29 | |||
| 49268 | 194554 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1525 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6013041.39469 | 2105640.60809 | 37.76242193426 | -122.398025407042 | (37.76242193426, -122.398025407042) | 10 | 3 | 8 | 28856 | 29 | |||
| 53794 | 3769 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1098 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
| 54105 | 194555 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012324.08252 | 2103973.55648 | 37.7578046017164 | -122.400389241774 | (37.7578046017164, -122.400389241774) | 10 | 3 | 8 | 28856 | 29 | |||
| 62497 | 194550 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 403 04th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 6012740.93096 | 2112217.51557 | 37.7804638984163 | -122.399526378248 | (37.7804638984163, -122.399526378248) | 6 | 2 | 9 | 28856 | 34 | |||
| 77888 | 33924 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1515 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1997 12:00:00 AM | Permit Number 37890 | 6013177.07893091 | 2105178.79303275 | 37.761161447817 | -122.39752373182 | (37.761161447817, -122.39752373182) | 10 | 3 | 8 | 28856 | 29 | ||
| 81777 | 194562 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 889 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6011315.22024 | 2104197.07336 | 37.7583620186233 | -122.40389405447 | (37.7583620186233, -122.40389405447) | 10 | 3 | 8 | 28856 | 29 | ||||
| 85921 | 194565 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 601 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6011831.4934 | 2105538.22231 | 37.7620733453319 | -122.402202834406 | (37.7620733453319, -122.402202834406) | 10 | 3 | 8 | 28856 | 29 | |||
| 95493 | 100209 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 701 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 10 | Permit Number 769013 | 6011855.86556 | 2105057.10212 | 37.7607536567646 | -122.402084714731 | (37.7607536567646, -122.402084714731) | 10 | 3 | 8 | 28856 | 29 | |||
| 100685 | 61788 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1269 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | Permit Number 21810 | 6011996.7545231 | 2102487.05036532 | 37.7537047233984 | -122.401416818367 | (37.7537047233984, -122.401416818367) | 10 | 3 | 8 | 28856 | 29 | ||
| 105175 | 194559 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2301 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6010925.71901 | 2105051.26279 | 37.7606856635422 | -122.405301281245 | (37.7606856635422, -122.405301281245) | 10 | 3 | 8 | 28856 | 29 | ||||
| 105379 | 194548 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 403 04th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012759.18972 | 2112229.11025 | 37.7804967524539 | -122.399464026441 | (37.7804967524539, -122.399464026441) | 6 | 2 | 9 | 28856 | 34 | |||
| 124004 | 194560 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2045 19th St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6011621.05801 | 2105090.22678 | 37.7608315011953 | -122.402899143494 | (37.7608315011953, -122.402899143494) | 10 | 3 | 8 | 28856 | 29 | |||
| 124906 | 62567 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 566 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1986 12:00:00 AM | Permit Number 22768 | 6011492.88408448 | 2105735.21386833 | 37.7625953337074 | -122.403387819029 | (37.7625953337074, -122.403387819029) | 8 | 3 | 8 | 28856 | 29 | ||
| 129295 | 194553 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 6011164.90304 | 2106222.99069 | 37.7639163349965 | -122.404556531081 | (37.7639163349965, -122.404556531081) | 8 | 3 | 8 | 28856 | 29 | ||||
| 132593 | 194564 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 609 Rhode Island St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6011831.61027 | 2105516.61152 | 37.7620140134443 | -122.402200910751 | (37.7620140134443, -122.402200910751) | 10 | 3 | 8 | 28856 | 29 | |||
| 139809 | 67527 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1190 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31065 | 6014447.49903376 | 2104834.36670867 | 37.7602863840457 | -122.393105757767 | (37.7602863840457, -122.393105757767) | 10 | 3 | 8 | 28856 | 29 | ||
| 146940 | 3770 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1098 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
| 154620 | 122471 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 7x6 | 6013475.65456 | 2105166.78328 | 37.7611450920924 | -122.396490237357 | (37.7611450920924, -122.396490237357) | 10 | 3 | 8 | 28856 | 29 | |||
| 155272 | 194566 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 601 Rhode Island St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6011830.82796 | 2105546.54689 | 37.7620961656287 | -122.402205721219 | (37.7620961656287, -122.402205721219) | 10 | 3 | 8 | 28856 | 29 | |||
| 164552 | 194556 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012370.12074 | 2103943.11707 | 37.7577235889979 | -122.400227883634 | (37.7577235889979, -122.400227883634) | 10 | 3 | 8 | 28856 | 29 | |||
| 166566 | 62573 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 801 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1986 12:00:00 AM | Permit Number 22776 | 6011595.8787413 | 2104633.73265 | 37.7595766638959 | -122.402954119848 | (37.7595766638959, -122.402954119848) | 10 | 3 | 8 | 28856 | 29 | ||
| 180526 | 67545 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1015 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 3x3 | Permit Number 31091 | 6012211.61416229 | 2103662.25645514 | 37.7569435678624 | -122.400756337014 | (37.7569435678624, -122.400756337014) | 10 | 3 | 8 | 28856 | 29 |
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) );