trees
45 rows where Zip Codes = 29491 and qSpecies_id = 47
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
60657 | 183431 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2506 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988944.9633 | 2098242.436 | 37.7407369950817 | -122.480823446497 | (37.7407369950817, -122.480823446497) | 1 | 8 | 3 | 29491 | 35 | |||
63902 | 46390 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2447 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 7 | Permit Number 44623 | 5982678.99712077 | 2098464.70885711 | 37.7409810943186 | -122.502504874921 | (37.7409810943186, -122.502504874921) | 1 | 8 | 3 | 29491 | 35 | |
64416 | 183208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.7401199309313 | -122.501448961428 | (37.7401199309313, -122.501448961428) | 1 | 8 | 3 | 29491 | 35 | |||
68109 | 50881 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2040 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47391 | 5991642.80129947 | 2101534.85210656 | 37.7499335653235 | -122.471735313093 | (37.7499335653235, -122.471735313093) | 1 | 8 | 4 | 29491 | 12 | ||
84877 | 31600 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1631 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/1995 12:00:00 AM | Permit Number 35126 | 5988991.64827869 | 2102380.23074862 | 37.7521010026968 | -122.480964913447 | (37.7521010026968, -122.480964913447) | 1 | 8 | 3 | 29491 | 35 | ||
89095 | 46395 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 9 | Permit Number 44627 | 5981974.76389525 | 2100876.77542895 | 37.7475625528023 | -122.505118527994 | (37.7475625528023, -122.505118527994) | 1 | 8 | 3 | 29491 | 35 | |
90861 | 31375 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 630 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | Permit Number 34977 | 5991276.37232485 | 2099107.33925567 | 37.7432470351435 | -122.472825445815 | (37.7432470351435, -122.472825445815) | 1 | 8 | 4 | 29491 | 40 | ||
97332 | 83208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3634 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50746 | 5981914.57527844 | 2100148.1004138 | 37.7455582728462 | -122.505272655065 | (37.7455582728462, -122.505272655065) | 1 | 8 | 3 | 29491 | 35 | |
100650 | 78557 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2234 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2016 12:00:00 AM | 3 | Permit Number 771299 | 5981748.2661 | 2099861.5988 | 37.7447618317919 | -122.505826480334 | (37.7447618317919, -122.505826480334) | 1 | 8 | 3 | 29491 | 35 | |
103582 | 83279 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.4490102 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | 1 | 8 | 3 | 29491 | 35 | |
107125 | 84447 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2266 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50738 | 5982378.18226568 | 2099687.61773546 | 37.7443211838051 | -122.503635505549 | (37.7443211838051, -122.503635505549) | 1 | 8 | 3 | 29491 | 35 | |
123946 | 83251 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | 1 | 8 | 3 | 29491 | 35 | |
128606 | 82810 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2730 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50728 | 5983104.2980141 | 2096628.76061893 | 37.7359650625832 | -122.500898621502 | (37.7359650625832, -122.500898621502) | 1 | 8 | 3 | 29491 | 35 | ||
133839 | 79951 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4332 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.7492426575827 | -122.50658364702 | (37.7492426575827, -122.50658364702) | 1 | 8 | 3 | 29491 | 35 | |
137363 | 84886 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3138 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49329 | 5983290 | 2099514 | 37.7438980447125 | -122.500469849117 | (37.7438980447125, -122.500469849117) | 1 | 8 | 3 | 29491 | 35 | |||
149652 | 183373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.7365485996681 | -122.492356136884 | (37.7365485996681, -122.492356136884) | 1 | 8 | 3 | 29491 | 35 | |||
157838 | 46382 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2495 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.7401721103617 | -122.501371213543 | (37.7401721103617, -122.501371213543) | 1 | 8 | 3 | 29491 | 35 | ||
160576 | 186058 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1901 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984794.5256 | 2102183.7824 | 37.7513167410032 | -122.495464490464 | (37.7513167410032, -122.495464490464) | 1 | 8 | 3 | 29491 | 35 | |||
165308 | 83228 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4234 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50748 | 5982916.47531802 | 2098139.9083931 | 37.7401032328077 | -122.50165975231 | (37.7401032328077, -122.50165975231) | 1 | 8 | 3 | 29491 | 35 | |
165329 | 46381 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2495 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | Permit Number 44618 | 5983000.42559938 | 2098163.19803029 | 37.7401721103617 | -122.501371213543 | (37.7401721103617, -122.501371213543) | 1 | 8 | 3 | 29491 | 35 | ||
165614 | 183438 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2506 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5988326.6233 | 2098215.7152 | 37.7406276663345 | -122.482959448414 | (37.7406276663345, -122.482959448414) | 1 | 8 | 3 | 29491 | 35 | |||
165804 | 186059 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1901 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984803.9529 | 2102180.8195 | 37.7513091577006 | -122.495431671777 | (37.7513091577006, -122.495431671777) | 1 | 8 | 3 | 29491 | 35 | |||
166199 | 79279 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2706 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50726 | 5983101.82229012 | 2096724.27729962 | 37.7362271801162 | -122.50091424264 | (37.7362271801162, -122.50091424264) | 1 | 8 | 3 | 29491 | 35 | ||
171915 | 82814 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2724 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50727 | 5983103.67908303 | 2096652.63979189 | 37.7360305919754 | -122.500902526777 | (37.7360305919754, -122.500902526777) | 1 | 8 | 3 | 29491 | 35 | ||
173649 | 186041 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1900 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984992.0482 | 2102149.6578 | 37.7512346080754 | -122.494778929254 | (37.7512346080754, -122.494778929254) | 1 | 8 | 3 | 29491 | 35 | |||
181516 | 182942 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2671 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982115.1 | 2096931.8144 | 37.7367390358824 | -122.504341059874 | (37.7367390358824, -122.504341059874) | 1 | 8 | 3 | 29491 | 35 | |||
193603 | 68315 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3820 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32128 | 5981623.22584135 | 2100818.01716678 | 37.7473805290726 | -122.506329747472 | (37.7473805290726, -122.506329747472) | 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) );