trees
25 rows where Neighborhoods (old) = 21 and qSpecies_id = 143
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6754 | 132428 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6008612.46815 | 2118979.35525 | 37.7987992808082 | -122.414287281056 | (37.7987992808082, -122.414287281056) | 5 | 1 | 10 | 308 | 21 | ||||
| 25980 | 132432 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 2 | Side Yard : Yard | Tree | Private 2 | 2 | 6008616.66785 | 2118981.63248 | 37.7988057694225 | -122.41427290989 | (37.7988057694225, -122.41427290989) | 5 | 1 | 10 | 308 | 21 | ||||
| 28810 | 132415 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 4 | Back Yard : Yard | Tree | Private 2 | 8 | Width 10ft | 6009831.3064 | 2117286.6196 | 37.7942198322406 | -122.409950127822 | (37.7942198322406, -122.409950127822) | 3 | 1 | 10 | 28857 | 21 | |||
| 57506 | 132427 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 4 | Front Yard : Yard | Tree | Private 2 | 3 | 6008608.8618 | 2118977.06556 | 37.7987927913102 | -122.414299598148 | (37.7987927913102, -122.414299598148) | 5 | 1 | 10 | 308 | 21 | ||||
| 70640 | 132422 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Vallejo St | 1 | Side Yard : Yard | Tree | Private 2 | 5 | 6008806.49903 | 2118647.23011 | 37.7978982446696 | -122.413592365905 | (37.7978982446696, -122.413592365905) | 3 | 1 | 10 | 308 | 21 | ||||
| 72792 | 132436 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 6 | Side Yard : Yard | Tree | Private 2 | 4 | 6008624.64494 | 2118991.49832 | 37.7988333066551 | -122.414246004875 | (37.7988333066551, -122.414246004875) | 5 | 1 | 10 | 308 | 21 | ||||
| 91301 | 132435 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 5 | Side Yard : Yard | Tree | Private 2 | 3 | 6008622.60306 | 2118990.33445 | 37.7988299962621 | -122.414252988079 | (37.7988299962621, -122.414252988079) | 5 | 1 | 10 | 308 | 21 | ||||
| 97135 | 132425 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 941 Vallejo St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6008897.86349 | 2118673.31668 | 37.79797500181 | -122.413278063645 | (37.79797500181, -122.413278063645) | 3 | 1 | 10 | 308 | 21 | ||||
| 98104 | 132438 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 9 | Side Yard : Yard | Tree | Private 2 | 6 | 6008636.9513 | 2118981.46679 | 37.7988064538179 | -122.414202710601 | (37.7988064538179, -122.414202710601) | 5 | 1 | 10 | 308 | 21 | ||||
| 102924 | 132437 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 7 | Side Yard : Yard | Tree | Private 2 | 15 | 6008631.99788 | 2118976.07541 | 37.7987913721926 | -122.414219469452 | (37.7987913721926, -122.414219469452) | 5 | 1 | 10 | 308 | 21 | ||||
| 103880 | 132430 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6008611.92512 | 2118990.49099 | 37.7988298262824 | -122.414289948436 | (37.7988298262824, -122.414289948436) | 5 | 1 | 10 | 308 | 21 | ||||
| 105428 | 132417 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6008339.95613 | 2117059.59753 | 37.7935127897381 | -122.415094304772 | (37.7935127897381, -122.415094304772) | 5 | 1 | 10 | 28858 | 21 | |||
| 110538 | 132424 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Vallejo St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | 6008826.96262 | 2118671.13776 | 37.7979650382118 | -122.413523247611 | (37.7979650382118, -122.413523247611) | 3 | 1 | 10 | 308 | 21 | ||||
| 110593 | 132412 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 7 | Back Yard : Yard | Tree | Private 2 | 6 | Width 10ft | 6009828.26061 | 2117303.30498 | 37.7942654755313 | -122.409961845076 | (37.7942654755313, -122.409961845076) | 3 | 1 | 10 | 28857 | 21 | |||
| 111610 | 132423 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Vallejo St | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6008817.55248 | 2118666.35728 | 37.7979513838133 | -122.413555471214 | (37.7979513838133, -122.413555471214) | 3 | 1 | 10 | 308 | 21 | ||||
| 112538 | 132414 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 5 | Back Yard : Yard | Tree | Private 2 | 15 | Width 10ft | 6009830.16346 | 2117290.71414 | 37.7942310107947 | -122.409954371722 | (37.7942310107947, -122.409954371722) | 3 | 1 | 10 | 28857 | 21 | |||
| 128063 | 132419 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6008343.95149 | 2117067.4702 | 37.7935346306753 | -122.415081037978 | (37.7935346306753, -122.415081037978) | 5 | 1 | 10 | 28858 | 21 | |||
| 130643 | 132429 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 6 | Front Yard : Yard | Tree | Private 2 | 3 | 6008611.37888 | 2118984.10383 | 37.7988122580431 | -122.414291386455 | (37.7988122580431, -122.414291386455) | 5 | 1 | 10 | 308 | 21 | ||||
| 137325 | 132413 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 8 Codman Pl | 6 | Back Yard : Yard | Tree | Private 2 | 11 | Width 10ft | 6009827.38182 | 2117300.98565 | 37.7942590579634 | -122.409964721995 | (37.7942590579634, -122.409964721995) | 3 | 1 | 10 | 28857 | 21 | |||
| 138247 | 132433 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 1 | Side Yard : Yard | Tree | Private 2 | 2 | 6008619.19252 | 2118974.8638 | 37.7987873261227 | -122.414263694525 | (37.7987873261227, -122.414263694525) | 5 | 1 | 10 | 308 | 21 | ||||
| 149677 | 132434 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 4 | Side Yard : Yard | Tree | Private 2 | 3 | 6008620.99227 | 2118990.50136 | 37.7988303640752 | -122.414258573772 | (37.7988303640752, -122.414258573772) | 5 | 1 | 10 | 308 | 21 | ||||
| 150891 | 132416 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6008344.60372 | 2117052.50272 | 37.7934935703107 | -122.415077721275 | (37.7934935703107, -122.415077721275) | 5 | 1 | 10 | 28858 | 21 | |||
| 180305 | 132426 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 945 Green St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6008604.37776 | 2118975.38502 | 37.798787925083 | -122.414314995462 | (37.798787925083, -122.414314995462) | 5 | 1 | 10 | 308 | 21 | ||||
| 182907 | 132431 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 943 Green St | 3 | Side Yard : Yard | Tree | Private 2 | 2 | 6008617.41774 | 2118989.29744 | 37.7988268576225 | -122.414270857625 | (37.7988268576225, -122.414270857625) | 5 | 1 | 10 | 308 | 21 | ||||
| 190542 | 132418 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Priest St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6008344.17641 | 2117062.85198 | 37.7935219628191 | -122.415079932693 | (37.7935219628191, -122.415079932693) | 5 | 1 | 10 | 28858 | 21 |
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) );