trees
28 rows where qSiteInfo = "unknown : Yard" and qSpecies_id = 95 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6379 | 186568 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 39 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984708.7013 | 2104680.5118 | 37.7581670432315 | -122.495945443345 | (37.7581670432315, -122.495945443345) | 1 | 8 | 3 | 56 | 35 | |||
| 8775 | 186544 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 15 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984717.8085 | 2104869.8796 | 37.7586875278599 | -122.495927916751 | (37.7586875278599, -122.495927916751) | 1 | 8 | 3 | 56 | 35 | |||
| 18816 | 185421 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 37 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985094.1378 | 2099288.862 | 37.7433856170495 | -122.494215058601 | (37.7433856170495, -122.494215058601) | 1 | 8 | 3 | 29491 | 35 | |||
| 21617 | 186533 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 4 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984732.4639 | 2104901.2839 | 37.7587746136444 | -122.495879549084 | (37.7587746136444, -122.495879549084) | 1 | 8 | 3 | 56 | 35 | |||
| 36043 | 185476 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985139.6662 | 2098449.3154 | 37.741083112699 | -122.493995774621 | (37.741083112699, -122.493995774621) | 1 | 8 | 3 | 29491 | 35 | |||
| 43178 | 185424 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 40 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985084.6404 | 2099301.8584 | 37.7434207458763 | -122.494248855446 | (37.7434207458763, -122.494248855446) | 1 | 8 | 3 | 29491 | 35 | |||
| 48446 | 185418 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 34 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985092.1383 | 2099264.8686 | 37.7433196206545 | -122.494220204145 | (37.7433196206545, -122.494220204145) | 1 | 8 | 3 | 29491 | 35 | |||
| 49833 | 186558 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 29 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5984755.5984 | 2104741.6454 | 37.7583376456641 | -122.495787764797 | (37.7583376456641, -122.495787764797) | 1 | 8 | 3 | 56 | 35 | |||
| 52493 | 185399 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 12 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985110.1333 | 2099026.9344 | 37.7426673706481 | -122.494140449924 | (37.7426673706481, -122.494140449924) | 1 | 8 | 3 | 29491 | 35 | |||
| 61239 | 186542 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 13 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984733.3013 | 2104876.5792 | 37.7587068304654 | -122.495874830593 | (37.7587068304654, -122.495874830593) | 1 | 8 | 3 | 56 | 35 | |||
| 64392 | 185506 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 60 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5985096.5037 | 2098790.6317 | 37.7420177496615 | -122.494170163503 | (37.7420177496615, -122.494170163503) | 1 | 8 | 3 | 29491 | 35 | |||
| 71340 | 185404 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 18 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985080.6415 | 2099060.4251 | 37.7427576012847 | -122.494244890555 | (37.7427576012847, -122.494244890555) | 1 | 8 | 3 | 29491 | 35 | |||
| 72190 | 186532 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 3 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984706.503 | 2104907.5647 | 37.7587903384946 | -122.495969795836 | (37.7587903384946, -122.495969795836) | 1 | 8 | 3 | 56 | 35 | |||
| 77887 | 185419 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 35 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985098.1367 | 2099271.3668 | 37.7433378139676 | -122.494199942389 | (37.7433378139676, -122.494199942389) | 1 | 8 | 3 | 29491 | 35 | |||
| 97657 | 185422 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 38 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5985084.6404 | 2099285.363 | 37.7433754539691 | -122.494247639854 | (37.7433754539691, -122.494247639854) | 1 | 8 | 3 | 29491 | 35 | |||
| 99224 | 186530 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 1 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984710.6902 | 2104914.2643 | 37.7588089789692 | -122.495955809021 | (37.7588089789692, -122.495955809021) | 1 | 8 | 3 | 56 | 35 | |||
| 103324 | 185401 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 14 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985086.14 | 2099023.9352 | 37.74265773164 | -122.494223189599 | (37.74265773164, -122.494223189599) | 1 | 8 | 3 | 29491 | 35 | |||
| 106271 | 185466 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 18 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985111.7766 | 2098394.8642 | 37.7409319724628 | -122.494088193127 | (37.7409319724628, -122.494088193127) | 1 | 8 | 3 | 29491 | 35 | |||
| 110820 | 185470 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 22 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985119.081 | 2098414.7854 | 37.7409870981235 | -122.494064405444 | (37.7409870981235, -122.494064405444) | 1 | 8 | 3 | 29491 | 35 | |||
| 121852 | 186555 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 26 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5984748.8988 | 2104750.8574 | 37.7583625468943 | -122.495811614145 | (37.7583625468943, -122.495811614145) | 1 | 8 | 3 | 56 | 35 | |||
| 122689 | 185396 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 8 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5985088.1394 | 2098992.4439 | 37.742571382036 | -122.494213955735 | (37.742571382036, -122.494213955735) | 1 | 8 | 3 | 29491 | 35 | |||
| 140121 | 185489 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 42 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985101.1519 | 2098546.2652 | 37.7413470571288 | -122.494136085042 | (37.7413470571288, -122.494136085042) | 1 | 8 | 3 | 29491 | 35 | |||
| 143110 | 186567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 38 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984755.1796 | 2104685.1177 | 37.7581824118079 | -122.495785043438 | (37.7581824118079, -122.495785043438) | 1 | 8 | 3 | 56 | 35 | |||
| 146107 | 186534 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 5 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984706.503 | 2104895.4217 | 37.758756997201 | -122.495968900027 | (37.758756997201, -122.495968900027) | 1 | 8 | 3 | 56 | 35 | |||
| 152267 | 186556 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501 Sunset Blvd | 27 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5984748.0613 | 2104746.2514 | 37.7583498510528 | -122.495814170782 | (37.7583498510528, -122.495814170782) | 1 | 8 | 3 | 56 | 35 | |||
| 181548 | 185492 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 45 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985138.3382 | 2098590.7558 | 37.7414713922408 | -122.494010787869 | (37.7414713922408, -122.494010787869) | 1 | 8 | 3 | 29491 | 35 | |||
| 183894 | 185471 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2400 Sunset Blvd | 23 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985135.682 | 2098419.4337 | 37.7410008324731 | -122.494007348608 | (37.7410008324731, -122.494007348608) | 1 | 8 | 3 | 29491 | 35 | |||
| 192967 | 185420 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2300 Sunset Blvd | 36 | unknown : Yard | Tree | Private 2 | 3 | Width 0ft | 5985096.6371 | 2099279.3646 | 37.7433596860109 | -122.494205716911 | (37.7433596860109, -122.494205716911) | 1 | 8 | 3 | 29491 | 35 |
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) );