trees
139 rows where qCaretaker_id = 1 and qSpecies_id = 95 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43548 | 116682 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Esmeralda Ave | 21 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 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 | |||||
| 10524 | 18541 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 61X Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5999058.055369 | 2099782.1056805 | 37.7455471938994 | -122.445967045704 | (37.7455471938994, -122.445967045704) | 2 | 7 | 5 | 63 | 22 | |||
| 30166 | 7981 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6005603.29363 | 2117103.29165 | 37.793478593006 | -122.424566490678 | (37.793478593006, -122.424566490678) | 13 | 9 | 1 | 28858 | 27 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 43700 | 194557 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 900x Carolina St | 69 | Median : Yard | Tree | DPW 1 | 11 | 6012516.26815 | 2102828.89594 | 37.7546723295715 | -122.399644211933 | (37.7546723295715, -122.399644211933) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | ||||
| 860 | 9301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011832.70408 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | 10 | 7 | 8 | 309 | 28 | |||
| 5688 | 15705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4275 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003304.89544 | 2093685.57074 | 37.729049093647 | -122.430847134016 | (37.729049093647, -122.430847134016) | 9 | 7 | 6 | 28861 | 5 | |||
| 7140 | 19772 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 STAIRWAY17 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
| 10704 | 20369 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 262X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 12757 | 27231 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 319X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003407.79227 | 2093529.1013 | 37.7286252931888 | -122.430480251933 | (37.7286252931888, -122.430480251933) | 9 | 7 | 6 | 28861 | 5 | |||
| 30170 | 7980 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005605.28232 | 2117078.33764 | 37.7934101878854 | -122.424557833777 | (37.7934101878854, -122.424557833777) | 13 | 9 | 1 | 28858 | 27 | |||
| 33542 | 2188 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1045 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000871.5361 | 2112304.371 | 37.7800336381937 | -122.440594329111 | (37.7800336381937, -122.440594329111) | 15 | 5 | 1 | 29490 | 41 | |||
| 45187 | 251081 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5600x Geary Blvd | 3 | Median : Yard | Tree | DPW 1 | 12 | Width 10ft | 5989538.2764 | 2112645.9841 | 37.7803197290205 | -122.479825742455 | (37.7803197290205, -122.479825742455) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | |||
| 62861 | 8820 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3901X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994887.84136 | 2112763.14159 | 37.7809507447777 | -122.461327743547 | (37.7809507447777, -122.461327743547) | 11 | 6 | 2 | 54 | 11 | |||
| 64682 | 9162 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6000 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5988250.2307 | 2112596.0926 | 37.7801078273208 | -122.484277974986 | (37.7801078273208, -122.484277974986) | 11 | 6 | 2 | 55 | 26 | |||
| 68599 | 24732 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 7550 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 5983574.04404 | 2112492.98355 | 37.7795513345644 | -122.50044714294 | (37.7795513345644, -122.50044714294) | 11 | 6 | 2 | 55 | 26 | |||
| 69000 | 6370 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2090X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000874.84598 | 2112802.06696 | 37.7814003728012 | -122.440618586812 | (37.7814003728012, -122.440618586812) | 15 | 5 | 11 | 29490 | 41 | |||
| 72960 | 9133 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5845 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1994 12:00:00 AM | 12 | 3X3 | 5988825.8583 | 2112567.4837 | 37.7800627749855 | -122.48228454478 | (37.7800627749855, -122.48228454478) | 11 | 6 | 2 | 55 | 26 | ||
| 73404 | 23689 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 400X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2000 12:00:00 AM | 12 | 3X3 | 6012568.7473634 | 2117857.4681317 | 37.7959402861802 | -122.400518335953 | (37.7959402861802, -122.400518335953) | 3 | 1 | 10 | 28860 | 4 | ||
| 85093 | 8821 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3901X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994887.84136 | 2112763.14159 | 37.7809507447777 | -122.461327743547 | (37.7809507447777, -122.461327743547) | 11 | 6 | 2 | 54 | 11 | |||
| 85649 | 2235 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1250 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000835.53681 | 2113039.07181 | 37.7820488889703 | -122.44077158306 | (37.7820488889703, -122.44077158306) | 15 | 5 | 11 | 29490 | 41 | |||
| 118036 | 7723 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 175X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006514.1274 | 2110757.9768 | 37.7761073119325 | -122.420964203399 | (37.7761073119325, -122.420964203399) | 7 | 9 | 11 | 28852 | 10 | |||
| 120405 | 19203 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 630 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012250.31016 | 2117839.90491 | 37.795874297902 | -122.401618961245 | (37.795874297902, -122.401618961245) | 3 | 1 | 10 | 28860 | 4 | |||
| 123077 | 2683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2100 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003416.3801 | 2114894.2482 | 37.7872893759097 | -122.431975560402 | (37.7872893759097, -122.431975560402) | 13 | 9 | 11 | 29490 | 27 | |||
| 124165 | 22789 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1002X BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6000899 | 2112257 | 37.7799051333688 | -122.440495920848 | (37.7799051333688, -122.440495920848) | 15 | 5 | 1 | 29490 | 41 | |||
| 124239 | 9059 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5515 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5989871.6343 | 2112606.4651 | 37.7802305817586 | -122.478669624646 | (37.7802305817586, -122.478669624646) | 11 | 6 | 2 | 55 | 26 | |||
| 131164 | 9073 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 299X 20TH AVE | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5989630 | 2113690 | 37.7831916330881 | -122.479584840343 | (37.7831916330881, -122.479584840343) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 100850 | 1348 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 230 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5999612.0218269 | 2099211.2248489 | 37.7440113094062 | -122.444010510465 | (37.7440113094062, -122.444010510465) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | |||
| 19207 | 17363 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2298X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6005094.42253 | 2117295.11988 | 37.7939765536908 | -122.426340889125 | (37.7939765536908, -122.426340889125) | 13 | 9 | 1 | 28858 | 27 | |||
| 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 | |||
| 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 | |||
| 58882 | 9035 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5411 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1994 12:00:00 AM | 18 | 3X3 | 5990179.7216 | 2112616.9497 | 37.7802772527405 | -122.477604587149 | (37.7802772527405, -122.477604587149) | 11 | 6 | 2 | 55 | 26 | ||
| 94394 | 119931 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6400x Geary Blvd | 3 | Median : Yard | Tree | DPW 1 | 18 | 5987060.46823 | 2112560.63712 | 37.779941129697 | -122.4883912425 | (37.779941129697, -122.4883912425) | 11 | 6 | 2 | 55 | 26 | ||||
| 129039 | 9236 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6400 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8M | 5987194.6568724 | 2112586.3612843 | 37.7800195894976 | -122.487928920824 | (37.7800195894976, -122.487928920824) | 11 | 6 | 2 | 55 | 26 | |||
| 130498 | 26426 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1640 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006251.83822 | 2116157.44916 | 37.7909181502895 | -122.422255241997 | (37.7909181502895, -122.422255241997) | 13 | 9 | 10 | 28858 | 21 | |||
| 78296 | 211334 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 501x Ortega St | 13 | Median : Cutout | Tree | DPW 1 | 2 | Width 2ft | 5992524.38943 | 2103111.35014 | 37.7543131889121 | -122.468801469312 | (37.7543131889121, -122.468801469312) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 8749 | 934 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1295 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X6 | 6002685.65968 | 2093990.26069 | 37.7298505986268 | -122.43300963811 | (37.7298505986268, -122.43300963811) | 9 | 7 | 6 | 28861 | 25 | |||
| 12721 | 1063 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2065X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000404.00413 | 2090092.28699 | 37.7190179700695 | -122.440618085581 | (37.7190179700695, -122.440618085581) | 9 | 7 | 6 | 28861 | 25 | |||
| 25035 | 11455 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Jade Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 6000702.8384041 | 2098560.6268459 | 37.7422870867037 | -122.440192077523 | (37.7422870867037, -122.440192077523) | 2 | 7 | 5 | 63 | 7 | ||||
| 67342 | 10380 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1317 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1991 12:00:00 AM | 20 | 3X3 | 5999820.7705 | 2108786.6551 | 37.7703149945231 | -122.443976567638 | (37.7703149945231, -122.443976567638) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | |||
| 137174 | 1343 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 184 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5999370.16468 | 2099314.54467 | 37.7442812011152 | -122.44485422025 | (37.7442812011152, -122.44485422025) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 82893 | 178377 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 300x Mansell St | 18 | Median : Cutout | Tree | DPW 1 | 23 | Width 0ft | 6010782.26263 | 2090442.44739 | 37.7205649734793 | -122.404768928441 | (37.7205649734793, -122.404768928441) | 10 | 7 | 7 | 309 | 28 | |||
| 108601 | 9338 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 2 | 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 | |||
| 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 | |||
| 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 | |||
| 40807 | 7669 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2574X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998511.51637 | 2088624.61192 | 37.7148801204842 | -122.447054090567 | (37.7148801204842, -122.447054090567) | 9 | 7 | 6 | 28861 | 25 | |||
| 42422 | 3448 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 29 Cameo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5999543.2745576 | 2099744.8279027 | 37.7454725332926 | -122.444286560175 | (37.7454725332926, -122.444286560175) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 135650 | 17369 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2225X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6005023.6203 | 2117335.73677 | 37.7940840749616 | -122.426588765666 | (37.7940840749616, -122.426588765666) | 13 | 9 | 1 | 28858 | 27 | |||
| 36446 | 5031 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5310X Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001777 | 2098684 | 37.7426869370939 | -122.436486790385 | (37.7426869370939, -122.436486790385) | 2 | 7 | 5 | 63 | 7 | |||
| 41586 | 29974 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991354.73078 | 2093700.79084 | 37.7284065590072 | -122.47216049472 | (37.7284065590072, -122.47216049472) | 9 | 8 | 4 | 64 | 40 | ||
| 53794 | 3769 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1098 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
| 55900 | 17783 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1670X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/2014 12:00:00 AM | 3 | 3X3 | 6005360.49348 | 2115382.69892 | 37.7887405624242 | -122.425284104871 | (37.7887405624242, -122.425284104871) | 13 | 9 | 1 | 28858 | 41 | ||
| 62290 | 89628 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3601 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987450.45197 | 2111839.29799 | 37.7779832830206 | -122.486989142097 | (37.7779832830206, -122.486989142097) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 82857 | 9274 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6800 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12/24/2014 02:02:00 PM | 3 | 8M | 5985760.86534 | 2112510.31266 | 37.7797270399328 | -122.492883376766 | (37.7797270399328, -122.492883376766) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 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 | |||
| 106264 | 233559 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500x 27th St | 19 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6002897.95217 | 2100065.79943 | 37.746544669698 | -122.432709549607 | (37.746544669698, -122.432709549607) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 122652 | 9318 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
| 146940 | 3770 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1098 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 97999 | 18543 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 61X Quartz Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2x2 | 5999058.055369 | 2099782.1056805 | 37.7455471938994 | -122.445967045704 | (37.7455471938994, -122.445967045704) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 25808 | 211367 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1x Minerva St | 42 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5996436.78383 | 2088995.57373 | 37.7157799380719 | -122.454251973747 | (37.7157799380719, -122.454251973747) | 9 | 8 | 6 | 28861 | 24 | |||
| 91420 | 233560 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500x 27th St | 20 | Median : Cutout | Tree | DPW 1 | 4 | Width 4ft | 6002902.39579 | 2100065.70765 | 37.7465446697032 | -122.432694177509 | (37.7465446697032, -122.432694177509) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | |||
| 36225 | 22855 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 139 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999860.76134 | 2099112.81238 | 37.7437552784922 | -122.443143361677 | (37.7437552784922, -122.443143361677) | 2 | 7 | 5 | 63 | 22 |
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) );