trees
46 rows where qSiteInfo = ":" 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 356 | 233580 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1317 Clayton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5999035.80578 | 2105154.14715 | 37.7602962318988 | -122.44643038196 | (37.7602962318988, -122.44643038196) | 15 | 5 | 5 | 28862 | 12 | |||
| 1925 | 250092 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1698 Gough St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6005353.59952 | 2115427.24795 | 37.7888624934521 | -122.425311128409 | (37.7888624934521, -122.425311128409) | 13 | 9 | 1 | 28858 | 41 | |||
| 6249 | 211394 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 7 | Width 0ft | 5991385.47593 | 2094405.95622 | 37.7303445458499 | -122.472105586627 | (37.7303445458499, -122.472105586627) | 9 | 8 | 4 | 64 | 40 | |||
| 11059 | 211396 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 51 | : | Tree | Private 2 | 7 | Width 0ft | 5991320.25705 | 2093401.75426 | 37.7275834841643 | -122.47225788142 | (37.7275834841643, -122.47225788142) | 9 | 8 | 4 | 64 | 40 | |||
| 15032 | 194567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 382 Texas St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6013743.43847 | 2105323.69355 | 37.7615908320593 | -122.39557507463 | (37.7615908320593, -122.39557507463) | 10 | 3 | 8 | 28856 | 29 | |||
| 20008 | 211390 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2650 Ocean Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5990847.61184 | 2095069.65552 | 37.7321357561478 | -122.474013443484 | (37.7321357561478, -122.474013443484) | 1 | 8 | 4 | 64 | 40 | |||
| 20689 | 250642 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 3 | : | Tree | Private 2 | 9 | Width 3ft | 5987348.36119 | 2114656.80551 | 37.7857134039994 | -122.487549334736 | (37.7857134039994, -122.487549334736) | 11 | 6 | 1 | 55 | 33 | |||
| 32340 | 194551 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 364 09th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009495.1726 | 2109485.56506 | 37.7727811529595 | -122.410562055301 | (37.7727811529595, -122.410562055301) | 8 | 2 | 9 | 28853 | 34 | |||
| 38659 | 211381 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2611 Ocean Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5990943.4517 | 2094937.26304 | 37.7317777909083 | -122.47367245292 | (37.7317777909083, -122.47367245292) | 1 | 8 | 4 | 64 | 40 | |||
| 40465 | 211384 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991108.5892 | 2094839.96583 | 37.7315201998923 | -122.473094451455 | (37.7315201998923, -122.473094451455) | 1 | 8 | 4 | 64 | 40 | |||
| 45357 | 211399 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 58 | : | Tree | Private 2 | 1 | Width 0ft | 5991315.94371 | 2093311.6752 | 37.7273358999139 | -122.472266228913 | (37.7273358999139, -122.472266228913) | 9 | 8 | 4 | 64 | 40 | |||
| 49616 | 211383 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Ocean Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5991035.59331 | 2094881.14512 | 37.7316290412296 | -122.473349812154 | (37.7316290412296, -122.473349812154) | 1 | 8 | 4 | 64 | 40 | |||
| 58810 | 211398 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 57 | : | Tree | Private 2 | 1 | Width 0ft | 5991312.42459 | 2093316.55821 | 37.7273491037745 | -122.472278750188 | (37.7273491037745, -122.472278750188) | 9 | 8 | 4 | 64 | 40 | |||
| 60869 | 211378 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2666 Ocean Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5990751.88782 | 2095123.64703 | 37.7322784578663 | -122.474348317746 | (37.7322784578663, -122.474348317746) | 1 | 8 | 4 | 64 | 40 | |||
| 66833 | 194572 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 16 Waterville St | 1 | : | Tree | Private 2 | 7 | Width 1ft | 6011439.22525 | 2096039.9768 | 37.7359713251222 | -122.402891486647 | (37.7359713251222, -122.402891486647) | 10 | 3 | 8 | 58 | 1 | |||
| 67313 | 211397 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 56 | : | Tree | Private 2 | 1 | Width 0ft | 5991314.17721 | 2093323.33427 | 37.7273678105764 | -122.47227318518 | (37.7273678105764, -122.47227318518) | 9 | 8 | 4 | 64 | 40 | |||
| 69096 | 250044 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 50 Daniel Burnham Ct | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6006103.91102 | 2114728.75615 | 37.7869869690171 | -122.422665493826 | (37.7869869690171, -122.422665493826) | 13 | 9 | 1 | 28858 | 41 | |||
| 72248 | 211386 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2525 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991180.22123 | 2094794.23691 | 37.7313987869056 | -122.472843474954 | (37.7313987869056, -122.472843474954) | 1 | 8 | 4 | 64 | 40 | |||
| 79049 | 194552 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1084 Natoma St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6007595.2752 | 2109454.36065 | 37.772588775377 | -122.417131820472 | (37.772588775377, -122.417131820472) | 8 | 2 | 9 | 28853 | 19 | |||
| 79568 | 211403 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 79 | : | Tree | Private 2 | 8 | Width 0ft | 5991310.66236 | 2093194.76512 | 37.7270145883399 | -122.472275967673 | (37.7270145883399, -122.472275967673) | 9 | 8 | 4 | 64 | 40 | |||
| 84089 | 211400 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 59 | : | Tree | Private 2 | 1 | Width 0ft | 5991311.81969 | 2093306.95297 | 37.7273226951736 | -122.472280141417 | (37.7273226951736, -122.472280141417) | 9 | 8 | 4 | 64 | 40 | |||
| 85849 | 211395 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 33 | : | Tree | Private 2 | 4 | Width 0ft | 5991333.87103 | 2093589.42077 | 37.7280995574272 | -122.472224492267 | (37.7280995574272, -122.472224492267) | 9 | 8 | 4 | 64 | 40 | |||
| 85921 | 194565 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 601 Rhode Island St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6011831.4934 | 2105538.22231 | 37.7620733453319 | -122.402202834406 | (37.7620733453319, -122.402202834406) | 10 | 3 | 8 | 28856 | 29 | |||
| 96051 | 250646 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 7 | : | Tree | Private 2 | 8 | Width 3ft | 5987286.31285 | 2114656.02961 | 37.7857076546263 | -122.487763944473 | (37.7857076546263, -122.487763944473) | 11 | 6 | 1 | 55 | 33 | |||
| 106772 | 211392 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 11 | : | Tree | Private 2 | 24 | Width 0ft | 5991388.85233 | 2094538.65756 | 37.7307091058353 | -122.472103582919 | (37.7307091058353, -122.472103582919) | 9 | 8 | 4 | 64 | 40 | |||
| 110987 | 211387 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2523 Ocean Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5991235.72869 | 2094765.49267 | 37.7313230756794 | -122.472649482185 | (37.7313230756794, -122.472649482185) | 1 | 8 | 4 | 64 | 40 | |||
| 113548 | 194571 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 10 Bridgeview Dr | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6014067.17218 | 2095407.62951 | 37.7343814199646 | -122.393761306632 | (37.7343814199646, -122.393761306632) | 10 | 3 | 8 | 58 | 1 | |||
| 113999 | 211385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2555 Ocean Ave | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5991126.50204 | 2094829.45786 | 37.731492384761 | -122.473031757922 | (37.731492384761, -122.473031757922) | 1 | 8 | 4 | 64 | 40 | |||
| 116711 | 211401 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 62 | : | Tree | Private 2 | 12 | Width 0ft | 5991312.10074 | 2093282.10012 | 37.7272544717134 | -122.472277358928 | (37.7272544717134, -122.472277358928) | 9 | 8 | 4 | 64 | 40 | |||
| 121279 | 211380 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2645 Ocean Ave | 3 | : | Tree | Private 2 | 9 | Width 3ft | 5990864.72749 | 2094979.44437 | 37.731889050535 | -122.473947692236 | (37.731889050535, -122.473947692236) | 1 | 8 | 4 | 64 | 40 | |||
| 124879 | 194570 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 10 Bridgeview Dr | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6014071.17827 | 2095379.66213 | 37.7343048498944 | -122.393745499263 | (37.7343048498944, -122.393745499263) | 10 | 3 | 8 | 58 | 1 | |||
| 126519 | 211379 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2661 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5990752.61196 | 2095053.16145 | 37.7320849642463 | -122.474340672589 | (37.7320849642463, -122.474340672589) | 1 | 8 | 4 | 64 | 40 | |||
| 127092 | 211374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 446 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993509.98372 | 2088840.25773 | 37.7151852037961 | -122.464356993699 | (37.7151852037961, -122.464356993699) | 9 | 8 | 6 | 64 | 24 | |||
| 129924 | 211388 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2528 Ocean Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991260.83689 | 2094823.54256 | 37.7314839194419 | -122.472566910044 | (37.7314839194419, -122.472566910044) | 1 | 8 | 4 | 64 | 40 | |||
| 137150 | 211393 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 13 | : | Tree | Private 2 | 20 | Width 0ft | 5991388.09058 | 2094530.01431 | 37.7306853295574 | -122.472105586615 | (37.7306853295574, -122.472105586615) | 9 | 8 | 4 | 64 | 40 | |||
| 140380 | 211402 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500 Junipero Serra Blvd | 77 | : | Tree | Private 2 | 10 | Width 0ft | 5991311.70332 | 2093205.96444 | 37.7270453991248 | -122.472273185163 | (37.7270453991248, -122.472273185163) | 9 | 8 | 4 | 64 | 40 | |||
| 141728 | 250643 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 5987323.66461 | 2114657.3301 | 37.7857134039901 | -122.4876348153 | (37.7857134039901, -122.4876348153) | 11 | 6 | 1 | 55 | 33 | |||
| 148266 | 211382 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2601 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5991018.58342 | 2094892.51485 | 37.7316592746545 | -122.473409447106 | (37.7316592746545, -122.473409447106) | 1 | 8 | 4 | 64 | 40 | |||
| 153763 | 211391 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300 Junipero Serra Blvd | 7 | : | Tree | Private 2 | 16 | Width 0ft | 5991391.10159 | 2094562.85542 | 37.7307756772501 | -122.472097570057 | (37.7307756772501, -122.472097570057) | 9 | 8 | 4 | 64 | 40 | |||
| 155272 | 194566 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 601 Rhode Island St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6011830.82796 | 2105546.54689 | 37.7620961656287 | -122.402205721219 | (37.7620961656287, -122.402205721219) | 10 | 3 | 8 | 28856 | 29 | |||
| 168319 | 250759 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 220 32nd Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5985901.18912 | 2114438.7345 | 37.785030135971 | -122.492540001016 | (37.785030135971, -122.492540001016) | 11 | 6 | 1 | 55 | 33 | |||
| 168839 | 211389 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2650 Ocean Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5990873.32433 | 2095051.49544 | 37.7320873825274 | -122.473923226178 | (37.7320873825274, -122.473923226178) | 1 | 8 | 4 | 64 | 40 | |||
| 172800 | 250641 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2610 Lake St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5987362.06762 | 2114658.60831 | 37.7857191533476 | -122.487502047492 | (37.7857191533476, -122.487502047492) | 11 | 6 | 1 | 55 | 33 | |||
| 177450 | 211375 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 462 Head St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993511.66198 | 2088947.80239 | 37.7154805924354 | -122.464358996492 | (37.7154805924354, -122.464358996492) | 9 | 8 | 6 | 64 | 24 | |||
| 186526 | 233510 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 757 Haight St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 6002532.75447 | 2109164.64815 | 37.7715071985232 | -122.434622864475 | (37.7715071985232, -122.434622864475) | 15 | 5 | 11 | 29492 | 9 | |||
| 192569 | 250336 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 107 27th Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5987380.06723 | 2115230.15893 | 37.7872895171323 | -122.48748177497 | (37.7872895171323, -122.48748177497) | 11 | 6 | 1 | 55 | 33 |
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) );