trees
122 rows where Zip Codes = 28861 and qSpecies_id = 95 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
162753 | 178373 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3153 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5995808.82145 | 2086930.91891 | 37.7100748467381 | -122.456273289988 | (37.7100748467381, -122.456273289988) | 9 | 7 | 6 | 28861 | 25 | |||
164639 | 44426 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | Permit Number 43768 | 6002153.12936878 | 2086903.35597383 | 37.7103613194328 | -122.43434417838 | (37.7103613194328, -122.43434417838) | 9 | 7 | 6 | 28861 | 5 | ||
167021 | 60960 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 100 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1988 12:00:00 AM | Permit Number 25349 | 5994476.34646497 | 2090599.97936006 | 37.7200726359376 | -122.461144327567 | (37.7200726359376, -122.461144327567) | 9 | 8 | 6 | 28861 | 24 | ||
168535 | 67507 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 427 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31037 | 5997919.84331621 | 2094073.6426889 | 37.7298080658571 | -122.449491544159 | (37.7298080658571, -122.449491544159) | 9 | 7 | 4 | 28861 | 40 | ||
170884 | 178386 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002873.11956 | 2092775.20615 | 37.7265249641326 | -122.432274825446 | (37.7265249641326, -122.432274825446) | 9 | 7 | 6 | 28861 | 5 | |||
175140 | 49058 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 634 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46225 | 5995429.55733009 | 2093557.30564002 | 37.7282475554757 | -122.458063335473 | (37.7282475554757, -122.458063335473) | 9 | 7 | 4 | 28861 | 40 | ||
176358 | 1212 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3153 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5995783.70905 | 2086927.24533 | 37.7100633183297 | -122.456359817368 | (37.7100633183297, -122.456359817368) | 9 | 7 | 6 | 28861 | 25 | |||
178593 | 49057 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 634 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46225 | 5995429.55733009 | 2093557.30564002 | 37.7282475554757 | -122.458063335473 | (37.7282475554757, -122.458063335473) | 9 | 7 | 4 | 28861 | 40 | ||
179077 | 1131 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2560 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998573.13025 | 2088672.16549 | 37.7150142118128 | -122.44684454779 | (37.7150142118128, -122.44684454779) | 9 | 7 | 6 | 28861 | 25 | |||
184533 | 67508 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 423 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31038 | 5997945.14259478 | 2094073.25690369 | 37.7298084538174 | -122.449404054305 | (37.7298084538174, -122.449404054305) | 9 | 7 | 4 | 28861 | 40 | ||
186383 | 251738 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | 9 | 7 | 6 | 28861 | 5 | ||||
186446 | 44425 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 2 | Permit Number 43768 | 6002264.41887 | 2086971.04816 | 37.7105535037251 | -122.433964374559 | (37.7105535037251, -122.433964374559) | 9 | 7 | 6 | 28861 | 5 | |
187397 | 44423 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 3 | Permit Number 43768 | 6002132.44633 | 2086900.81583 | 37.7103531707288 | -122.4344154817 | (37.7103531707288, -122.4344154817) | 9 | 7 | 6 | 28861 | 5 | |
187453 | 1148 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2674 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998040.26266 | 2088367.91283 | 37.7141483475384 | -122.448664456212 | (37.7141483475384, -122.448664456212) | 9 | 7 | 6 | 28861 | 25 | |||
187874 | 53561 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 130 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20055 | 5996986.48234272 | 2089260.31315795 | 37.7165383585573 | -122.452371064987 | (37.7165383585573, -122.452371064987) | 9 | 8 | 6 | 28861 | 24 | ||
189317 | 15068 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 26 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996455.6283198 | 2089039.7599438 | 37.7159023437396 | -122.454190028496 | (37.7159023437396, -122.454190028496) | 9 | 8 | 6 | 28861 | 24 | |||
190650 | 211360 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 205 Granada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995618.4586 | 2091274.81338 | 37.7219912298988 | -122.457245251188 | (37.7219912298988, -122.457245251188) | 9 | 8 | 4 | 28861 | 24 | |||
190992 | 178384 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 151 London St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002851.22923 | 2092740.35479 | 37.726428028905 | -122.432348011369 | (37.726428028905, -122.432348011369) | 9 | 7 | 6 | 28861 | 5 | |||
191044 | 44433 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 859 Prague St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 4 | Permit Number 43768 | 6002157.33037 | 2086913.45824 | 37.7103892965003 | -122.434330380639 | (37.7103892965003, -122.434330380639) | 9 | 7 | 6 | 28861 | 5 | |
192743 | 211365 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1x Minerva St | 13 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5996056.33729 | 2089003.23942 | 37.7157791619554 | -122.455567518236 | (37.7157791619554, -122.455567518236) | 9 | 8 | 6 | 28861 | 24 | |||
192945 | 178376 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 195 Allison St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000081.42891 | 2087748.87485 | 37.712565114463 | -122.441565023612 | (37.712565114463, -122.441565023612) | 9 | 7 | 6 | 28861 | 5 | |||
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 |
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) );