trees
26 rows where SiteOrder = 1 and qSpecies_id = 118
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 551 | 234021 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6009064.54563 | 2097789.74594 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | 10 | 7 | 7 | 28859 | 2 | |||
| 14572 | 211520 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 136 Caine Ave | 1 | : | Tree | Private 2 | 7 | Width 10ft | 5997136.50298 | 2089006.99788 | 37.7158514071876 | -122.451834257948 | (37.7158514071876, -122.451834257948) | 9 | 8 | 6 | 28861 | 24 | |||
| 27256 | 234018 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 415 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6003158.64074 | 2099182.55202 | 37.7441342590911 | -122.431745065405 | (37.7441342590911, -122.431745065405) | 2 | 7 | 5 | 63 | 22 | |||
| 29733 | 97339 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1223 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5989371.5403 | 2098984.5119 | 37.7427993278144 | -122.47940279801 | (37.7427993278144, -122.47940279801) | 1 | 8 | 3 | 29491 | 35 | |||
| 37436 | 109105 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 461X Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2015 12:00:00 AM | 3 | Permit Number 774020 | 5996243.86079 | 2114742.72809 | 37.7864641110096 | -122.456779845468 | (37.7864641110096, -122.456779845468) | 11 | 6 | 1 | 54 | 31 | ||
| 40371 | 234017 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 425 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6003150.22135 | 2099188.97086 | 37.744151406477 | -122.431774635991 | (37.744151406477, -122.431774635991) | 2 | 7 | 5 | 63 | 22 | ||||
| 41155 | 132450 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1270 Clay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008641.43402 | 2116990.25696 | 37.793339334804 | -122.414046256445 | (37.793339334804, -122.414046256445) | 5 | 1 | 10 | 28857 | 21 | |||
| 47086 | 211517 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 2112 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5990709.94109 | 2100999.41898 | 37.7484093878914 | -122.474922077987 | (37.7484093878914, -122.474922077987) | 1 | 8 | 4 | 29491 | 40 | |||
| 50189 | 234019 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 410 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003269.19484 | 2099235.34019 | 37.7442854692996 | -122.431366561412 | (37.7442854692996, -122.431366561412) | 2 | 7 | 5 | 63 | 22 | |||
| 51038 | 132459 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1109 Chestnut St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6006454.20417 | 2120400.58953 | 37.8025801584021 | -122.421856595917 | (37.8025801584021, -122.421856595917) | 5 | 9 | 1 | 28858 | 32 | ||||
| 52652 | 132449 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1341 Bay St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6004363.25375 | 2120796.06015 | 37.8035478784015 | -122.429120545984 | (37.8035478784015, -122.429120545984) | 13 | 9 | 1 | 28858 | 17 | |||
| 57660 | 132463 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 10 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6007395.04412 | 2119352.97645 | 37.7997566900644 | -122.418526481017 | (37.7997566900644, -122.418526481017) | 5 | 1 | 1 | 28858 | 32 | |||
| 62188 | 211516 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1919 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993127.72068 | 2102391.52217 | 37.752371564303 | -122.46666269445 | (37.752371564303, -122.46666269445) | 1 | 8 | 4 | 29491 | 12 | |||
| 72704 | 2625 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1843 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004676.1259 | 2115014.606 | 37.7876911844813 | -122.427625683257 | (37.7876911844813, -122.427625683257) | 13 | 9 | 11 | 28858 | 27 | |||
| 75018 | 178425 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 102 Bowdoin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6008414.59358 | 2094563.5798 | 37.7317481033768 | -122.413244512629 | (37.7317481033768, -122.413244512629) | 9 | 3 | 7 | 309 | 28 | |||
| 81830 | 17109 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1809 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5998305.0552 | 2109267.4722 | 37.7715486168192 | -122.449254046357 | (37.7715486168192, -122.449254046357) | 15 | 5 | 11 | 29492 | 9 | |||
| 91980 | 211536 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 334 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5997845.92784 | 2093590.624 | 37.7284775820656 | -122.449712283304 | (37.7284775820656, -122.449712283304) | 9 | 7 | 4 | 28861 | 40 | |||
| 98583 | 25372 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 1134 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1996 12:00:00 AM | 3 | 3X3 | 6001336.17652 | 2088457.24533 | 37.7145815500755 | -122.437278923085 | (37.7145815500755, -122.437278923085) | 9 | 7 | 6 | 28861 | 5 | ||
| 122399 | 52950 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 781 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 5 | Permit Number 48937 | 6001329.274 | 2092453.83247 | 37.7255548870432 | -122.43758882319 | (37.7255548870432, -122.43758882319) | 9 | 7 | 6 | 28861 | 25 | |
| 133140 | 234029 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 51 Farnum St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002399.82975 | 2097539.15383 | 37.7395788278074 | -122.434251398596 | (37.7395788278074, -122.434251398596) | 2 | 7 | 5 | 63 | 7 | |||
| 137495 | 61224 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 37 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1983 12:00:00 AM | 6 | Permit Number 21093 | 6005096.46988 | 2093267.08019 | 37.7280013568595 | -122.424623758583 | (37.7280013568595, -122.424623758583) | 9 | 7 | 6 | 28861 | 5 | ||
| 140363 | 178421 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 10x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6011808.96151 | 2090776.02497 | 37.7215382422674 | -122.401243362991 | (37.7215382422674, -122.401243362991) | 10 | 3 | 8 | 309 | 28 | |||
| 146910 | 178427 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 316 Naylor St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6002735.25453 | 2086567.49081 | 37.7094721319023 | -122.432308262228 | (37.7094721319023, -122.432308262228) | 9 | 7 | 6 | 28861 | 5 | ||||
| 151705 | 234026 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 415 Beacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6002307.79046 | 2098328.73055 | 37.7417415974879 | -122.434626074129 | (37.7417415974879, -122.434626074129) | 2 | 7 | 5 | 63 | 7 | |||
| 152781 | 234020 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 131 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998015.60548 | 2106190.06538 | 37.7630822803398 | -122.450033424896 | (37.7630822803398, -122.450033424896) | 15 | 5 | 11 | 29492 | 9 | |||
| 180181 | 118772 | DPW Maintained 1 | Pittosporum tobira :: Japanese Mockorange 118 | 5355 Anza St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 1ft | 5981988.79716 | 2111633.19692 | 37.7770974313835 | -122.505867335722 | (37.7770974313835, -122.505867335722) | 11 | 6 | 2 | 55 | 26 |
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) );