trees
147 rows where qSpecies_id = 138 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86982 | 132364 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1 Maple St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 5996506.6886 | 2116107.76814 | 37.7902272326358 | -122.455969252601 | (37.7902272326358, -122.455969252601) | 11 | 6 | 1 | 54 | 31 | ||||
| 145526 | 26412 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996536.01908 | 2116115.1957 | 37.7902493101054 | -122.455868309095 | (37.7902493101054, -122.455868309095) | 11 | 6 | 1 | 54 | 31 | |||
| 45486 | 26410 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996557.37762 | 2116117.21494 | 37.7902560801893 | -122.455794556583 | (37.7902560801893, -122.455794556583) | 11 | 6 | 1 | 54 | 31 | |||
| 7200 | 26411 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996554.84409 | 2116119.62648 | 37.7902625562289 | -122.455803496757 | (37.7902625562289, -122.455803496757) | 11 | 6 | 1 | 54 | 31 | |||
| 155946 | 26409 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 34 Maple St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 10 | 5996561.54746 | 2116120.98746 | 37.790266677821 | -122.455780402146 | (37.790266677821, -122.455780402146) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 165064 | 132360 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2801 Pierce St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6001534.76184 | 2118041.80057 | 37.7958248873699 | -122.43871117439 | (37.7958248873699, -122.43871117439) | 13 | 9 | 1 | 57 | 17 | |||
| 104902 | 132383 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6008731.67478 | 2118716.17732 | 37.7980833548266 | -122.413856159533 | (37.7980833548266, -122.413856159533) | 5 | 1 | 10 | 308 | 21 | |||
| 187031 | 132382 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008728.03476 | 2118737.75818 | 37.7981424061004 | -122.413870282493 | (37.7981424061004, -122.413870282493) | 5 | 1 | 10 | 308 | 21 | |||
| 85702 | 132381 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1713 Taylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008727.87126 | 2118754.69526 | 37.7981889019448 | -122.413872046978 | (37.7981889019448, -122.413872046978) | 5 | 1 | 10 | 308 | 21 | |||
| 38648 | 132379 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1680 Taylor St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6008770.01559 | 2118776.57909 | 37.7982513562644 | -122.413727763334 | (37.7982513562644, -122.413727763334) | 3 | 1 | 10 | 308 | 21 | |||
| 1832 | 132380 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 1680 Taylor St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6008764.12173 | 2118820.69014 | 37.7983721433051 | -122.4137512797 | (37.7983721433051, -122.4137512797) | 3 | 1 | 10 | 308 | 21 | |||
| 166886 | 132402 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 93 MacOndray Ln | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6008127.0764 | 2119094.13477 | 37.7990871592098 | -122.41597503153 | (37.7990871592098, -122.41597503153) | 5 | 1 | 10 | 308 | 32 | ||||
| 111427 | 132403 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 93 MacOndray Ln | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6008160.59399 | 2119098.20458 | 37.7991002182567 | -122.415859337341 | (37.7991002182567, -122.415859337341) | 5 | 1 | 10 | 308 | 32 | ||||
| 191721 | 132366 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5999060.87332 | 2119508.71315 | 37.7997115890667 | -122.44737688965 | (37.7997115890667, -122.44737688965) | 13 | 9 | 1 | 57 | 17 | |||
| 62400 | 132367 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 5999061.27495 | 2119513.94993 | 37.7997259908076 | -122.447375876998 | (37.7997259908076, -122.447375876998) | 13 | 9 | 1 | 57 | 17 | |||
| 102389 | 132368 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999060.82328 | 2119520.36984 | 37.7997435923452 | -122.44737790227 | (37.7997435923452, -122.44737790227) | 13 | 9 | 1 | 57 | 17 | |||
| 173279 | 132369 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 3100 Lyon St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 5999059.80174 | 2119527.53037 | 37.7997631948618 | -122.447381952832 | (37.7997631948618, -122.447381952832) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 |
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) );