trees
34 rows where qSpecies_id = 315
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7490 | 263637 | Permitted Site 7 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 2919 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2020 12:00:00 AM | 3 | 3x6 | Permit Number 786667 | 6015207.84643 | 2088969.24258 | 37.7167662106907 | -122.389368131089 | (37.7167662106907, -122.389368131089) | 10 | 3 | 8 | 58 | 1 | |
9929 | 212863 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5991651.70123 | 2089132.74789 | 37.7158810200719 | -122.470801255781 | (37.7158810200719, -122.470801255781) | 9 | 8 | 6 | 64 | 24 | |||
10490 | 263638 | Permitted Site 7 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 2919 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2020 12:00:00 AM | 3 | 3x6 | Permit Number 786667 | 6015207.84643 | 2088969.24258 | 37.7167662106907 | -122.389368131089 | (37.7167662106907, -122.389368131089) | 10 | 3 | 8 | 58 | 1 | |
18766 | 135673 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 3639 Webster St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002560.08245 | 2121134.92796 | 37.8043760820531 | -122.435384749408 | (37.8043760820531, -122.435384749408) | 13 | 9 | 1 | 57 | 17 | |||
28130 | 141975 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 628 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004659.3192 | 2111596.6724 | 37.7783054369937 | -122.427440245718 | (37.7783054369937, -122.427440245718) | 7 | 9 | 11 | 28852 | 41 | |||
28634 | 212867 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5991651.86691 | 2089070.39712 | 37.71570982962 | -122.470796144023 | (37.71570982962, -122.470796144023) | 9 | 8 | 6 | 64 | 24 | |||
35822 | 234925 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 4130 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003017.92892 | 2100391.04532 | 37.7474445223627 | -122.432317908362 | (37.7474445223627, -122.432317908362) | 2 | 4 | 5 | 63 | 22 | |||
43372 | 30731 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 210 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 6 | Permit Number 34626 | 6005468.9389 | 2109785.3783 | 37.7733778211749 | -122.424510595912 | (37.7733778211749, -122.424510595912) | 7 | 9 | 11 | 28852 | 10 | |
50452 | 30733 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 220 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 8 | Permit Number 34628 | 6005414.24 | 2109776.2618 | 37.7733497003341 | -122.424699158623 | (37.7733497003341, -122.424699158623) | 7 | 9 | 11 | 28852 | 10 | |
61960 | 4261 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 4140 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6002986.31011 | 2100390.04229 | 37.7474399753816 | -122.432427172392 | (37.7474399753816, -122.432427172392) | 2 | 4 | 5 | 63 | 22 | ||
67144 | 30730 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 206 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 7 | Permit Number 34625 | 6005493.8573 | 2109790.8481 | 37.773394247097 | -122.424424788705 | (37.773394247097, -122.424424788705) | 7 | 9 | 11 | 28852 | 10 | |
67989 | 123299 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 651 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994384.36666 | 2111094.62852 | 37.7763404655798 | -122.462948408733 | (37.7763404655798, -122.462948408733) | 11 | 6 | 2 | 54 | 11 | |||
81098 | 212862 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5991653.11039 | 2089152.84601 | 37.7159362861084 | -122.470797848245 | (37.7159362861084, -122.470797848245) | 9 | 8 | 6 | 64 | 24 | |||
84602 | 212873 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 218 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999277.32335 | 2094096.77644 | 37.729949148121 | -122.44480026093 | (37.729949148121, -122.44480026093) | 9 | 7 | 4 | 28861 | 40 | |||
94063 | 135672 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 2147 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1999 12:00:00 AM | 1 | Width 3ft | Permit Number 41893 | 6000516.72226 | 2120270.10752 | 37.8018852594656 | -122.442393824413 | (37.8018852594656, -122.442393824413) | 13 | 9 | 1 | 57 | 17 | |
97821 | 201503 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 1001 Innes Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6018539.45605 | 2094929.89091 | 37.7333171568604 | -122.378265839401 | (37.7333171568604, -122.378265839401) | 10 | 3 | 8 | 58 | 1 | ||||
107599 | 212872 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 198 Lippard Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001757.34525 | 2094984.84469 | 37.732528798547 | -122.436290073554 | (37.732528798547, -122.436290073554) | 9 | 7 | 5 | 63 | 40 | |||
113245 | 123865 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 628 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5993489.50259 | 2114889.41198 | 37.7867083268377 | -122.466319821906 | (37.7867083268377, -122.466319821906) | 11 | 6 | 1 | 54 | 11 | |||
113660 | 212871 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5991640.98496 | 2088998.4603 | 37.7155116793019 | -122.470828519642 | (37.7155116793019, -122.470828519642) | 9 | 8 | 6 | 64 | 24 | |||
114573 | 43306 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 693 Vermont St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/12/2000 12:00:00 AM | 22 | Permit Number 43072 | 6011289.47877 | 2105149.93268 | 37.7609769197604 | -122.404050137204 | (37.7609769197604, -122.404050137204) | 10 | 3 | 8 | 28856 | 29 | |
114838 | 212864 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5991651.36017 | 2089116.5547 | 37.7158365377914 | -122.470801255775 | (37.7158365377914, -122.470801255775) | 9 | 8 | 6 | 64 | 24 | |||
123311 | 30828 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 198 Lippard Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 5 | Permit Number 34680 | 6001758.93127 | 2095020.15662 | 37.7326258471074 | -122.436287116556 | (37.7326258471074, -122.436287116556) | 9 | 7 | 5 | 63 | 40 | |
123859 | 212870 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5991652.84437 | 2089051.91325 | 37.7156591339399 | -122.470791419899 | (37.7156591339399, -122.470791419899) | 9 | 8 | 6 | 64 | 24 | |||
146988 | 141973 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 616 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004729.6769 | 2111606.0167 | 37.7783350732146 | -122.427197518067 | (37.7783350732146, -122.427197518067) | 7 | 9 | 11 | 28852 | 41 | |||
147904 | 234928 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 1114 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6002478.58952 | 2102337.14106 | 37.7527574445221 | -122.434322017864 | (37.7527574445221, -122.434322017864) | 2 | 4 | 5 | 28862 | 22 | |||
157940 | 212866 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5991652.15629 | 2089084.13687 | 37.7157475723637 | -122.470796144046 | (37.7157475723637, -122.470796144046) | 9 | 8 | 6 | 64 | 24 | |||
158417 | 212865 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5991651.98385 | 2089099.35926 | 37.7157893593682 | -122.470797848251 | (37.7157893593682, -122.470797848251) | 9 | 8 | 6 | 64 | 24 | |||
159338 | 234926 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 461 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003697.61427 | 2096160.46906 | 37.7358668490696 | -122.429665917348 | (37.7358668490696, -122.429665917348) | 2 | 7 | 5 | 63 | 7 | |||
168865 | 4262 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 4140 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2013 12:00:00 AM | 3 | 3X3 | Permit Number 769862 | 6002957.66271 | 2100387.9842 | 37.7474326998547 | -122.432526086131 | (37.7474326998547, -122.432526086131) | 2 | 4 | 5 | 63 | 22 | |
175881 | 212868 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5991651.55425 | 2089037.47957 | 37.715619427959 | -122.47079482834 | (37.715619427959, -122.47079482834) | 9 | 8 | 6 | 64 | 24 | |||
181293 | 234927 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 1114 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6002481.22542 | 2102319.112 | 37.7527080906269 | -122.434311613607 | (37.7527080906269, -122.434311613607) | 2 | 4 | 5 | 28862 | 22 | |||
187617 | 30732 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 218 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 8 | Permit Number 34627 | 6005441.5895 | 2109781.1239 | 37.7733645950936 | -122.424604898731 | (37.7733645950936, -122.424604898731) | 7 | 9 | 11 | 28852 | 10 | |
189480 | 212869 | DPW Maintained 1 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 51 Monticello St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5991651.55375 | 2089014.04601 | 37.7155550850776 | -122.470793124129 | (37.7155550850776, -122.470793124129) | 9 | 8 | 6 | 64 | 24 | |||
191660 | 256163 | Undocumented 4 | Prunus caroliniana :: Carolina Cherry Laurel 315 | 300X Peralta Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6009722 | 2099567 | 37.7455597283682 | -122.409077438923 | (37.7455597283682, -122.409077438923) | 2 | 7 | 7 | 28859 | 2 |
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) );