trees
27 rows where qSpecies_id = 352
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12772 | 111858 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
| 28465 | 222854 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 964 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009935.05126 | 2103602.67683 | 37.7566527356376 | -122.408625378771 | (37.7566527356376, -122.408625378771) | 2 | 4 | 7 | 28859 | 19 | |||
| 32752 | 222883 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 679 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005893.61563 | 2099281.47644 | 37.7445605359363 | -122.422295138605 | (37.7445605359363, -122.422295138605) | 2 | 7 | 5 | 28859 | 2 | |||
| 38002 | 205985 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 200 Bella Vista Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997956.73419 | 2097075.75053 | 37.7380532484554 | -122.449580248432 | (37.7380532484554, -122.449580248432) | 9 | 7 | 4 | 59 | 40 | |||
| 44526 | 222857 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 288 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004623.04841 | 2100187.63546 | 37.7469768883695 | -122.426753025836 | (37.7469768883695, -122.426753025836) | 2 | 7 | 5 | 63 | 22 | |||
| 45454 | 205981 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 60 Sequoia Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998130.19896 | 2097111.68533 | 37.7381618389078 | -122.448983085099 | (37.7381618389078, -122.448983085099) | 9 | 7 | 4 | 59 | 40 | |||
| 49598 | 205986 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 673 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5996963.74906 | 2095261.14113 | 37.7330139117665 | -122.452882532027 | (37.7330139117665, -122.452882532027) | 9 | 7 | 4 | 59 | 40 | |||
| 59455 | 111853 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | |||
| 71655 | 111854 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
| 74103 | 125949 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 1933 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006900.12567 | 2117933.56187 | 37.7958314596087 | -122.420138294569 | (37.7958314596087, -122.420138294569) | 13 | 9 | 10 | 28858 | 32 | |||
| 76184 | 84900 | Permitted Site 7 | Celtis occidentalis :: Common Hackberry 352 | 3710 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2016 12:00:00 AM | 3 | Permit Number 778171 | 5997027 | 2115696 | 37.7891264773261 | -122.454139271098 | (37.7891264773261, -122.454139271098) | 11 | 6 | 1 | 54 | 31 | ||
| 87080 | 205983 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 200 Bella Vista Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997901.29639 | 2097060.51041 | 37.7380082310866 | -122.449770825587 | (37.7380082310866, -122.449770825587) | 9 | 7 | 4 | 59 | 40 | |||
| 94741 | 111857 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
| 115999 | 125951 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 1933 Larkin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006904.83572 | 2117894.84489 | 37.7957254178521 | -122.420119247824 | (37.7957254178521, -122.420119247824) | 13 | 9 | 10 | 28858 | 32 | |||
| 117381 | 125950 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 1933 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006902.72309 | 2117913.82485 | 37.7957774130398 | -122.42012790558 | (37.7957774130398, -122.42012790558) | 13 | 9 | 10 | 28858 | 32 | |||
| 119448 | 6666 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 1550 Evans Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6015925.87475 | 2098394.93873 | 37.7426870781414 | -122.38754344888 | (37.7426870781414, -122.38754344888) | 10 | 3 | 8 | 58 | 1 | |||
| 119684 | 47529 | Permitted Site 7 | Celtis occidentalis :: Common Hackberry 352 | 288 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45401 | 6004641.86510431 | 2100190.20184549 | 37.7469849989235 | -122.426688142062 | (37.7469849989235, -122.426688142062) | 2 | 7 | 5 | 63 | 22 | ||
| 120508 | 47530 | Permitted Site 7 | Celtis occidentalis :: Common Hackberry 352 | 288 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45401 | 6004641.86510431 | 2100190.20184549 | 37.7469849989235 | -122.426688142062 | (37.7469849989235, -122.426688142062) | 2 | 7 | 5 | 63 | 22 | ||
| 120888 | 111855 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
| 126358 | 125947 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 1933 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006894.44558 | 2117973.79394 | 37.7959416067615 | -122.420160805479 | (37.7959416067615, -122.420160805479) | 13 | 9 | 10 | 28858 | 32 | |||
| 146565 | 125948 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 1933 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006897.0279 | 2117953.30948 | 37.7958855070617 | -122.420150415634 | (37.7958855070617, -122.420150415634) | 13 | 9 | 10 | 28858 | 32 | |||
| 153609 | 205982 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 60 Sequoia Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998135.25784 | 2097187.71393 | 37.7383708845091 | -122.448971069279 | (37.7383708845091, -122.448971069279) | 9 | 7 | 4 | 59 | 40 | |||
| 166028 | 222858 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 242 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007887.98242 | 2097488.409 | 37.7397494660759 | -122.415272091755 | (37.7397494660759, -122.415272091755) | 2 | 7 | 7 | 28859 | 2 | |||
| 178196 | 111856 | Undocumented 4 | Celtis occidentalis :: Common Hackberry 352 | 99x DE LONG ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994668 | 2086747 | 37.7095042936171 | -122.460202848357 | (37.7095042936171, -122.460202848357) | 9 | 8 | 6 | 28861 | 25 | ||||
| 179757 | 222855 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 315 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008569.09879 | 2100204.29393 | 37.7472449430096 | -122.413109062136 | (37.7472449430096, -122.413109062136) | 2 | 7 | 7 | 28859 | 2 | |||
| 180602 | 222856 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 288 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004655.35699 | 2100188.5096 | 37.7469811151847 | -122.426641367798 | (37.7469811151847, -122.426641367798) | 2 | 7 | 5 | 63 | 22 | |||
| 193972 | 205984 | DPW Maintained 1 | Celtis occidentalis :: Common Hackberry 352 | 200 Bella Vista Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997930.8115 | 2097068.44955 | 37.7380317186897 | -122.449669349666 | (37.7380317186897, -122.449669349666) | 9 | 7 | 4 | 59 | 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) );