trees

406 rows where qSpecies_id = 47 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
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
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
102287 200612 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 53 Median : Cutout Tree DPW 1     4 Width 0ft   6016428.559 2095128.7713 37.7337466722751 -122.385577718213 (37.7337466722751, -122.385577718213) 10 3 8 58 1
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
113599 200616 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 57 Median : Cutout Tree DPW 1     7 Width 0ft   6016436.8835 2095099.8803 37.7336678039609 -122.385546924914 (37.7336678039609, -122.385546924914) 10 3 8 58 1
118542 138270 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 218 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998383.8821 2112677.2272 37.7809154323836 -122.449227076582 (37.7809154323836, -122.449227076582) 15 6 2 54 16
125224 200619 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1400x La Salle Ave 60 Median : Cutout Tree DPW 1     8 Width 0ft   6016453.0429 2095085.1899 37.7336283611401 -122.385490033201 (37.7336283611401, -122.385490033201) 10 3 8 58 1
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
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
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
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
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
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
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
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
166333 244098 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1601 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5998815.2972 2108995.6351 37.7708313932465 -122.447469528169 (37.7708313932465, -122.447469528169) 15 5 11 29492 9
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
174440 246123 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 35 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2017 12:00:00 AM 3 Width 0ft Permit Number 779621 5998184.8878 2108385.4066 37.7691198159889 -122.449606139087 (37.7691198159889, -122.449606139087) 15 5 11 29492 9
174774 249938 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 339 Filbert St 3 Front Yard : Yard Tree Private 2     8 Width 0ft   6011244.68883 2120032.52194 37.8018385261831 -122.405253098256 (37.8018385261831, -122.405253098256) 3 1 10 308 23
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
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
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
148733 24276 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 350X Winding Way 14 Median : Cutout Tree DPW 1     6 8   6000825.35085 2086800.6303 37.7100038012068 -122.438925891137 (37.7100038012068, -122.438925891137) 9 7 6 28861 5
68936 13417 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 400 Marietta Dr 1 Median : Cutout Tree DPW 1     70 5   5999553.15658 2097034.91654 37.7380323275191 -122.444057708717 (37.7380323275191, -122.444057708717) 9 7 4 59 40
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
182837 890 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1146 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     25 4X4   6003547.94647 2094400.70663 37.7310264639915 -122.430057882374 (37.7310264639915, -122.430057882374) 9 7 5 28861 25
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
169833 2477 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2307X Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x4   6003648.68016 2115921.80581 37.7901239554137 -122.43124522669 (37.7901239554137, -122.43124522669) 13 9 1 29490 27
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
22890 50289 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
25754 47111 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 189 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/03/2002 12:00:00 AM 6 3x3 Permit Number 45095 6007076.38254046 2097931.15674799 37.7409195061747 -122.418109646545 (37.7409195061747, -122.418109646545) 2 7 7 28859 2
36662 121603 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 749 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3x3   6012453.25739 2104452.2107 37.7591260835233 -122.399976111225 (37.7591260835233, -122.399976111225) 10 3 8 28856 29
47089 12917 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915) 9 7 6 28861 25
47586 57377 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3505 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006157.87748572 2102561.9990288 37.7535830045092 -122.421614323469 (37.7535830045092, -122.421614323469) 2 4 5 28859 19
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
50732 253463 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 2 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
62191 255989 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003384.96446 2106555.65654 37.7643918851964 -122.431488741482 (37.7643918851964, -122.431488741482) 15 4 5 28862 3
63526 882 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1138X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/26/2016 12:00:00 AM 28 3x3   6003576.60001 2094409.97393 37.7310535326811 -122.429959483056 (37.7310535326811, -122.429959483056) 9 7 5 28861 25
63925 167503 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003389.60758 2106563.82057 37.7644145648084 -122.431473265088 (37.7644145648084, -122.431473265088) 15 4 5 28862 3
70915 253464 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 3 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
79169 56335 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 354 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2016 12:00:00 AM 3 3x3 Permit Number 777757 5987487.44856113 2113581.55129815 37.7827691737362 -122.486989143207 (37.7827691737362, -122.486989143207) 11 6 2 55 26
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
84280 50293 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
87369 81868 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3012-3014 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52207 6009486.0303434 2101043.89087343 37.749601722793 -122.409997630916 (37.749601722793, -122.409997630916) 2 4 7 28859 19
89527 50288 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
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
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
101273 12918 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2935X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     45 3x3   5996989.32715 2087489.72289 37.7116768903089 -122.452233546915 (37.7116768903089, -122.452233546915) 9 7 6 28861 25
102767 109138 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 759 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773583 5985365.40132 2110729.9835 37.7748156320332 -122.494120186241 (37.7748156320332, -122.494120186241) 11 6 2 55 26
103423 82598 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3503 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52081 6006166.2666896 2102562.46439955 37.7535847553547 -122.421585344765 (37.7535847553547, -122.421585344765) 2 4 5 28859 19
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
105029 43632 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1001 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50556 5996213.47474732 2098545.79305022 37.7419897418411 -122.455713757113 (37.7419897418411, -122.455713757113) 9 7 4 59 40
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
112832 50290 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
113945 50219 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 2726 Balboa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2004 12:00:00 AM 8 3x3 Permit Number 46926 5987073.25597 2111201.47184 37.776209992885 -122.488247096133 (37.776209992885, -122.488247096133) 11 6 2 55 26
113972 50292 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
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
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
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
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
139898 105256 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 162 Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2014 12:00:00 AM   3x3 Permit Number 771043 6004383.3 2090213.9 37.7195776934466 -122.42687185684 (37.7195776934466, -122.42687185684) 9 7 6 28861 5
150375 253465 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 4 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
154538 926 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 1278 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6002807.70183 2094157.47604 37.7303166558715 -122.432599664217 (37.7303166558715, -122.432599664217) 9 7 5 28861 25
157287 115975 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 100 SAN JOSE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6006168 2102576 37.7536220187283 -122.421580311855 (37.7536220187283, -122.421580311855) 2 4 5 28859 19
159025 253462 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 98X Marston Ave 1 Sidewalk: Property side : Yard Tree Private 2   09/12/2017 12:00:00 AM 3 3x3   5998793 2093251 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362) 9 7 4 28861 40
163946 117519 Undocumented 4 Leptospermum laevigatum :: Australian Tea Tree 47 1601 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998904 2109014 37.7708868872166 -122.447164026359 (37.7708868872166, -122.447164026359) 15 5 11 29492 9
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
165906 84133 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 23 Tucker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 5 3x3 Permit Number 50705 6011012.12355 2088466.51247 37.7151523039101 -122.403835398892 (37.7151523039101, -122.403835398892) 9 7 8 309 39
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
174016 167504 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 3512 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2018 12:00:00 AM 3 3x3 Permit Number 782138 6003358.46768 2106563.63668 37.7644122949287 -122.431580956196 (37.7644122949287, -122.431580956196) 15 4 5 28862 3
177935 121420 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1155x Prague St 1 Median : Cutout Tree DPW 1       3x3   6000780 2086820 37.7100544057225 -122.439084019343 (37.7100544057225, -122.439084019343) 9 7 6 28861 5
181261 36317 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 208 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2008 12:00:00 AM   3x3 Permit Number 51552 5996115.78800404 2094224.07875239 37.7301177594719 -122.455739200241 (37.7301177594719, -122.455739200241) 9 7 4 28861 40
190719 109133 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 774 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773526 5985442.4 2110611.6 37.7744950899459 -122.493845109753 (37.7744950899459, -122.493845109753) 11 6 2 55 26
193338 50291 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 300 Valley St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797934 37.7444303848395 -122.42903293346 (37.7444303848395, -122.42903293346) 2 7 5 63 22
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
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
48894 976 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1599 Alemany Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X4   6001942.44101 2093088.00211 37.7273310167784 -122.435514506557 (37.7273310167784, -122.435514506557) 9 7 6 28861 25
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
56036 909 DPW Maintained 1 Leptospermum laevigatum :: Australian Tea Tree 47 1217 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     45 3X3   6003163.68633 2094174.89484 37.7303846655151 -122.431370220756 (37.7303846655151, -122.431370220756) 9 7 6 28861 25
99445 9277 Permitted Site 7 Leptospermum laevigatum :: Australian Tea Tree 47 2161X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6000049.09202 2089751.67924 37.7180625213905 -122.441820442737 (37.7180625213905, -122.441820442737) 9 7 6 28861 25

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