trees
28 rows where qSpecies_id = 330 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9214 | 264784 | Property Tree 8 | Pinus halepensis :: Allepo Pine 330 | 67 Rosenkranz St | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6009267 | 2098344 | 37.7421761391661 | -122.410564417702 | (37.7421761391661, -122.410564417702) | 10 | 7 | 7 | 28859 | 2 | ||||
26605 | 247142 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 500 27th St | 12 | Front Yard : Yard | Tree | Private 2 | 17 | 6003177.22177 | 2100100.19766 | 37.7466549535644 | -122.43174632176 | (37.7466549535644, -122.43174632176) | 2 | 7 | 5 | 63 | 22 | ||||
33896 | 104968 | Private 9 | Pinus halepensis :: Allepo Pine 330 | 495 COLLINGWOOD ST | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Permit Number 770776 | 6002186.6 | 2103026 | 37.7546323087418 | -122.435381040855 | (37.7546323087418, -122.435381040855) | 2 | 4 | 5 | 28862 | 22 | |||
34045 | 211155 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 300x Marietta Dr | 27 | Median : Cutout | Tree | DPW 1 | 18 | Width 5ft | 5999298.00043 | 2097563.30482 | 37.7394685970082 | -122.444977880636 | (37.7394685970082, -122.444977880636) | 9 | 7 | 4 | 59 | 40 | |||
39305 | 211042 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 1050x Moraga St | 2 | Median : Yard | Tree | DPW 1 | 12 | Width 10ft | 5990982.70719 | 2103833.64032 | 37.7562072205092 | -122.47418564296 | (37.7562072205092, -122.47418564296) | 1 | 8 | 4 | 56 | 12 | |||
42830 | 194435 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 800 Vermont St | 41 | Sidewalk: Curb side : Yard | Tree | Private 2 | 60 | 6011302.64565 | 2104147.13964 | 37.7582242092014 | -122.403934029353 | (37.7582242092014, -122.403934029353) | 10 | 3 | 8 | 28856 | 29 | ||||
48029 | 211043 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 401x Ortega St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 5992723.26269 | 2102584.78269 | 37.7528788583864 | -122.468075420566 | (37.7528788583864, -122.468075420566) | 1 | 8 | 4 | 56 | 12 | |||
55761 | 234483 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 671 Church St | 6 | Front Yard : Yard | Tree | Private 2 | 21 | Width 3ft | 6004312.0765 | 2104900.49102 | 37.7598996983218 | -122.428164152046 | (37.7598996983218, -122.428164152046) | 2 | 4 | 5 | 28862 | 3 | |||
59589 | 2349 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 2406 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2016 12:00:00 AM | 12 | 3x3 | 6009666.35017 | 2103307.94884 | 37.7558284260662 | -122.409533847831 | (37.7558284260662, -122.409533847831) | 2 | 4 | 7 | 28859 | 19 | ||
74798 | 186517 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 1400 Lower Great Hwy | 3 | unknown : Yard | Tree | Private 2 | 9 | Width 0ft | 5980906.8218 | 2104997.2844 | 37.7588134060814 | -122.509117272676 | (37.7588134060814, -122.509117272676) | 1 | 8 | 3 | 56 | 35 | |||
81649 | 194433 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 900x Carolina St | 25 | Median : Yard | Tree | DPW 1 | 8 | 6012468.79702 | 2103466.34183 | 37.7564199704212 | -122.39985313972 | (37.7564199704212, -122.39985313972) | 10 | 3 | 8 | 28856 | 29 | ||||
88962 | 116554 | Undocumented 4 | Pinus halepensis :: Allepo Pine 330 | 424x LOS PALMOS DR | 1 | Back Yard : Cutout | Tree | Private 2 | 16 | 3x3 | 5997290 | 2095790 | 37.7344847219423 | -122.451792740897 | (37.7344847219423, -122.451792740897) | 9 | 7 | 4 | 59 | 40 | |||
89622 | 99489 | Undocumented 4 | Pinus halepensis :: Allepo Pine 330 | 800X Miramar Ave | 6 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | 9 | 7 | 4 | 28861 | 40 | |||
95192 | 16379 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 1050 Moraga St | 1 | Median : Cutout | Tree | DPW 1 | 24 | 12 | 5990995.6052 | 2103835.85647 | 37.7562140526474 | -122.474141199384 | (37.7562140526474, -122.474141199384) | 1 | 8 | 4 | 56 | 12 | |||
104364 | 114271 | Undocumented 4 | Pinus halepensis :: Allepo Pine 330 | 49x ESMERALDA AVE | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 27 | 3x3 | 6006783 | 2099038 | 37.7439421324692 | -122.419202551725 | (37.7439421324692, -122.419202551725) | 2 | 7 | 7 | 28859 | 2 | |||
113215 | 108560 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 3790 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003155.9 | 2103640.4 | 37.7563743055091 | -122.432072816055 | (37.7563743055091, -122.432072816055) | 2 | 4 | 5 | 28862 | 3 | |||||
117842 | 194434 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 2225 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6012067.76833 | 2101856.84412 | 37.7519782763933 | -122.401126955647 | (37.7519782763933, -122.401126955647) | 10 | 3 | 8 | 28856 | 29 | ||||
127520 | 194436 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 653 Kansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6011568.57052 | 2105306.76486 | 37.7614231354979 | -122.403095907076 | (37.7614231354979, -122.403095907076) | 10 | 3 | 8 | 28856 | 29 | |||
139989 | 100474 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 4 | 59 | 40 | |||||
141707 | 234482 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 25 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009639.15897 | 2098562.42599 | 37.7427967468751 | -122.409293012973 | (37.7427967468751, -122.409293012973) | 10 | 7 | 7 | 28859 | 2 | |||
144158 | 246639 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 3320 Harrison St | 10 | Front Yard : Yard | Tree | Private 2 | 13 | 6009035.16234 | 2099239.17175 | 37.744621083714 | -122.411429270652 | (37.744621083714, -122.411429270652) | 2 | 7 | 7 | 28859 | 2 | ||||
148738 | 252848 | Property Tree 8 | Pinus halepensis :: Allepo Pine 330 | 99 Reposa Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5998022 | 2098104 | 37.7408803073177 | -122.44942865965 | (37.7408803073177, -122.44942865965) | 9 | 7 | 4 | 59 | 40 | ||||
149123 | 117545 | Undocumented 4 | Pinus halepensis :: Allepo Pine 330 | 3340x HARRISON ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 3x3 | 6008964 | 2099209 | 37.7445342470575 | -122.411673205451 | (37.7445342470575, -122.411673205451) | 2 | 7 | 7 | 28859 | 2 | |||
150149 | 234481 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 1201 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 13 | 6004557.91827 | 2096148.57853 | 37.7358828767982 | -122.426690658772 | (37.7358828767982, -122.426690658772) | 2 | 7 | 5 | 28861 | 2 | ||||
168409 | 234480 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 2827 Cesar Chavez St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | 6010697.22249 | 2100672.7702 | 37.7486505159232 | -122.405783128107 | (37.7486505159232, -122.405783128107) | 2 | 7 | 7 | 28859 | 2 | ||||
174040 | 234479 | DPW Maintained 1 | Pinus halepensis :: Allepo Pine 330 | 73 Elgin Park | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6005835.00327 | 2108667.27292 | 37.7703284382297 | -122.423164834297 | (37.7703284382297, -122.423164834297) | 8 | 2 | 5 | 28853 | 19 | |||
179086 | 99461 | Undocumented 4 | Pinus halepensis :: Allepo Pine 330 | 550X Miramar Ave | 8 | Median : Cutout | Tree | Private 2 | 30 | 15x280 | 5995413 | 2092983.7 | 37.7266716211667 | -122.458079078858 | (37.7266716211667, -122.458079078858) | 9 | 7 | 4 | 28861 | 40 | |||
189375 | 100473 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 930 Monterey Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 5995794.4 | 2094643.4 | 37.7312506649165 | -122.456880589247 | (37.7312506649165, -122.456880589247) | 9 | 7 | 4 | 59 | 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) );