trees
23 rows where Zip Codes = 28859 and qSpecies_id = 202 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28899 | 221958 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 779 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008100.58194 | 2095693.3071 | 37.7348324551576 | -122.414410025905 | (37.7348324551576, -122.414410025905) | 2 | 7 | 7 | 28859 | 2 | |||
12294 | 261448 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 311 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006968 | 2095801 | 37.7350644665595 | -122.418333396749 | (37.7350644665595, -122.418333396749) | 2 | 7 | 7 | 28859 | 2 | ||||
8146 | 221945 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007717.88408 | 2096150.9798 | 37.7360676182281 | -122.415765545245 | (37.7360676182281, -122.415765545245) | 2 | 7 | 7 | 28859 | 2 | |||
5316 | 221946 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007705.60833 | 2096151.45352 | 37.7360682288544 | -122.415808021131 | (37.7360682288544, -122.415808021131) | 2 | 7 | 7 | 28859 | 2 | |||
17662 | 221947 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 101X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007672.8407 | 2096154.79379 | 37.7360755583335 | -122.415921548861 | (37.7360755583335, -122.415921548861) | 2 | 7 | 7 | 28859 | 2 | |||
53421 | 115385 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 375 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776680 | 6007256.8 | 2096298.8 | 37.7364475687434 | -122.417370175703 | (37.7364475687434, -122.417370175703) | 2 | 7 | 7 | 28859 | 2 | ||
81646 | 221949 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 130 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005733.16344 | 2096370.93476 | 37.7365597919858 | -122.422643161851 | (37.7365597919858, -122.422643161851) | 2 | 7 | 7 | 28859 | 2 | |||
155229 | 221943 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 237 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006873.22599 | 2096639.71242 | 37.7373620502264 | -122.418720525044 | (37.7373620502264, -122.418720525044) | 2 | 7 | 7 | 28859 | 2 | |||
23381 | 221957 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 132 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009113.07033 | 2096713.66347 | 37.7376909592647 | -122.410981534183 | (37.7376909592647, -122.410981534183) | 10 | 7 | 7 | 28859 | 2 | |||
1685 | 221956 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 126 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009115.60345 | 2096745.48812 | 37.7377784848985 | -122.410975023096 | (37.7377784848985, -122.410975023096) | 10 | 7 | 7 | 28859 | 2 | |||
18393 | 221942 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 133 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007406.60903 | 2096997.58914 | 37.7383747174262 | -122.416901715445 | (37.7383747174262, -122.416901715445) | 2 | 7 | 7 | 28859 | 2 | |||
120297 | 36540 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 3780 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 768357 | 6008402.05844785 | 2097287.64414787 | 37.7392270883895 | -122.413480433949 | (37.7392270883895, -122.413480433949) | 2 | 7 | 7 | 28859 | 2 | ||
111830 | 221962 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 28 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005742.72785 | 2097519.53479 | 37.7397141298992 | -122.422691692893 | (37.7397141298992, -122.422691692893) | 2 | 7 | 7 | 28859 | 2 | |||
21868 | 221950 | Planning Code 138.1 required 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 31 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 780973 | 6006097.6775 | 2099053.58173 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | 2 | 7 | 7 | 28859 | 2 | ||
12088 | 221940 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 168 Tiffany Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6006049.87669 | 2099255.63478 | 37.7444983936957 | -122.421752983209 | (37.7444983936957, -122.421752983209) | 2 | 7 | 5 | 28859 | 2 | |||
5535 | 221960 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 75 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006819.46923 | 2099263.44478 | 37.7445632069438 | -122.419092436978 | (37.7445632069438, -122.419092436978) | 2 | 7 | 7 | 28859 | 2 | |||
20682 | 246691 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 96 Stoneman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6007854.4475 | 2099435.64946 | 37.7450942718828 | -122.415525868717 | (37.7450942718828, -122.415525868717) | 2 | 7 | 7 | 28859 | 2 | |||
179457 | 221959 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 40 Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006917.95307 | 2099525.21762 | 37.7452875218149 | -122.418770459905 | (37.7452875218149, -122.418770459905) | 2 | 7 | 7 | 28859 | 2 | |||
110813 | 221961 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007321.68387 | 2099648.65051 | 37.745649164396 | -122.417383168412 | (37.745649164396, -122.417383168412) | 2 | 7 | 7 | 28859 | 2 | |||
70180 | 221941 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 6 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007387.61833 | 2099831.21968 | 37.7461541678748 | -122.417168110835 | (37.7461541678748, -122.417168110835) | 2 | 7 | 7 | 28859 | 2 | |||
1907 | 36575 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2959 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | |
34074 | 36574 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2959 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | |
55128 | 221948 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 633 Capp St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6007312.78593 | 2103619.12061 | 37.7565506733878 | -122.417695309584 | (37.7565506733878, -122.417695309584) | 2 | 4 | 7 | 28859 | 19 |
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) );