trees
406 rows where qSpecies_id = 47 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26539 | 207135 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 99 | : | Tree | Private 2 | 5 | Width 0ft | 5991243.40911 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | 9 | 8 | 4 | 64 | 40 | |||
| 91870 | 207134 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 98 | : | Tree | Private 2 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.7238892166875 | -122.472422854852 | (37.7238892166875, -122.472422854852) | 9 | 8 | 4 | 64 | 40 | |||
| 71159 | 207133 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 90 | : | Tree | Private 2 | 10 | Width 0ft | 5991231.48328 | 2092142.91587 | 37.7241218892943 | -122.472473035196 | (37.7241218892943, -122.472473035196) | 9 | 8 | 4 | 64 | 40 | |||
| 16464 | 207116 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 5992178.8337 | 2088240.41516 | 37.7134613608383 | -122.468914357628 | (37.7134613608383, -122.468914357628) | 9 | 8 | 6 | 64 | 24 | ||||
| 44818 | 191405 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 9 | Front Yard : Yard | Tree | Private 2 | 8 | 6016216.75475 | 2100305.37684 | 37.7479488549636 | -122.386670851103 | (37.7479488549636, -122.386670851103) | 3 | 8 | 58 | 1 | |||||
| 82654 | 116655 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 87869 | 116654 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 199x Esmeralda Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 120655 | 207100 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990476.61635 | 2106239.99978 | 37.7627851110794 | -122.476111608564 | (37.7627851110794, -122.476111608564) | 1 | 8 | 3 | 56 | 12 | |||
| 126406 | 207120 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 9 | Front Yard : Yard | Tree | Private 2 | 21 | Width 0ft | 5991349.86178 | 2095682.72956 | 37.7338481831293 | -122.472321746778 | (37.7338481831293, -122.472321746778) | 1 | 8 | 4 | 64 | 40 | |||
| 181779 | 191403 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 9 | Front Yard : Yard | Tree | Private 2 | 5 | 6010692.20162 | 2107913.0668 | 37.7685304704432 | -122.406310559796 | (37.7685304704432, -122.406310559796) | 8 | 4 | 8 | 28853 | 19 | ||||
| 186347 | 207117 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 41 Ralston St | 9 | Back Yard : Yard | Tree | Private 2 | 19 | 5992170.67066 | 2088214.06867 | 37.7133885481037 | -122.468940655584 | (37.7133885481037, -122.468940655584) | 9 | 8 | 6 | 64 | 24 | ||||
| 60345 | 207132 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | 9 | 8 | 4 | 64 | 40 | |||
| 121679 | 227674 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 83 | Front Yard : Yard | Tree | Private 2 | 15 | 6005065.10158 | 2097012.05309 | 37.7382824451638 | -122.424998540269 | (37.7382824451638, -122.424998540269) | 2 | 7 | 5 | 63 | 7 | ||||
| 10441 | 191402 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 8 | Front Yard : Yard | Tree | Private 2 | 7 | 6010700.42675 | 2107913.45144 | 37.7685319866755 | -122.406282136733 | (37.7685319866755, -122.406282136733) | 8 | 4 | 8 | 28853 | 19 | ||||
| 83580 | 207121 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 8 | Front Yard : Yard | Tree | Private 2 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.7338330421511 | -122.472331306559 | (37.7338330421511, -122.472331306559) | 1 | 8 | 4 | 64 | 40 | |||
| 173115 | 191406 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 8 | Front Yard : Yard | Tree | Private 2 | 5 | 6016222.17813 | 2100305.95006 | 37.7479507291578 | -122.386652137081 | (37.7479507291578, -122.386652137081) | 3 | 8 | 58 | 1 | |||||
| 175565 | 248189 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 216 Esmeralda Ave | 8 | Side Yard : Yard | Tree | Private 2 | 11 | 6007400.67054 | 2098728.2959 | 37.7431265201804 | -122.417044843446 | (37.7431265201804, -122.417044843446) | 2 | 7 | 7 | 28859 | 2 | ||||
| 177625 | 207115 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 47 Ralston St | 8 | Back Yard : Yard | Tree | Private 2 | 8 | 5992168.43399 | 2088239.25639 | 37.7134575782774 | -122.468950218099 | (37.7134575782774, -122.468950218099) | 9 | 8 | 6 | 64 | 24 | ||||
| 2126 | 191407 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 7 | Front Yard : Yard | Tree | Private 2 | 12 | 6016225.71134 | 2100306.15132 | 37.747951477381 | -122.386639933312 | (37.747951477381, -122.386639933312) | 3 | 8 | 58 | 1 | |||||
| 48894 | 976 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1599 Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X4 | 6001942.44101 | 2093088.00211 | 37.7273310167784 | -122.435514506557 | (37.7273310167784, -122.435514506557) | 9 | 7 | 6 | 28861 | 25 | |||
| 53776 | 191401 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 7 | Front Yard : Yard | Tree | Private 2 | 8 | 6010711.19096 | 2107913.74245 | 37.7685333878424 | -122.406244924566 | (37.7685333878424, -122.406244924566) | 8 | 4 | 8 | 28853 | 19 | ||||
| 90709 | 218280 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5991369.16642 | 2095649.34471 | 37.7337576340075 | -122.472252572693 | (37.7337576340075, -122.472252572693) | 1 | 8 | 4 | 64 | 40 | ||||
| 94578 | 207099 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990478.55232 | 2106260.78747 | 37.7628423007597 | -122.476106431162 | (37.7628423007597, -122.476106431162) | 1 | 8 | 3 | 56 | 12 | |||
| 161260 | 26830 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3590X 19th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/18/1999 12:00:00 AM | 8 | 3x18 | 5990537.68384 | 2091850.07218 | 37.7232776319094 | -122.474850005219 | (37.7232776319094, -122.474850005219) | 9 | 8 | 4 | 64 | 40 | ||
| 162214 | 207122 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 7 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.472343401524 | (37.7338141267018, -122.472343401524) | 1 | 8 | 4 | 64 | 40 | |||
| 15284 | 191371 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 66 | Median : Yard | Tree | DPW 1 | 13 | 6012518.79145 | 2102845.53786 | 37.7547181653131 | -122.399636654017 | (37.7547181653131, -122.399636654017) | 10 | 3 | 8 | 28856 | 29 | ||||
| 181040 | 227673 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 64 | Front Yard : Yard | Tree | Private 2 | 12 | 6005078.09924 | 2097049.53511 | 37.7383860965292 | -122.424956266738 | (37.7383860965292, -122.424956266738) | 2 | 7 | 5 | 63 | 7 | ||||
| 6812 | 191370 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 63 | Median : Yard | Tree | DPW 1 | 15 | 6012517.15762 | 2102887.31193 | 37.7548327767283 | -122.399645237162 | (37.7548327767283, -122.399645237162) | 10 | 3 | 8 | 28856 | 29 | ||||
| 37104 | 191369 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 62 | Median : Yard | Tree | DPW 1 | 15 | 6012514.91638 | 2102899.16549 | 37.7548651990855 | -122.399653820263 | (37.7548651990855, -122.399653820263) | 10 | 3 | 8 | 28856 | 29 | ||||
| 141197 | 227672 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 15 | 6005095.2123 | 2097053.48648 | 37.7383979127325 | -122.424897379118 | (37.7383979127325, -122.424897379118) | 2 | 7 | 5 | 28859 | 7 | ||||
| 31750 | 200604 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 61 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016455.981 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | 10 | 3 | 8 | 58 | 1 | |||
| 95937 | 191368 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900x Carolina St | 60 | Median : Yard | Tree | DPW 1 | 25 | 6012502.16132 | 2102909.31056 | 37.7548923442165 | -122.399698643387 | (37.7548923442165, -122.399698643387) | 10 | 3 | 8 | 28856 | 29 | ||||
| 118985 | 227671 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1000 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 10 | 6005087.18528 | 2097058.71456 | 37.7384118144577 | -122.424925504521 | (37.7384118144577, -122.424925504521) | 2 | 7 | 5 | 63 | 7 | ||||
| 125224 | 200619 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 60 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.7336283611401 | -122.385490033201 | (37.7336283611401, -122.385490033201) | 10 | 3 | 8 | 58 | 1 | |||
| 13504 | 207123 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 6 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:51:00 AM | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.7338001863266 | -122.472359368113 | (37.7338001863266, -122.472359368113) | 1 | 8 | 4 | 64 | 40 | ||
| 20311 | 129474 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 6012536.27851 | 2120200.91706 | 37.8023730229664 | -122.400795405292 | (37.8023730229664, -122.400795405292) | 3 | 1 | 10 | 28860 | 6 | ||||
| 22890 | 50289 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
| 56934 | 191400 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010721.65743 | 2107914.21049 | 37.7685352584272 | -122.406208754734 | (37.7685352584272, -122.406208754734) | 8 | 4 | 8 | 28853 | 19 | ||||
| 27885 | 200618 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 59 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.385517359434 | (37.733637339432, -122.385517359434) | 10 | 3 | 8 | 58 | 1 | |||
| 34911 | 185504 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 58 | unknown : Yard | Tree | Private 2 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.494105581845 | (37.7420078978362, -122.494105581845) | 1 | 8 | 3 | 29491 | 35 | |||
| 113599 | 200616 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 57 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | 10 | 3 | 8 | 58 | 1 | |||
| 1399 | 185502 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2400 Sunset Blvd | 56 | unknown : Yard | Tree | Private 2 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | 1 | 8 | 3 | 29491 | 35 | |||
| 79037 | 200614 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 55 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.7336998293082 | -122.385562980445 | (37.7336998293082, -122.385562980445) | 10 | 3 | 8 | 58 | 1 | |||
| 102287 | 200612 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400x La Salle Ave | 53 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6016428.559 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | 10 | 3 | 8 | 58 | 1 | |||
| 713 | 38369 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4245 Lawton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 5 | Permit Number 40431 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | 1 | 8 | 3 | 56 | 35 | |
| 5099 | 261940 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Verna St | 5 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 14177 | 129468 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | 5 | 1 | 1 | 28858 | 32 | ||||
| 63156 | 191394 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6011327.58138 | 2104381.4608 | 37.7588689961229 | -122.403864278838 | (37.7588689961229, -122.403864278838) | 10 | 3 | 8 | 28856 | 29 | ||||
| 78182 | 113478 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100x ESMERALDA AVE | 5 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6006917 | 2098966 | 37.7437519821991 | -122.418734104398 | (37.7437519821991, -122.418734104398) | 2 | 7 | 7 | 28859 | 2 | ||||
| 89527 | 50288 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
| 99467 | 191408 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6016232.34971 | 2100308.61772 | 37.7479586171136 | -122.38661714986 | (37.7479586171136, -122.38661714986) | 3 | 8 | 58 | 1 | |||||
| 104265 | 129463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2451 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6002236.13059 | 2116512.00902 | 37.7916643510872 | -122.436174782264 | (37.7916643510872, -122.436174782264) | 13 | 9 | 1 | 29490 | 27 | |||
| 112053 | 129476 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1077 Front St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012591.30532 | 2120127.94056 | 37.8021757161919 | -122.4005998549 | (37.8021757161919, -122.4005998549) | 3 | 1 | 10 | 28860 | 6 | ||||
| 131012 | 207124 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 5 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:54:00 AM | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | 1 | 8 | 4 | 64 | 40 | ||
| 138353 | 129473 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6012532.2991 | 2120205.04389 | 37.8023841322847 | -122.400809466192 | (37.8023841322847, -122.400809466192) | 3 | 1 | 10 | 28860 | 6 | ||||
| 145003 | 129486 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012297.60436 | 2120565.6201 | 37.803361093695 | -122.401646988622 | (37.803361093695, -122.401646988622) | 3 | 1 | 10 | 28860 | 6 | ||||
| 154411 | 191399 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 5 | Front Yard : Yard | Tree | Private 2 | 5 | 6010727.66479 | 2107914.72417 | 37.7685370048986 | -122.406188011877 | (37.7685370048986, -122.406188011877) | 8 | 4 | 8 | 28853 | 19 | ||||
| 165804 | 186059 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1901 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984803.9529 | 2102180.8195 | 37.7513091577006 | -122.495431671777 | (37.7513091577006, -122.495431671777) | 1 | 8 | 3 | 29491 | 35 | |||
| 182552 | 129482 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6012315.37501 | 2120537.75286 | 37.803285568636 | -122.401583532467 | (37.803285568636, -122.401583532467) | 3 | 1 | 10 | 28860 | 6 | ||||
| 192189 | 217850 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | 5991375.86862 | 2095660.38148 | 37.7337883260711 | -122.47223020567 | (37.7337883260711, -122.47223020567) | 1 | 8 | 4 | 64 | 40 | ||||
| 174148 | 186310 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1800 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984966.7705 | 2102775.9332 | 37.7529527085207 | -122.494912513249 | (37.7529527085207, -122.494912513249) | 1 | 8 | 3 | 56 | 35 | |||
| 163899 | 191389 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 43 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011309.9548 | 2104119.65272 | 37.7581491445771 | -122.403906816767 | (37.7581491445771, -122.403906816767) | 10 | 3 | 8 | 28856 | 29 | |||
| 54525 | 191388 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 40 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011282.56063 | 2104153.62595 | 37.7582408970175 | -122.40400394893 | (37.7582408970175, -122.40400394893) | 10 | 3 | 8 | 28856 | 29 | |||
| 33940 | 129485 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012301.33061 | 2120559.21941 | 37.803343726885 | -122.401633643571 | (37.803343726885, -122.401633643571) | 3 | 1 | 10 | 28860 | 6 | ||||
| 45957 | 191393 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 6011318.33835 | 2104379.19174 | 37.758862249405 | -122.403896086039 | (37.758862249405, -122.403896086039) | 10 | 3 | 8 | 28856 | 29 | ||||
| 54058 | 129472 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | 3 | 1 | 10 | 28860 | 6 | ||||
| 69319 | 129481 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Greenwich St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6012317.54236 | 2120532.77652 | 37.8032720257522 | -122.401575682271 | (37.8032720257522, -122.401575682271) | 3 | 1 | 10 | 28860 | 6 | ||||
| 73341 | 47451 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 5049 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | 11 | 6 | 2 | 55 | 26 | ||
| 84280 | 50293 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Valley St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | 3x3 | 6003944.88624926 | 2099274.1797934 | 37.7444303848395 | -122.42903293346 | (37.7444303848395, -122.42903293346) | 2 | 7 | 5 | 63 | 22 | ||
| 105561 | 973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1599 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 0 | 6001917.27172 | 2093023.46154 | 37.72715237348 | -122.435596901293 | (37.72715237348, -122.435596901293) | 9 | 7 | 6 | 28861 | 25 | |||
| 113892 | 191398 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6010740.07849 | 2107915.77093 | 37.7685405734149 | -122.406145147482 | (37.7685405734149, -122.406145147482) | 8 | 4 | 8 | 28853 | 19 | ||||
| 150375 | 253465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
| 155046 | 129469 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1085 Vallejo St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008359.28826 | 2118585.88506 | 37.7977046844857 | -122.415135501808 | (37.7977046844857, -122.415135501808) | 5 | 1 | 10 | 308 | 21 | |||
| 156277 | 129475 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1077 Front St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 6012586.09993 | 2120128.51859 | 37.8021770130129 | -122.4006179088 | (37.8021770130129, -122.4006179088) | 3 | 1 | 10 | 28860 | 6 | ||||
| 160576 | 186058 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1901 Sunset Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984794.5256 | 2102183.7824 | 37.7513167410032 | -122.495464490464 | (37.7513167410032, -122.495464490464) | 1 | 8 | 3 | 29491 | 35 | |||
| 174244 | 207112 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 12 | 5992171.74672 | 2088295.87352 | 37.7136132266511 | -122.468942885919 | (37.7136132266511, -122.468942885919) | 9 | 8 | 6 | 64 | 24 | ||||
| 183941 | 207125 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 4 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:56:00 AM | 13 | Width 0ft | 5991332.89244 | 2095658.50101 | 37.7337806755214 | -122.47237864866 | (37.7337806755214, -122.47237864866) | 1 | 8 | 4 | 64 | 40 | ||
| 179733 | 191387 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 39 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6011279.1597 | 2104155.21456 | 37.7582450689735 | -122.404015822688 | (37.7582450689735, -122.404015822688) | 10 | 3 | 8 | 28856 | 29 | |||
| 182337 | 191386 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 38 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 6011275.59142 | 2104157.94605 | 37.7582523696726 | -122.404028355649 | (37.7582523696726, -122.404028355649) | 10 | 3 | 8 | 28856 | 29 | |||
| 133496 | 191385 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 37 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011271.65755 | 2104161.44484 | 37.7582617567794 | -122.404042206986 | (37.7582617567794, -122.404042206986) | 10 | 3 | 8 | 28856 | 29 | |||
| 173649 | 186041 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1900 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 0ft | 5984992.0482 | 2102149.6578 | 37.7512346080754 | -122.494778929254 | (37.7512346080754, -122.494778929254) | 1 | 8 | 3 | 29491 | 35 | |||
| 174988 | 29627 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900X Junipero Serra Blvd | 36 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 12 | 3X3 | 5991152.87782 | 2090760.03066 | 37.7203202787275 | -122.472643981031 | (37.7203202787275, -122.472643981031) | 9 | 8 | 4 | 64 | 40 | ||
| 105958 | 191384 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 35 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011268.81564 | 2104171.75859 | 37.7582899172605 | -122.40405276143 | (37.7582899172605, -122.40405276143) | 10 | 3 | 8 | 28856 | 29 | |||
| 123019 | 191383 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 34 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6011269.17641 | 2104180.10815 | 37.7583128634534 | -122.404052101317 | (37.7583128634534, -122.404052101317) | 10 | 3 | 8 | 28856 | 29 | |||
| 181108 | 191382 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 33 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011269.01089 | 2104184.59965 | 37.7583251868659 | -122.404052989848 | (37.7583251868659, -122.404052989848) | 10 | 3 | 8 | 28856 | 29 | |||
| 47779 | 138264 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 32 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.446995936272 | (37.7823276740968, -122.446995936272) | 15 | 5 | 1 | 54 | 16 | |||
| 167360 | 191381 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011271.17001 | 2104191.36243 | 37.7583438765916 | -122.404045998546 | (37.7583438765916, -122.404045998546) | 10 | 3 | 8 | 28856 | 29 | |||
| 122548 | 191380 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6011289.9844 | 2104226.04846 | 37.7584401679041 | -122.403983370659 | (37.7584401679041, -122.403983370659) | 10 | 3 | 8 | 28856 | 29 | ||||
| 2211 | 129471 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6012526.59847 | 2120207.76193 | 37.8023912773999 | -122.400829384367 | (37.8023912773999, -122.400829384367) | 3 | 1 | 10 | 28860 | 6 | ||||
| 16955 | 191397 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2100 Alameda St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6010751.13717 | 2107916.66974 | 37.768543659889 | -122.406106959582 | (37.768543659889, -122.406106959582) | 8 | 4 | 8 | 28853 | 19 | ||||
| 23023 | 185776 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2113 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5987480.2363 | 2102327.5294 | 37.7518683261067 | -122.486187667743 | (37.7518683261067, -122.486187667743) | 1 | 8 | 3 | 29491 | 35 | |||
| 24972 | 191392 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6011311.05886 | 2104374.20224 | 37.7588481426559 | -122.403920910926 | (37.7588481426559, -122.403920910926) | 10 | 3 | 8 | 28856 | 29 | ||||
| 54154 | 129479 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012506.13221 | 2120230.97584 | 37.8024538756 | -122.400901840066 | (37.8024538756, -122.400901840066) | 3 | 1 | 10 | 28860 | 6 | ||||
| 62191 | 255989 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3512 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782138 | 6003384.96446 | 2106555.65654 | 37.7643918851964 | -122.431488741482 | (37.7643918851964, -122.431488741482) | 15 | 4 | 5 | 28862 | 3 | |
| 66429 | 183655 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4000 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5982394.94 | 2104929.8732 | 37.7587159336991 | -122.503965765246 | (37.7587159336991, -122.503965765246) | 1 | 8 | 3 | 56 | 35 | |||
| 67268 | 118441 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 5201 Anza St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5982477.73735 | 2111660.7356 | 37.7772018111581 | -122.504178007129 | (37.7772018111581, -122.504178007129) | 11 | 6 | 2 | 55 | 26 | |||
| 70915 | 253464 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
| 71469 | 176984 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2935x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | Width 3ft | 5996985 | 2087493 | 37.71168564061 | -122.45224873895 | (37.71168564061, -122.45224873895) | 9 | 7 | 6 | 28861 | 25 | |||
| 80039 | 129480 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 11 Greenwich St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012320.77236 | 2120522.45554 | 37.8032438670795 | -122.401563778859 | (37.8032438670795, -122.401563778859) | 3 | 1 | 10 | 28860 | 6 | ||||
| 81496 | 207129 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4986 19th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5990655.7482 | 2093855.39662 | 37.7287905920011 | -122.47458816511 | (37.7287905920011, -122.47458816511) | 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) );