trees
406 rows where qSpecies_id = 47 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 21600 | 105136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 175X ESMERALDA AVE | 2 | unknown : Yard | Tree | DPW 1 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | |||||
| 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 | |||
| 40373 | 186512 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 13 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 49732 | 186510 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 11 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.7591962518414 | -122.509142853237 | (37.7591962518414, -122.509142853237) | 1 | 8 | 3 | 56 | 35 | |||
| 69315 | 138260 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2600 GEARY BLVD | 28 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | 15 | 5 | 1 | 54 | 16 | |||
| 94439 | 186509 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 10 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 5980901.3856 | 2105130.6001 | 37.759179132228 | -122.509145973072 | (37.759179132228, -122.509145973072) | 1 | 8 | 3 | 56 | 35 | |||
| 149118 | 186513 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1400 Lower Great Hwy | 14 | unknown : Yard | Tree | Private 2 | 5 | Width 0ft | 5980894.1374 | 2105147.1675 | 37.759224194224 | -122.509172270667 | (37.759224194224, -122.509172270667) | 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 | ||||
| 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 | ||||
| 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 | |||||
| 88904 | 116681 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 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 | ||||
| 17241 | 186756 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | 1 | 8 | 3 | 56 | 35 | |||
| 27854 | 185961 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2001 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984861.3455 | 2101337.8929 | 37.7489980727428 | -122.495171051634 | (37.7489980727428, -122.495171051634) | 1 | 8 | 3 | 29491 | 35 | |||
| 49589 | 186745 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | 1 | 8 | 3 | 56 | 35 | |||
| 50732 | 253463 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 2 | 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 | ||
| 55330 | 186759 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984850.1974 | 2106711.7495 | 37.7637525404811 | -122.495605915184 | (37.7637525404811, -122.495605915184) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||
| 80079 | 129470 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 45 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6008463.14234 | 2119145.61201 | 37.7992473914164 | -122.414815771241 | (37.7992473914164, -122.414815771241) | 5 | 1 | 10 | 308 | 32 | ||||
| 117562 | 217831 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 5991381.66969 | 2095739.82508 | 37.734006793868 | -122.472215938837 | (37.734006793868, -122.472215938837) | 1 | 8 | 4 | 64 | 40 | ||||
| 127928 | 186748 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 0ft | 5984868.1469 | 2106676.3356 | 37.7636563549354 | -122.495541222153 | (37.7636563549354, -122.495541222153) | 1 | 8 | 3 | 56 | 35 | |||
| 133352 | 186762 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984853.5932 | 2106716.1156 | 37.7637647274179 | -122.495594492387 | (37.7637647274179, -122.495594492387) | 1 | 8 | 3 | 56 | 35 | |||
| 136020 | 186747 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984869.1172 | 2106666.6331 | 37.7636297714118 | -122.495537150576 | (37.7636297714118, -122.495537150576) | 1 | 8 | 3 | 56 | 35 | |||
| 136029 | 186000 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1883 47th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5981612.0444 | 2102288.7145 | 37.7514179925848 | -122.506477461595 | (37.7514179925848, -122.506477461595) | 1 | 8 | 3 | 56 | 35 | |||
| 138219 | 186752 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984851.1676 | 2106688.9488 | 37.7636899929755 | -122.495600877764 | (37.7636899929755, -122.495600877764) | 1 | 8 | 3 | 56 | 35 | |||
| 149988 | 186750 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984851.1676 | 2106678.2761 | 37.7636606887382 | -122.495600090514 | (37.7636606887382, -122.495600090514) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 157835 | 186754 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984863.7808 | 2106693.8 | 37.763704051609 | -122.495557611102 | (37.763704051609, -122.495557611102) | 1 | 8 | 3 | 56 | 35 | |||
| 159025 | 253462 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 98X Marston Ave | 1 | 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 185713 | 186760 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984860.8701 | 2106711.7495 | 37.7637531654529 | -122.495569002148 | (37.7637531654529, -122.495569002148) | 1 | 8 | 3 | 56 | 35 | |||
| 192203 | 186749 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1200 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984860.385 | 2106678.2761 | 37.7636612284897 | -122.495568210877 | (37.7636612284897, -122.495568210877) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 31184 | 218289 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5991265.02617 | 2095485.25519 | 37.7333010580894 | -122.472600653515 | (37.7333010580894, -122.472600653515) | 1 | 8 | 4 | 64 | 40 | ||||
| 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 | ||||
| 40263 | 227676 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 427 Valley St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6003106.32375 | 2099187.31259 | 37.7441443647786 | -122.431926305762 | (37.7441443647786, -122.431926305762) | 2 | 7 | 5 | 63 | 22 | ||||
| 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 | ||||
| 46709 | 191390 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | 6011298.55233 | 2104376.91383 | 37.7588548893488 | -122.403964355369 | (37.7588548893488, -122.403964355369) | 10 | 3 | 8 | 28856 | 29 | ||||
| 47603 | 218294 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5991183.55146 | 2095353.09261 | 37.7329334566034 | -122.472872697534 | (37.7329334566034, -122.472872697534) | 1 | 8 | 4 | 64 | 40 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 55583 | 191391 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 845 Vermont St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011306.2123 | 2104378.54497 | 37.7588597960547 | -122.403937978273 | (37.7588597960547, -122.403937978273) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 69496 | 191376 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011285.44743 | 2104312.53247 | 37.7586773802801 | -122.404005147727 | (37.7586773802801, -122.404005147727) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 84866 | 227691 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 309 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006868.92044 | 2097195.64462 | 37.7388882743696 | -122.418774826116 | (37.7388882743696, -122.418774826116) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 93238 | 129477 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012514.7758 | 2120236.23138 | 37.8024687881724 | -122.400872298239 | (37.8024687881724, -122.400872298239) | 3 | 1 | 10 | 28860 | 6 | ||||
| 95984 | 191373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011285.49599 | 2104337.84522 | 37.7587468861739 | -122.40400676112 | (37.7587468861739, -122.40400676112) | 10 | 3 | 8 | 28856 | 29 | ||||
| 98199 | 191377 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6011285.82751 | 2104250.98235 | 37.7585083985743 | -122.403999501776 | (37.7585083985743, -122.403999501776) | 10 | 3 | 8 | 28856 | 29 | ||||
| 98776 | 129484 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 6012303.28877 | 2120555.11364 | 37.8033325627054 | -122.401626578498 | (37.8033325627054, -122.401626578498) | 3 | 1 | 10 | 28860 | 6 | ||||
| 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 | |||
| 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 | ||||
| 112785 | 191378 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 28 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011285.84337 | 2104240.29901 | 37.7584790653842 | -122.40399869511 | (37.7584790653842, -122.40399869511) | 10 | 3 | 8 | 28856 | 29 | ||||
| 113543 | 191379 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6011295.70989 | 2104243.81406 | 37.758489268176 | -122.403964819445 | (37.758489268176, -122.403964819445) | 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 | ||||
| 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 | |||
| 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 | |||
| 135265 | 218293 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1 Woodacre Dr | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5991192.67429 | 2095369.91493 | 37.7329801745819 | -122.472842384068 | (37.7329801745819, -122.472842384068) | 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 | ||||
| 141612 | 183278 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1255 42nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983028.2339 | 2106536.9311 | 37.7631656789881 | -122.501894487796 | (37.7631656789881, -122.501894487796) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||||
| 145811 | 129483 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012307.75016 | 2120551.40866 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | 3 | 1 | 10 | 28860 | 6 | ||||
| 152884 | 129478 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 12 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6012509.68294 | 2120230.66756 | 37.8024532271953 | -122.400889531035 | (37.8024532271953, -122.400889531035) | 3 | 1 | 10 | 28860 | 6 | ||||
| 155190 | 227690 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.418720092463 | (37.7389434396991, -122.418720092463) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 161986 | 122182 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5991497.78568 | 2114857.01928 | 37.7865042639669 | -122.473208256238 | (37.7865042639669, -122.473208256238) | 11 | 6 | 1 | 54 | 33 | ||||
| 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 | |||
| 165316 | 191374 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011292.66605 | 2104334.91271 | 37.7587392347502 | -122.403981757255 | (37.7587392347502, -122.403981757255) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 192536 | 191375 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 800 Vermont St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 6011300.32576 | 2104333.131 | 37.7587347705187 | -122.403955140934 | (37.7587347705187, -122.403955140934) | 10 | 3 | 8 | 28856 | 29 | ||||
| 93 | 260525 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3437x Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | |
| 929 | 257972 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2091 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5982601.27724 | 2100898.28737 | 37.7476584613609 | -122.502953711343 | (37.7476584613609, -122.502953711343) | 1 | 8 | 3 | 29491 | 35 | ||||
| 2561 | 50575 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1347 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | 0 | Permit Number 47190 | 5983353.97136461 | 2105974.76120709 | 37.7616412492229 | -122.50072631562 | (37.7616412492229, -122.50072631562) | 1 | 8 | 3 | 56 | 35 | |
| 3158 | 44124 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | 11 | 6 | 2 | 55 | 26 | |||
| 4229 | 80358 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 336 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6011201.39619 | 2088230.44969 | 37.7145146953757 | -122.403164591892 | (37.7145146953757, -122.403164591892) | 10 | 7 | 8 | 309 | 39 | |||
| 4749 | 227685 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5997626.03081 | 2107071.20572 | 37.765479368391 | -122.451444382046 | (37.765479368391, -122.451444382046) | 15 | 5 | 11 | 29492 | 9 | |||
| 8913 | 50707 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1658 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2004 12:00:00 AM | 5 | Permit Number 47266 | 5983788.66504778 | 2103867.70402192 | 37.75588137239 | -122.499067221884 | (37.75588137239, -122.499067221884) | 1 | 8 | 3 | 56 | 35 | |
| 9451 | 84120 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 336 Campbell Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011186.92342 | 2088226.0732 | 37.7145018701492 | -122.403214308206 | (37.7145018701492, -122.403214308206) | 10 | 7 | 8 | 309 | 39 | |||
| 9695 | 260526 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3437x Rivera St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
| 9810 | 257975 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2151 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5981994.87893 | 2100458.26928 | 37.7464146351308 | -122.505017963467 | (37.7464146351308, -122.505017963467) | 1 | 8 | 3 | 29491 | 35 |
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) );