trees
139 rows where qCaretaker_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 50474 | 211356 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 41 | Median : Cutout | Tree | DPW 1 | 5 | Width 5ft | 5999471.52853 | 2097511.88906 | 37.7393373238643 | -122.444374204418 | (37.7393373238643, -122.444374204418) | 9 | 7 | 4 | 59 | 40 | |||
| 52610 | 977 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1599 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001822.91607 | 2092853.3598 | 37.7266799530333 | -122.43591092131 | (37.7266799530333, -122.43591092131) | 9 | 7 | 6 | 28861 | 25 | |||
| 56038 | 211354 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 23 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5999278.01006 | 2097568.54324 | 37.7394818395234 | -122.445047374833 | (37.7394818395234, -122.445047374833) | 9 | 7 | 4 | 59 | 40 | |||
| 62143 | 2164 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 725X Mansell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009812.0626049 | 2090077.874838 | 37.7195096568823 | -122.408096919848 | (37.7195096568823, -122.408096919848) | 9 | 3 | 8 | 309 | 18 | |||
| 63450 | 337 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3590X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | |||
| 71884 | 13374 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 940 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x10 | 6009133.6559802 | 2090011.862437 | 37.7192903922619 | -122.41043727411 | (37.7192903922619, -122.41043727411) | 9 | 3 | 7 | 309 | 28 | |||
| 80091 | 7670 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2574X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998491.68866 | 2088612.8368 | 37.7148466558292 | -122.447121776248 | (37.7148466558292, -122.447121776248) | 9 | 7 | 6 | 28861 | 25 | |||
| 82541 | 211427 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 65 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5999709.39376 | 2097376.92843 | 37.7389803226746 | -122.443542082395 | (37.7389803226746, -122.443542082395) | 9 | 7 | 4 | 59 | 40 | |||
| 87867 | 11879 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 2 | Median : Cutout | Tree | DPW 1 | 17 | 20 | 5991400.98667 | 2094604.94103 | 37.7308918058105 | -122.472066462495 | (37.7308918058105, -122.472066462495) | 9 | 8 | 4 | 64 | 40 | |||
| 93824 | 211411 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100x Casitas Ave | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5995419.81631 | 2096989.18107 | 37.7376700905057 | -122.45834531179 | (37.7376700905057, -122.45834531179) | 9 | 7 | 4 | 59 | 40 | |||
| 94956 | 11661 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 700X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991304.37203 | 2093039.68801 | 37.7265884212004 | -122.472286413287 | (37.7265884212004, -122.472286413287) | 9 | 8 | 4 | 64 | 40 | ||
| 97985 | 13414 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Marietta Dr | 3 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999540.96545 | 2097034.36116 | 37.7380301071099 | -122.444099819458 | (37.7380301071099, -122.444099819458) | 9 | 7 | 4 | 59 | 40 | |||
| 99035 | 29957 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 5991400.4743 | 2094594.98501 | 37.7308644394281 | -122.472067508419 | (37.7308644394281, -122.472067508419) | 9 | 8 | 4 | 64 | 40 | |||
| 106463 | 975 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1599 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X5 | 6001957.29298 | 2093112.49768 | 37.7273991195728 | -122.43546491497 | (37.7273991195728, -122.43546491497) | 9 | 7 | 6 | 28861 | 25 | |||
| 107387 | 211428 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 53 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999583.37084 | 2097473.06947 | 37.7392371150928 | -122.443984716141 | (37.7392371150928, -122.443984716141) | 9 | 7 | 4 | 59 | 40 | |||
| 115888 | 30053 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300X Junipero Serra Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 3X3 | 5991402.00396 | 2094617.05729 | 37.7309251328883 | -122.472063828393 | (37.7309251328883, -122.472063828393) | 9 | 8 | 4 | 64 | 40 | |||
| 116315 | 417 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3866 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 5990888.82465 | 2090075.47964 | 37.7184253822074 | -122.473506810731 | (37.7184253822074, -122.473506810731) | 9 | 8 | 4 | 64 | 40 | |||
| 122160 | 13413 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400 Marietta Dr | 2 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999541.98598 | 2097031.37514 | 37.7380219664255 | -122.444096076493 | (37.7380219664255, -122.444096076493) | 9 | 7 | 4 | 59 | 40 | |||
| 128952 | 1211 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3151 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 5995828.36788 | 2086934.23822 | 37.7100850828375 | -122.45620597395 | (37.7100850828375, -122.45620597395) | 9 | 7 | 6 | 28861 | 25 | |||
| 130824 | 1153 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2691 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2x2 | 5998057.05642 | 2088283.39512 | 37.7139172415497 | -122.44860032736 | (37.7139172415497, -122.44860032736) | 9 | 7 | 6 | 28861 | 25 | |||
| 133754 | 211353 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 9 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999190.61493 | 2097593.0278 | 37.7395440797867 | -122.445351307915 | (37.7395440797867, -122.445351307915) | 9 | 7 | 4 | 59 | 40 | |||
| 140833 | 416 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3866 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 5990882.28531 | 2090084.77659 | 37.7184505306428 | -122.473530092056 | (37.7184505306428, -122.473530092056) | 9 | 8 | 4 | 64 | 40 | ||||
| 141150 | 211426 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400x Marietta Dr | 8 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999504.16591 | 2097034.85619 | 37.7380293669502 | -122.444227088834 | (37.7380293669502, -122.444227088834) | 9 | 7 | 4 | 59 | 40 | |||
| 142073 | 211358 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 43 | Median : Cutout | Tree | DPW 1 | 12 | Width 5ft | 5999479.63051 | 2097509.53542 | 37.739331323589 | -122.444346022364 | (37.739331323589, -122.444346022364) | 9 | 7 | 4 | 59 | 40 | |||
| 147040 | 15079 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 70 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996133.8718103 | 2089044.0011234 | 37.7158955330145 | -122.45530246888 | (37.7158955330145, -122.45530246888) | 9 | 8 | 6 | 28861 | 24 | |||
| 149214 | 13412 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 424 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5999639.6116279 | 2097094.1286968 | 37.7381998416451 | -122.443763044504 | (37.7381998416451, -122.443763044504) | 9 | 7 | 4 | 59 | 40 | |||
| 154768 | 11640 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 5991362.1134613 | 2093824.2614448 | 37.7287460056648 | -122.472143968924 | (37.7287460056648, -122.472143968924) | 9 | 8 | 4 | 64 | 40 | |||
| 155416 | 211412 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100x Casitas Ave | 4 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 5995479.92696 | 2096985.75384 | 37.7376641342833 | -122.458137233872 | (37.7376641342833, -122.458137233872) | 9 | 7 | 4 | 59 | 40 | |||
| 156806 | 211366 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1x Minerva St | 35 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5996338.39327 | 2089000.17241 | 37.7157869222084 | -122.454592386944 | (37.7157869222084, -122.454592386944) | 9 | 8 | 6 | 28861 | 24 | |||
| 160764 | 15082 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 84 Minerva St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996031.3031413 | 2089045.3531152 | 37.7158933597021 | -122.455657089572 | (37.7158933597021, -122.455657089572) | 9 | 8 | 6 | 28861 | 24 | |||
| 161820 | 211429 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 52 | Median : Cutout | Tree | DPW 1 | 10 | Width 5ft | 5999576.15591 | 2097477.53164 | 37.739248955579 | -122.44400998258 | (37.739248955579, -122.44400998258) | 9 | 7 | 4 | 59 | 40 | |||
| 166495 | 29973 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 18 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991350.6997 | 2093700.47523 | 37.7284054591375 | -122.472174407226 | (37.7284054591375, -122.472174407226) | 9 | 8 | 4 | 64 | 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 | |||
| 181046 | 211357 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 42 | Median : Cutout | Tree | DPW 1 | 7 | Width 5ft | 5999475.8897 | 2097510.54989 | 37.7393338956504 | -122.444359029265 | (37.7393338956504, -122.444359029265) | 9 | 7 | 4 | 59 | 40 | |||
| 182250 | 13373 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 930 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X10 | 6009096.55006 | 2089989.80349 | 37.7192277427566 | -122.410563978962 | (37.7192277427566, -122.410563978962) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 188822 | 211355 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Marietta Dr | 30 | Median : Cutout | Tree | DPW 1 | 6 | Width 5ft | 5999309.78108 | 2097559.20163 | 37.7394580029801 | -122.444936853564 | (37.7394580029801, -122.444936853564) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 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 |
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) );