trees
50 rows where Fire Prevention Districts = 9 and qSpecies_id = 96 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75541 | 253981 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 433 Detroit St | 3 | Unaccepted Street : Yard | Tree | Private 2 | Width 10ft | 5999422.35392 | 2094544.1981 | 37.7311859389748 | -122.444331015365 | (37.7311859389748, -122.444331015365) | 9 | 7 | 4 | 59 | 40 | ||||
| 121273 | 206470 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 747 Detroit St | 11 | Side Yard : Yard | Tree | Private 2 | 1 | 5999427.71603 | 2095403.50686 | 37.7335457051627 | -122.444374208926 | (37.7335457051627, -122.444374208926) | 9 | 7 | 4 | 59 | 40 | ||||
| 49356 | 206465 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 423 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998611.46189 | 2095226.73921 | 37.7330137372936 | -122.447183504829 | (37.7330137372936, -122.447183504829) | 9 | 7 | 4 | 59 | 40 | |||
| 50925 | 206457 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900 Junipero Serra Blvd | 104 | : | Tree | Private 2 | 10 | Width 0ft | 5991133.57353 | 2090407.88322 | 37.719352251183 | -122.472685046772 | (37.719352251183, -122.472685046772) | 9 | 8 | 4 | 64 | 40 | |||
| 162099 | 206467 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 747 Detroit St | 5 | Side Yard : Yard | Tree | Private 2 | 10 | 5999430.1593 | 2095426.08584 | 37.7336078411342 | -122.444367383951 | (37.7336078411342, -122.444367383951) | 9 | 7 | 4 | 59 | 40 | ||||
| 175491 | 206447 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 193 Bright St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993726.91575 | 2088448.649 | 37.7141224416834 | -122.46357878423 | (37.7141224416834, -122.46357878423) | 9 | 8 | 6 | 64 | 24 | |||
| 8429 | 206463 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 100 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001362.70768 | 2094968.7442 | 37.732462159688 | -122.4376532749 | (37.732462159688, -122.4376532749) | 9 | 7 | 5 | 63 | 40 | |||
| 139941 | 206452 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500 Junipero Serra Blvd | 37 | : | Tree | Private 2 | 12 | Width 0ft | 5991336.42216 | 2093557.70772 | 37.7280126289541 | -122.472213362281 | (37.7280126289541, -122.472213362281) | 9 | 8 | 4 | 64 | 40 | |||
| 142959 | 206474 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 230 Edna St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 5998806.12443 | 2095305.20487 | 37.7332403061898 | -122.446516151203 | (37.7332403061898, -122.446516151203) | 9 | 7 | 4 | 59 | 40 | ||||
| 159085 | 176068 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 14 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6009458.20535 | 2090043.50806 | 37.7193954735114 | -122.409317656201 | (37.7193954735114, -122.409317656201) | 9 | 3 | 8 | 309 | 18 | |||
| 16595 | 206473 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 55 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 5999743.81209 | 2095477.4356 | 37.7337667261604 | -122.443286685744 | (37.7337667261604, -122.443286685744) | 9 | 7 | 4 | 63 | 40 | |||
| 184063 | 176070 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 34 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6009191.21918 | 2089961.56598 | 37.7191555154919 | -122.410234749751 | (37.7191555154919, -122.410234749751) | 9 | 3 | 8 | 309 | 18 | |||
| 23423 | 206445 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 53 Ralston St | 3 | Back Yard : Yard | Tree | Private 2 | 15 | 5992171.9093 | 2088272.93373 | 37.7135502489179 | -122.46894065561 | (37.7135502489179, -122.46894065561) | 9 | 8 | 6 | 64 | 24 | ||||
| 9822 | 16139 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 370 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999751.27991 | 2094724.82015 | 37.7317006461585 | -122.443206831334 | (37.7317006461585, -122.443206831334) | 9 | 7 | 4 | 63 | 40 | |||
| 67912 | 176067 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 1 | Median : Cutout | Tree | DPW 1 | 22 | Width 0ft | 6009780.98423 | 2090145.56651 | 37.719693784023 | -122.408209118574 | (37.719693784023, -122.408209118574) | 9 | 3 | 8 | 309 | 18 | |||
| 129437 | 206444 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 75 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 23 | 5992169.96835 | 2088350.86546 | 37.7137641184938 | -122.468953032063 | (37.7137641184938, -122.468953032063) | 9 | 8 | 6 | 64 | 24 | ||||
| 63252 | 206446 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 53 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 25 | 5992168.00552 | 2088268.19461 | 37.7135370108901 | -122.468953803676 | (37.7135370108901, -122.468953803676) | 9 | 8 | 6 | 64 | 24 | ||||
| 117050 | 206436 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 300x Marietta Dr | 48 | Median : Cutout | Tree | DPW 1 | 26 | Width 5ft | 5999547.88846 | 2097490.32273 | 37.7392824643167 | -122.4441086373 | (37.7392824643167, -122.4441086373) | 9 | 7 | 4 | 59 | 40 | |||
| 101445 | 206440 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1x Minerva St | 52 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 5996572.23219 | 2088998.68039 | 37.7157962346852 | -122.453784028604 | (37.7157962346852, -122.453784028604) | 9 | 8 | 6 | 28861 | 24 | |||
| 149617 | 176069 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700x Mansell St | 27 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6009294.57289 | 2089991.02465 | 37.7192421957421 | -122.409879572386 | (37.7192421957421, -122.409879572386) | 9 | 3 | 8 | 309 | 18 | |||
| 6438 | 29970 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991349.07674 | 2093718.94394 | 37.7284560756763 | -122.472181363504 | (37.7284560756763, -122.472181363504) | 9 | 8 | 4 | 64 | 40 | ||
| 39648 | 206450 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500 Junipero Serra Blvd | 7 | : | Tree | Private 2 | 3 | Width 0ft | 5991349.40355 | 2093772.63762 | 37.7286035240126 | -122.472184145995 | (37.7286035240126, -122.472184145995) | 9 | 8 | 4 | 64 | 40 | |||
| 105109 | 206441 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 45 Margaret Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997090.05868 | 2089794.46291 | 37.7180109429363 | -122.45205157193 | (37.7180109429363, -122.45205157193) | 9 | 8 | 6 | 28861 | 24 | |||
| 105242 | 206455 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700 Junipero Serra Blvd | 62 | : | Tree | Private 2 | 3 | Width 0ft | 5991225.43334 | 2092378.31731 | 37.7247678930137 | -122.472511102603 | (37.7247678930137, -122.472511102603) | 9 | 8 | 4 | 64 | 40 | |||
| 153035 | 29606 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900X Junipero Serra Blvd | 15 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991168.88017 | 2091040.07708 | 37.7210901433828 | -122.472609073864 | (37.7210901433828, -122.472609073864) | 9 | 8 | 4 | 64 | 40 | ||
| 167420 | 29575 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 400X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991376.3613 | 2094248.55248 | 37.7299118271724 | -122.472125628008 | (37.7299118271724, -122.472125628008) | 9 | 8 | 4 | 64 | 40 | ||
| 141205 | 176071 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 1x Tioga Ave | 1 | Median : Cutout | Tree | DPW 1 | 30 | Width 0ft | 6011377.48313 | 2088627.04086 | 37.7156134870441 | -122.402583833071 | (37.7156134870441, -122.402583833071) | 9 | 7 | 8 | 309 | 39 | |||
| 149011 | 206456 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 700 Junipero Serra Blvd | 84 | : | Tree | Private 2 | 30 | Width 0ft | 5991229.90591 | 2092186.81387 | 37.7242423310074 | -122.472481686706 | (37.7242423310074, -122.472481686706) | 9 | 8 | 4 | 64 | 40 | |||
| 154268 | 206451 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500 Junipero Serra Blvd | 13 | : | Tree | Private 2 | 33 | Width 0ft | 5991343.11877 | 2093722.6763 | 37.7284659790048 | -122.472202232259 | (37.7284659790048, -122.472202232259) | 9 | 8 | 4 | 64 | 40 | |||
| 129392 | 187578 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 211 Elliot St | 1 | Side Yard : Yard | Tree | Private 2 | 38 | 6009088.83114 | 2088896.19011 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | 9 | 7 | 8 | 309 | 39 | ||||
| 99009 | 206464 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 171 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6001095.15632 | 2095353.35883 | 37.7335030062632 | -122.438605809815 | (37.7335030062632, -122.438605809815) | 9 | 7 | 5 | 63 | 40 | |||
| 139921 | 206439 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 171 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 5999612.35761 | 2094047.36229 | 37.7298325825057 | -122.443638462765 | (37.7298325825057, -122.443638462765) | 9 | 7 | 4 | 63 | 40 | |||
| 95463 | 206471 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 714 Detroit St | 7 | Side Yard : Yard | Tree | Private 2 | 40 | 5999468.77343 | 2095408.32034 | 37.7335612643209 | -122.444232607974 | (37.7335612643209, -122.444232607974) | 9 | 7 | 4 | 63 | 40 | ||||
| 87397 | 206443 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 581 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993478.4128 | 2089802.60481 | 37.7178257581409 | -122.464535950688 | (37.7178257581409, -122.464535950688) | 9 | 8 | 6 | 64 | 24 | |||
| 25308 | 176072 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 653 Peru Ave | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6005100.84385 | 2092592.61654 | 37.7261496752474 | -122.424560681043 | (37.7261496752474, -122.424560681043) | 9 | 7 | 6 | 28861 | 5 | ||||
| 27186 | 206459 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 100x Casitas Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5995500.0924 | 2096986.41631 | 37.7376671119383 | -122.458067560678 | (37.7376671119383, -122.458067560678) | 9 | 7 | 4 | 59 | 40 | |||
| 143948 | 206468 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 747 Detroit St | 6 | Side Yard : Yard | Tree | Private 2 | 6 | 5999438.31164 | 2095424.28533 | 37.7336033624897 | -122.444339069698 | (37.7336033624897, -122.444339069698) | 9 | 7 | 4 | 63 | 40 | ||||
| 59140 | 206442 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 488 Arch St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 6ft | 5992758.93765 | 2090436.99405 | 37.719526135091 | -122.467068932605 | (37.719526135091, -122.467068932605) | 9 | 8 | 6 | 64 | 24 | |||
| 103204 | 206469 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 747 Detroit St | 7 | Side Yard : Yard | Tree | Private 2 | 7 | 5999419.31958 | 2095424.67998 | 37.7336033625016 | -122.444404758876 | (37.7336033625016, -122.444404758876) | 9 | 7 | 4 | 59 | 40 | ||||
| 136256 | 206460 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 100x Casitas Ave | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 5995511.53066 | 2096986.44816 | 37.737667856597 | -122.458028015699 | (37.737667856597, -122.458028015699) | 9 | 7 | 4 | 59 | 40 | |||
| 161187 | 206466 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 747 Detroit St | 1 | Side Yard : Yard | Tree | Private 2 | 7 | 5999436.63595 | 2095454.00589 | 37.7336848725516 | -122.444346998137 | (37.7336848725516, -122.444346998137) | 9 | 7 | 4 | 59 | 40 | ||||
| 166857 | 206461 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 100x Casitas Ave | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 5995522.71914 | 2096987.57001 | 37.7376715797638 | -122.457989413181 | (37.7376715797638, -122.457989413181) | 9 | 7 | 4 | 59 | 40 | |||
| 176634 | 206438 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 300x Marietta Dr | 50 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5999556.58513 | 2097486.39574 | 37.7392721778577 | -122.4440782861 | (37.7392721778577, -122.4440782861) | 9 | 7 | 4 | 59 | 40 | |||
| 182609 | 206462 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 100x Casitas Ave | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 5995528.33875 | 2096982.84241 | 37.7376589218079 | -122.457969641597 | (37.7376589218079, -122.457969641597) | 9 | 7 | 4 | 59 | 40 | |||
| 193215 | 206472 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 714 Detroit St | 11 | Side Yard : Yard | Tree | Private 2 | 7 | 5999457.34155 | 2095426.05031 | 37.7336092944368 | -122.444273404802 | (37.7336092944368, -122.444273404802) | 9 | 7 | 4 | 63 | 40 | ||||
| 24080 | 206453 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500 Junipero Serra Blvd | 38 | : | Tree | Private 2 | 8 | Width 0ft | 5991335.38967 | 2093546.90913 | 37.72798291897 | -122.47221614477 | (37.72798291897, -122.47221614477) | 9 | 8 | 4 | 64 | 40 | |||
| 55887 | 206458 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 900 Junipero Serra Blvd | 105 | : | Tree | Private 2 | 8 | Width 0ft | 5991134.51165 | 2090396.03266 | 37.7193197667672 | -122.472680940494 | (37.7193197667672, -122.472680940494) | 9 | 8 | 4 | 64 | 40 | |||
| 78546 | 206437 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 300x Marietta Dr | 49 | Median : Cutout | Tree | DPW 1 | 9 | Width 5ft | 5999552.56318 | 2097488.97673 | 37.7392790352022 | -122.444092377567 | (37.7392790352022, -122.444092377567) | 9 | 7 | 4 | 59 | 40 | |||
| 133625 | 206454 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 500 Junipero Serra Blvd | 46 | : | Tree | Private 2 | 9 | Width 0ft | 5991330.30791 | 2093483.47791 | 37.7278084585838 | -122.472229090527 | (37.7278084585838, -122.472229090527) | 9 | 8 | 4 | 64 | 40 | |||
| 183444 | 206448 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 3804 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 5990608.23629 | 2090475.97577 | 37.7195087925673 | -122.474505889762 | (37.7195087925673, -122.474505889762) | 9 | 8 | 4 | 64 | 40 |
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) );