trees
307 rows where qCareAssistant = "" and qSpecies_id = 47 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
13849 | 117428 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | |||||||||||||
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 | |||||
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 | |||||
135665 | 191404 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Tulare St | 14 | Front Yard : Yard | Tree | Private 2 | 20 | 6016173.59275 | 2100299.3088 | 37.7479298037296 | -122.3868196817 | (37.7479298037296, -122.3868196817) | 3 | 8 | 58 | 1 | |||||
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 | |||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
56247 | 35417 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | |
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 | ||
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 | |
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 | |||
136204 | 35418 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
166199 | 79279 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2706 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50726 | 5983101.82229012 | 2096724.27729962 | 37.7362271801162 | -122.50091424264 | (37.7362271801162, -122.50091424264) | 1 | 8 | 3 | 29491 | 35 | ||
171915 | 82814 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2724 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50727 | 5983103.67908303 | 2096652.63979189 | 37.7360305919754 | -122.500902526777 | (37.7360305919754, -122.500902526777) | 1 | 8 | 3 | 29491 | 35 | ||
172236 | 207126 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2 Cranleigh Dr | 3 | Front Yard : Yard | Tree | DPW 1 | 08/18/2016 09:59:00 AM | 13 | Width 0ft | 5991329.52565 | 2095655.77453 | 37.7337729944342 | -122.472390089849 | (37.7337729944342, -122.472390089849) | 1 | 8 | 4 | 64 | 40 | ||
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 | |||
181516 | 182942 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2671 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982115.1 | 2096931.8144 | 37.7367390358824 | -122.504341059874 | (37.7367390358824, -122.504341059874) | 1 | 8 | 3 | 29491 | 35 | |||
181949 | 218284 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 50x Junipero Serra Frontage West | 0 | Median : Yard | Tree | DPW 1 | 28 | 5991438.8932 | 2095398.77837 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | 1 | 8 | 4 | 64 | 40 | ||||
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 | ||
184163 | 184574 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 1706 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981029.903 | 2103411.5484 | 37.7544666834786 | -122.508573887519 | (37.7544666834786, -122.508573887519) | 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 | |||
185884 | 35419 | Permitted Site 7 | Leptospermum laevigatum :: Australian Tea Tree 47 | 221 Crestmont Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1998 12:00:00 AM | Permit Number 38870 | 5995170.62655697 | 2103759.11614599 | 37.7562443131302 | -122.459697089533 | (37.7562443131302, -122.459697089533) | 1 | 5 | 4 | 63 | 12 | |||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
28693 | 191372 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 2220 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6011446.77315 | 2104664.66226 | 37.7596532625069 | -122.403471980161 | (37.7596532625069, -122.403471980161) | 10 | 3 | 8 | 28856 | 29 | |||
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 |
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) );