trees
30 rows where Zip Codes = 28858 and qSpecies_id = 138
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 772 | 132391 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 2 | Side Yard : Yard | Tree | Private 2 | 31 | 6006489.42377 | 2120936.29447 | 37.8040530536607 | -122.421772791676 | (37.8040530536607, -122.421772791676) | 5 | 9 | 1 | 28858 | 32 | ||||
| 7343 | 132389 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005789.48501 | 2119659.27806 | 37.8005071977157 | -122.424104109619 | (37.8005071977157, -122.424104109619) | 13 | 9 | 1 | 28858 | 32 | |||
| 7497 | 132404 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2671 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6007312.64985 | 2121879.37275 | 37.8066888955423 | -122.418990884623 | (37.8066888955423, -122.418990884623) | 5 | 1 | 1 | 28858 | 32 | ||||
| 20855 | 132373 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6008208.92851 | 2117034.44521 | 37.7934363635562 | -122.415545890356 | (37.7934363635562, -122.415545890356) | 5 | 1 | 10 | 28858 | 21 | ||||
| 33095 | 132372 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008211.08199 | 2117028.50784 | 37.793420182046 | -122.415538018574 | (37.793420182046, -122.415538018574) | 5 | 1 | 10 | 28858 | 21 | ||||
| 41291 | 132397 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 3 | Side Yard : Yard | Tree | Private 2 | 16 | 6006502.73263 | 2120950.76111 | 37.8040935258618 | -122.421727763529 | (37.8040935258618, -122.421727763529) | 5 | 9 | 1 | 28858 | 32 | ||||
| 46550 | 132399 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 5 | Side Yard : Yard | Tree | Private 2 | 12 | 6006512.34183 | 2120961.63143 | 37.8041239148476 | -122.421695282708 | (37.8041239148476, -122.421695282708) | 5 | 9 | 1 | 28858 | 32 | ||||
| 46646 | 132387 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005806.0966 | 2119662.42569 | 37.8005167781868 | -122.424046850703 | (37.8005167781868, -122.424046850703) | 13 | 9 | 1 | 28858 | 32 | |||
| 70489 | 132376 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6008205.53038 | 2117047.83844 | 37.7934729470596 | -122.41555859686 | (37.7934729470596, -122.41555859686) | 5 | 1 | 10 | 28858 | 21 | ||||
| 70730 | 132371 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6008212.29618 | 2117019.56331 | 37.7933956908179 | -122.415533183814 | (37.7933956908179, -122.415533183814) | 5 | 1 | 10 | 28858 | 21 | ||||
| 75786 | 132400 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2745 Larkin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6006513.74992 | 2120658.41667 | 37.8032914438996 | -122.421668860656 | (37.8032914438996, -122.421668860656) | 5 | 9 | 1 | 28858 | 32 | ||||
| 81447 | 132374 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008210.17068 | 2117040.38905 | 37.7934527536983 | -122.415542013359 | (37.7934527536983, -122.415542013359) | 5 | 1 | 10 | 28858 | 21 | ||||
| 86472 | 132386 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005813.32494 | 2119673.13314 | 37.8005465862138 | -122.424022599558 | (37.8005465862138, -122.424022599558) | 13 | 9 | 1 | 28858 | 32 | |||
| 91207 | 132384 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005841.24215 | 2119667.51872 | 37.8005327465563 | -122.4239255951 | (37.8005327465563, -122.4239255951) | 13 | 9 | 1 | 28858 | 32 | |||
| 101309 | 132392 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 3 | Side Yard : Yard | Tree | Private 2 | 16 | 6006479.36293 | 2120932.81603 | 37.8040429353981 | -122.421807360741 | (37.8040429353981, -122.421807360741) | 5 | 9 | 1 | 28858 | 32 | ||||
| 103490 | 132393 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 4 | Side Yard : Yard | Tree | Private 2 | 17 | 6006475.56322 | 2120927.38496 | 37.8040278087899 | -122.42182012391 | (37.8040278087899, -122.42182012391) | 5 | 9 | 1 | 28858 | 32 | ||||
| 103701 | 132390 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005781.12616 | 2119669.33652 | 37.8005343437344 | -122.424133750381 | (37.8005343437344, -122.424133750381) | 13 | 9 | 1 | 28858 | 32 | |||
| 105760 | 132396 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 2 | Side Yard : Yard | Tree | Private 2 | 40 | 6006504.32212 | 2120945.10898 | 37.8040780961887 | -122.421721861273 | (37.8040780961887, -122.421721861273) | 5 | 9 | 1 | 28858 | 32 | ||||
| 112854 | 132388 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6005798.70292 | 2119672.07683 | 37.800542860316 | -122.424073122581 | (37.800542860316, -122.424073122581) | 13 | 9 | 1 | 28858 | 32 | |||
| 114212 | 132395 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | 6006513.4872 | 2120932.40539 | 37.8040437321931 | -122.42168924197 | (37.8040437321931, -122.42168924197) | 5 | 9 | 1 | 28858 | 32 | ||||
| 118614 | 132377 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6008207.47508 | 2117062.00893 | 37.7935119650452 | -122.415552871766 | (37.7935119650452, -122.415552871766) | 5 | 1 | 10 | 28858 | 21 | ||||
| 126244 | 132370 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008212.89333 | 2117013.50059 | 37.793379077647 | -122.415530688191 | (37.793379077647, -122.415530688191) | 5 | 1 | 10 | 28858 | 21 | ||||
| 135405 | 132385 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1468 Greenwich St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6005829.91288 | 2119675.1182 | 37.8005529731893 | -122.423965339721 | (37.8005529731893, -122.423965339721) | 13 | 9 | 1 | 28858 | 32 | |||
| 138698 | 132398 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2836 Larkin St | 4 | Side Yard : Yard | Tree | Private 2 | 6 | 6006507.37075 | 2120957.56173 | 37.8041124601724 | -122.421712196283 | (37.8041124601724, -122.421712196283) | 5 | 9 | 1 | 28858 | 32 | ||||
| 147385 | 132375 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6008208.36982 | 2117045.10307 | 37.793465596011 | -122.415548578397 | (37.793465596011, -122.415548578397) | 5 | 1 | 10 | 28858 | 21 | ||||
| 150829 | 132405 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2671 Leavenworth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6007317.65081 | 2121868.01026 | 37.8066579786473 | -122.418972771382 | (37.8066579786473, -122.418972771382) | 5 | 1 | 1 | 28858 | 32 | ||||
| 166977 | 132406 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2671 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6007315.11916 | 2121861.54657 | 37.8066400884465 | -122.418981073917 | (37.8066400884465, -122.418981073917) | 5 | 1 | 1 | 28858 | 32 | ||||
| 168549 | 132378 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 20 Reed St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6008205.50053 | 2117066.58011 | 37.7935244053907 | -122.415560027676 | (37.7935244053907, -122.415560027676) | 5 | 1 | 10 | 28858 | 21 | ||||
| 183720 | 132401 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2745 Larkin St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6006539.02476 | 2120646.91478 | 37.8032612878284 | -122.421580578682 | (37.8032612878284, -122.421580578682) | 5 | 9 | 1 | 28858 | 32 | ||||
| 189760 | 132394 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 6006476.08021 | 2120921.35396 | 37.8040112783592 | -122.421817906176 | (37.8040112783592, -122.421817906176) | 5 | 9 | 1 | 28858 | 32 |
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) );