307 rows where qCareAssistant = "" and qSpecies_id = 47 sorted by Fire Prevention Districts

View and edit SQL

qCareAssistant

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);