trees
168 rows where Police Districts = 8 and qSpecies_id = 47 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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 | |||
| 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 | |||
| 9903 | 257976 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2518 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5982121.52259 | 2097949.45155 | 37.7395335660245 | -122.504394221806 | (37.7395335660245, -122.504394221806) | 1 | 8 | 3 | 29491 | 35 | |||
| 11025 | 257974 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2442 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x5 | 5982413.68522 | 2098481.44408 | 37.7410114510299 | -122.503423449602 | (37.7410114510299, -122.503423449602) | 1 | 8 | 3 | 29491 | 35 | |||
| 13132 | 207127 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | 1 | 8 | 4 | 64 | 40 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 18160 | 79486 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2323 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50743 | 5981719.67239804 | 2099271.03998771 | 37.7431386384508 | -122.505881575612 | (37.7431386384508, -122.505881575612) | 1 | 8 | 3 | 29491 | 35 | |
| 18824 | 257973 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1527 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5982781.38466 | 2104724.90462 | 37.7581758647866 | -122.502614113501 | (37.7581758647866, -122.502614113501) | 1 | 8 | 3 | 56 | 35 | |||
| 19152 | 257977 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1675 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 5984366.45643 | 2103783.81819 | 37.7556849216133 | -122.497062869805 | (37.7556849216133, -122.497062869805) | 1 | 8 | 3 | 56 | 35 | |||
| 19861 | 207114 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 23 | 5992175.21623 | 2088282.16276 | 37.7135757806697 | -122.468929896991 | (37.7135757806697, -122.468929896991) | 9 | 8 | 6 | 64 | 24 | ||||
| 20037 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 47 | 155 Winston Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990788 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | 9 | 8 | 4 | 64 | 40 | |||||
| 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 | |||
| 24427 | 207105 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995373.14858 | 2091601.55002 | 37.7228742787075 | -122.458116856135 | (37.7228742787075, -122.458116856135) | 9 | 8 | 4 | 28861 | 24 | |||
| 25781 | 207137 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 103 | : | Tree | Private 2 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||
| 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 | |||
| 30167 | 207101 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990477.30542 | 2106226.48097 | 37.7627480320102 | -122.476108237903 | (37.7627480320102, -122.476108237903) | 1 | 8 | 3 | 56 | 12 | |||
| 30997 | 1213 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3411 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5993897.04108 | 2087339.7447 | 37.7110874546042 | -122.462910367622 | (37.7110874546042, -122.462910367622) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | ||||
| 34278 | 181438 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 36093 | 207107 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 89 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992169.55859 | 2088419.40871 | 37.7139522980308 | -122.468959433443 | (37.7139522980308, -122.468959433443) | 9 | 8 | 6 | 64 | 24 | ||||
| 37655 | 207106 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 100 Tara St | 2 | : | Tree | Private 2 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 40962 | 183209 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4212 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5982952.5112 | 2098143.3306 | 37.7401147458032 | -122.501535410067 | (37.7401147458032, -122.501535410067) | 1 | 8 | 3 | 29491 | 35 | |||
| 42527 | 207128 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 5991324.62806 | 2095649.61894 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | 1 | 8 | 4 | 64 | 40 | |||
| 43944 | 184307 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1553 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982166.1739 | 2104530.0154 | 37.7576045827244 | -122.50472730219 | (37.7576045827244, -122.50472730219) | 1 | 8 | 3 | 56 | 35 | |||
| 46544 | 183430 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2508 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988945.948 | 2098228.8968 | 37.7406998772059 | -122.480819050828 | (37.7406998772059, -122.480819050828) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 50593 | 83239 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4332 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.7492426575827 | -122.50658364702 | (37.7492426575827, -122.50658364702) | 1 | 8 | 3 | 29491 | 35 | |
| 52711 | 207102 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990480.89082 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) | 1 | 8 | 3 | 56 | 12 | |||
| 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 | |||
| 58446 | 183252 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5980914.4873 | 2106074.217 | 37.7617708050911 | -122.509170734828 | (37.7617708050911, -122.509170734828) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 60657 | 183431 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2506 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988944.9633 | 2098242.436 | 37.7407369950817 | -122.480823446497 | (37.7407369950817, -122.480823446497) | 1 | 8 | 3 | 29491 | 35 | |||
| 61664 | 207136 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 100 | : | Tree | Private 2 | 6 | Width 0ft | 5991240.31686 | 2092039.54753 | 37.7238385767639 | -122.472434966904 | (37.7238385767639, -122.472434966904) | 9 | 8 | 4 | 64 | 40 | |||
| 63319 | 207110 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 7 | 5992170.63195 | 2088310.84387 | 37.7136542672107 | -122.468947827707 | (37.7136542672107, -122.468947827707) | 9 | 8 | 6 | 64 | 24 | ||||
| 64416 | 183208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.7401199309313 | -122.501448961428 | (37.7401199309313, -122.501448961428) | 1 | 8 | 3 | 29491 | 35 | |||
| 64604 | 207109 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 75 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 14 | 5992170.77084 | 2088338.0326 | 37.7137289289241 | -122.468949325066 | (37.7137289289241, -122.468949325066) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | |||
| 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 | |||
| 78917 | 207118 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 12 | Front Yard : Yard | Tree | Private 2 | 27 | Width 0ft | 5991361.11034 | 2095702.06647 | 37.7339019284143 | -122.472284266614 | (37.7339019284143, -122.472284266614) | 1 | 8 | 4 | 64 | 40 | |||
| 80463 | 79056 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1862 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50038 | 5983215.17096299 | 2102463.12302331 | 37.7519911277095 | -122.500946646871 | (37.7519911277095, -122.500946646871) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 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 | |||
| 85806 | 207130 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 300 Junipero Serra Blvd | 22 | : | Tree | Private 2 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | 9 | 8 | 4 | 64 | 40 | |||
| 90219 | 41465 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2000 12:00:00 AM | 24 | Permit Number 42050 | 5983633.32729372 | 2103553.20607522 | 37.755008735539 | -122.499581179885 | (37.755008735539, -122.499581179885) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||||
| 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 | |||
| 94127 | 119281 | Undocumented 4 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992077 | 2088275 | 37.7135504383964 | -122.469268843393 | (37.7135504383964, -122.469268843393) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | |||
| 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 | |||
| 97332 | 83208 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3634 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50746 | 5981914.57527844 | 2100148.1004138 | 37.7455582728462 | -122.505272655065 | (37.7455582728462, -122.505272655065) | 1 | 8 | 3 | 29491 | 35 | |
| 100968 | 1262 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | 9 | 8 | 4 | 64 | 24 | |||
| 102436 | 184168 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3732 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5982616.4158 | 2104253.9424 | 37.7568730399942 | -122.503149769389 | (37.7568730399942, -122.503149769389) | 1 | 8 | 3 | 56 | 35 | |||
| 103582 | 83279 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.4490102 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | 1 | 8 | 3 | 29491 | 35 | |
| 107125 | 84447 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2266 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50738 | 5982378.18226568 | 2099687.61773546 | 37.7443211838051 | -122.503635505549 | (37.7443211838051, -122.503635505549) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | ||||
| 119732 | 47881 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1454 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50547 | 5982810.24276317 | 2105223.95269531 | 37.759547805419 | -122.502551248021 | (37.759547805419, -122.502551248021) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 123946 | 83251 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | |||
| 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 | |||
| 128606 | 82810 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2730 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50728 | 5983104.2980141 | 2096628.76061893 | 37.7359650625832 | -122.500898621502 | (37.7359650625832, -122.500898621502) | 1 | 8 | 3 | 29491 | 35 | ||
| 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 | ||
| 131273 | 207113 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 53 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 5 | 5992170.39113 | 2088282.95309 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | |||
| 133839 | 79951 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4332 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50745 | 5981564.36989544 | 2101497.47247657 | 37.7492426575827 | -122.50658364702 | (37.7492426575827, -122.50658364702) | 1 | 8 | 3 | 29491 | 35 | |
| 134954 | 207131 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500 Junipero Serra Blvd | 23 | : | Tree | Private 2 | 14 | Width 0ft | 5991341.74557 | 2093676.61882 | 37.7283394372056 | -122.472203623519 | (37.7283394372056, -122.472203623519) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | ||||
| 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 | |||
| 136897 | 102790 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3445 Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Permit Number 42050 | 5983633 | 2103554 | 37.7550108962308 | -122.499582370415 | (37.7550108962308, -122.499582370415) | 1 | 8 | 3 | 56 | 35 | |||
| 136968 | 29586 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 500X Junipero Serra Blvd | 21 | Median : Cutout | Tree | DPW 1 | 9 | 3X3 | 5991342.7865 | 2093687.81781 | 37.7283702470744 | -122.472200841009 | (37.7283702470744, -122.472200841009) | 9 | 8 | 4 | 64 | 40 | |||
| 137267 | 207138 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 700 Junipero Serra Blvd | 123 | : | Tree | Private 2 | 8 | Width 0ft | 5991217.22752 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | 9 | 8 | 4 | 64 | 40 | |||
| 137363 | 84886 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3138 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | Permit No. 49329 | 5983290 | 2099514 | 37.7438980447125 | -122.500469849117 | (37.7438980447125, -122.500469849117) | 1 | 8 | 3 | 29491 | 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 | |||
| 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 | |||
| 142860 | 207111 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59 Ralston St | 2 | Back Yard : Yard | Tree | Private 2 | 11 | 5992171.5605 | 2088305.6585 | 37.713640083085 | -122.468944241206 | (37.713640083085, -122.468944241206) | 9 | 8 | 6 | 64 | 24 | ||||
| 146162 | 207104 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | 9 | 8 | 4 | 28861 | 24 | |||
| 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 | |||
| 149652 | 183373 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.7365485996681 | -122.492356136884 | (37.7365485996681, -122.492356136884) | 1 | 8 | 3 | 29491 | 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 | |||
| 150862 | 234 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | 1 | 8 | 4 | 64 | 40 | |||
| 154772 | 85386 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | 1 | 8 | 3 | 56 | 35 | ||||
| 156877 | 184169 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3734 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982587.082 | 2104253.9424 | 37.7568713157118 | -122.503251214898 | (37.7568713157118, -122.503251214898) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |||
| 157961 | 207119 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 10 | Front Yard : Yard | Tree | Private 2 | 25 | Width 0ft | 5991353.65823 | 2095688.25461 | 37.7338635732432 | -122.472309024061 | (37.7338635732432, -122.472309024061) | 1 | 8 | 4 | 64 | 40 | |||
| 159820 | 29601 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 900X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991172.09001 | 2091066.888 | 37.7211639453471 | -122.472599932234 | (37.7211639453471, -122.472599932234) | 9 | 8 | 4 | 64 | 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 | |||
| 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 | |||
| 165308 | 83228 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 4234 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50748 | 5982916.47531802 | 2098139.9083931 | 37.7401032328077 | -122.50165975231 | (37.7401032328077, -122.50165975231) | 1 | 8 | 3 | 29491 | 35 | |
| 165614 | 183438 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2506 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5988326.6233 | 2098215.7152 | 37.7406276663345 | -122.482959448414 | (37.7406276663345, -122.482959448414) | 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 |
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) );