trees
139 rows where qCaretaker_id = 1 and qSpecies_id = 95 sorted by qSpecies_id
This data as json, CSV (advanced)
These facets timed out: qCaretaker_id
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 148400 | 24733 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 7550 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 5983556.60385 | 2112529.01804 | 37.7796492510048 | -122.500510140172 | (37.7796492510048, -122.500510140172) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 151448 | 9901 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6005290.73846 | 2115881.11756 | 37.7901051541858 | -122.42556093401 | (37.7901051541858, -122.42556093401) | 13 | 9 | 1 | 28858 | 27 | |||
| 152998 | 17370 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2225X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005023.6203 | 2117335.73677 | 37.7940840749616 | -122.426588765666 | (37.7940840749616, -122.426588765666) | 13 | 9 | 1 | 28858 | 27 | |||
| 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 | |||
| 156894 | 5232 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1060 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6001447.2358 | 2112106.5793 | 37.7795233183444 | -122.43858855259 | (37.7795233183444, -122.43858855259) | 15 | 5 | 11 | 29490 | 41 | |||
| 157160 | 211335 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501x Ortega St | 12 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 5992526.64779 | 2103107.81832 | 37.7543036219218 | -122.468793402415 | (37.7543036219218, -122.468793402415) | 1 | 8 | 4 | 56 | 12 | |||
| 157965 | 3455 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 49 Cameo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999556.98286 | 2099595.01382 | 37.7450619619321 | -122.444228395547 | (37.7450619619321, -122.444228395547) | 2 | 7 | 5 | 63 | 22 | |||
| 158702 | 16839 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 97X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/17/1999 12:00:00 AM | 75 | 3X3 | 6006555.51402 | 2110416.39536 | 37.7751717443167 | -122.420796779971 | (37.7751717443167, -122.420796779971) | 7 | 9 | 11 | 28852 | 10 | ||
| 159370 | 27856 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 350 Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999054.4459 | 2111673.3239 | 37.7781973051578 | -122.446835017559 | (37.7781973051578, -122.446835017559) | 15 | 5 | 11 | 54 | 16 | |||
| 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 | |||
| 161479 | 211337 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501x Ortega St | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 2ft | 5992536.02812 | 2103096.29648 | 37.7542725278567 | -122.468760124801 | (37.7542725278567, -122.468760124801) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 166459 | 2181 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1006 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6000928.0526 | 2112222.8113 | 37.7798129141573 | -122.440392962604 | (37.7798129141573, -122.440392962604) | 15 | 5 | 11 | 29490 | 41 | |||
| 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 | ||
| 166965 | 272 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3201X 19th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X2 | 5990532.43506 | 2093914.77746 | 37.7289464910226 | -122.475018795259 | (37.7289464910226, -122.475018795259) | 1 | 8 | 4 | 64 | 14 | |||
| 168802 | 22852 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 136 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 5999927.91255 | 2099124.2965 | 37.7437906398414 | -122.442911994021 | (37.7437906398414, -122.442911994021) | 2 | 7 | 5 | 63 | 7 | ||||
| 170864 | 9339 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 6000798.3699591 | 2098653.6744451 | 37.7425480118371 | -122.439868429368 | (37.7425480118371, -122.439868429368) | 2 | 7 | 5 | 63 | 7 | |||
| 170991 | 9273 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6800 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5985817.56987 | 2112511.8313 | 37.7797345255146 | -122.492687325732 | (37.7797345255146, -122.492687325732) | 11 | 6 | 2 | 55 | 26 | |||
| 172780 | 1339 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5999275.73041 | 2099499.64542 | 37.7447840534392 | -122.445194057872 | (37.7447840534392, -122.445194057872) | 2 | 7 | 5 | 63 | 22 | |||
| 173825 | 116683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 22 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 175736 | 22833 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 97 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X2 | 5999264.9387203 | 2099127.2089421 | 37.7437608164767 | -122.44520460183 | (37.7437608164767, -122.44520460183) | 2 | 7 | 5 | 63 | 22 | |||
| 177720 | 24734 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 7550 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 5983519.17096 | 2112492.47566 | 37.7795467188219 | -122.500636931801 | (37.7795467188219, -122.500636931801) | 11 | 6 | 2 | 55 | 26 | |||
| 178988 | 9161 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6000 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5988297.5183 | 2112599.4463 | 37.7801197888911 | -122.48411463373 | (37.7801197888911, -122.48411463373) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 180227 | 10333 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 849 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002068.30214 | 2109102.87346 | 37.7713112029881 | -122.436225005803 | (37.7713112029881, -122.436225005803) | 15 | 5 | 11 | 29492 | 9 | |||
| 180852 | 98066 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5235 Diamond Heights Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001081.8 | 2099374.5 | 37.7445433581402 | -122.43894005993 | (37.7445433581402, -122.43894005993) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 181561 | 1357 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 315 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000103.7431583 | 2099357.1209482 | 37.7444399432052 | -122.44232072604 | (37.7444399432052, -122.44232072604) | 2 | 7 | 5 | 63 | 22 | |||
| 181813 | 211338 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501x Ortega St | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 2ft | 5992538.26817 | 2103091.89381 | 37.7542605686777 | -122.46875205787 | (37.7542605686777, -122.46875205787) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 185893 | 211336 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501x Ortega St | 10 | Median : Cutout | Tree | DPW 1 | 2 | Width 2ft | 5992533.48421 | 2103100.12483 | 37.7542828925471 | -122.468769200762 | (37.7542828925471, -122.468769200762) | 1 | 8 | 4 | 56 | 12 | |||
| 185922 | 2189 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1049 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000869.1672 | 2112323.3226 | 37.7800855395625 | -122.440603883886 | (37.7800855395625, -122.440603883886) | 15 | 5 | 1 | 29490 | 41 | |||
| 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) );