Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22307 | 22307 | 246123 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 35 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779621 | 5998184.8878 | 2108385.4066 | 37.7691198159889 | -122.44960613908701 | (37.7691198159889, -122.449606139087) | |
23861 | 23861 | 184307 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1553 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982166.1739 | 2104530.0154 | 37.7576045827244 | -122.50472730219 | (37.7576045827244, -122.50472730219) | |||
24102 | 24102 | 186759 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984850.1974 | 2106711.7495 | 37.7637525404811 | -122.495605915184 | (37.7637525404811, -122.495605915184) | |||
24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
24900 | 24900 | 249938 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 339 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011244.68883 | 2120032.5219400004 | 37.8018385261831 | -122.405253098256 | (37.8018385261831, -122.405253098256) | |||
29234 | 29234 | 186513 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980894.1374 | 2105147.1675 | 37.759224194224 | -122.509172270667 | (37.759224194224, -122.509172270667) | |||
30866 | 30866 | 200618 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 59 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6016445.2081 | 2095088.6176 | 37.733637339432 | -122.38551735943399 | (37.733637339432, -122.385517359434) | |||
31036 | 31036 | 181438 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | |||
33000 | 33000 | 138260 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2600 GEARY BLVD | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | |||
34046 | 34046 | 186310 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1800 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984966.7705 | 2102775.9332 | 37.7529527085207 | -122.49491251324899 | (37.7529527085207, -122.494912513249) | |||
36322 | 36322 | 183431 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2506 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988944.9633 | 2098242.4359999998 | 37.740736995081704 | -122.480823446497 | (37.7407369950817, -122.480823446497) | |||
36675 | 36675 | 186762 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984853.5932 | 2106716.1156 | 37.7637647274179 | -122.49559449238701 | (37.7637647274179, -122.495594492387) | |||
37604 | 37604 | 184574 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1706 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981029.903 | 2103411.5484 | 37.754466683478604 | -122.50857388751899 | (37.7544666834786, -122.508573887519) | |||
38728 | 38728 | 200604 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 61 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016455.981000001 | 2095075.886 | 37.7336029770488 | -122.385479227084 | (37.7336029770488, -122.385479227084) | |||
41740 | 41740 | 183278 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1255 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983028.2339 | 2106536.9311 | 37.7631656789881 | -122.50189448779601 | (37.7631656789881, -122.501894487796) | |||
44625 | 44625 | 186760 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984860.8701 | 2106711.7495 | 37.7637531654529 | -122.495569002148 | (37.7637531654529, -122.495569002148) | |||
45882 | 45882 | 186748 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984868.1469 | 2106676.3356 | 37.7636563549354 | -122.495541222153 | (37.7636563549354, -122.495541222153) | |||
48955 | 48955 | 183430 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2508 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988945.948 | 2098228.8968 | 37.7406998772059 | -122.480819050828 | (37.7406998772059, -122.480819050828) | |||
50007 | 50007 | 186756 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | |||
50995 | 50995 | 186509 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980901.3856 | 2105130.6001 | 37.759179132228 | -122.509145973072 | (37.759179132228, -122.509145973072) | |||
52773 | 52773 | 183252 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5980914.4873 | 2106074.2169999997 | 37.761770805091096 | -122.50917073482799 | (37.7617708050911, -122.509170734828) | |||
53270 | 53270 | 207125 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991332.892440001 | 2095658.5010099998 | 37.733780675521395 | -122.47237864866001 | (37.7337806755214, -122.47237864866) | |||
56665 | 56665 | 183655 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4000 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982394.94 | 2104929.8732 | 37.7587159336991 | -122.503965765246 | (37.7587159336991, -122.503965765246) | |||
59085 | 59085 | 185502 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 56 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985117.0889 | 2098738.1726 | 37.7418749156753 | -122.494095121998 | (37.7418749156753, -122.494095121998) | |||
60545 | 60545 | 207126 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991329.52565 | 2095655.7745299998 | 37.733772994434204 | -122.472390089849 | (37.7337729944342, -122.472390089849) | |||
63860 | 63860 | 207135 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 99 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991243.409109999 | 2092046.59438 | 37.7238581046423 | -122.472424791093 | (37.7238581046423, -122.472424791093) | |||
65093 | 65093 | 185504 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2400 Sunset Blvd | 58 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985115.0968 | 2098786.6474 | 37.7420078978362 | -122.49410558184499 | (37.7420078978362, -122.494105581845) | |||
66007 | 66007 | 186752 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106688.9488 | 37.7636899929755 | -122.49560087776399 | (37.7636899929755, -122.495600877764) | |||
66262 | 66262 | 138270 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.44922707658199 | (37.7809154323836, -122.449227076582) | |||
66913 | 66913 | 186510 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.759196251841395 | -122.509142853237 | (37.7591962518414, -122.509142853237) | |||
67484 | 67484 | 207132 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 87 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5991236.29103 | 2092157.26983 | 37.7241615799784 | -122.472457461649 | (37.7241615799784, -122.472457461649) | |||
70133 | 70133 | 186750 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106678.2761 | 37.763660688738206 | -122.49560009051399 | (37.7636606887382, -122.495600090514) | |||
70945 | 70945 | 185776 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2113 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5987480.2363 | 2102327.5294 | 37.7518683261067 | -122.486187667743 | (37.7518683261067, -122.486187667743) | |||
72294 | 72294 | 200614 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 55 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6016432.4764 | 2095111.6325 | 37.73369982930821 | -122.385562980445 | (37.7336998293082, -122.385562980445) | |||
72315 | 72315 | 207127 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 5991327.69264 | 2095651.06492 | 37.7337599569436 | -122.472396083831 | (37.7337599569436, -122.472396083831) | |||
73459 | 73459 | 186747 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984869.1172 | 2106666.6331 | 37.76362977141179 | -122.495537150576 | (37.7636297714118, -122.495537150576) | |||
76333 | 76333 | 200612 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6016428.558999999 | 2095128.7713 | 37.7337466722751 | -122.385577718213 | (37.7337466722751, -122.385577718213) | |||
76733 | 76733 | 200616 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 57 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016436.8835 | 2095099.8803 | 37.7336678039609 | -122.385546924914 | (37.7336678039609, -122.385546924914) | |||
132080 | 132080 | 207131 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 500 Junipero Serra Blvd | 23 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991341.745569999 | 2093676.61882 | 37.7283394372056 | -122.47220362351901 | (37.7283394372056, -122.472203623519) | |||
132288 | 132288 | 207130 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Junipero Serra Blvd | 22 | : 4 | Tree 1 | Private 1 | 24 | Width 0ft | 5991387.56325 | 2094477.49413 | 37.7305410918021 | -122.472103582925 | (37.7305410918021, -122.472103582925) | |||
133677 | 133677 | 185961 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2001 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984861.3455 | 2101337.8929 | 37.74899807274279 | -122.495171051634 | (37.7489980727428, -122.495171051634) | |||
135684 | 135684 | 183373 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2728 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985578.5174 | 2096788.4906 | 37.736548599668104 | -122.492356136884 | (37.7365485996681, -122.492356136884) | |||
136946 | 136946 | 244098 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998815.2972 | 2108995.6351 | 37.770831393246496 | -122.44746952816901 | (37.7708313932465, -122.447469528169) | |||
137132 | 137132 | 200619 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400x La Salle Ave | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6016453.0429 | 2095085.1899 | 37.733628361140106 | -122.38549003320101 | (37.7336283611401, -122.385490033201) | |||
148023 | 148023 | 207134 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 98 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991244.20773 | 2092057.90852 | 37.723889216687496 | -122.47242285485201 | (37.7238892166875, -122.472422854852) | |||
148752 | 148752 | 207137 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 103 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991231.72322 | 2092011.81443 | 37.7237619311543 | -122.47246265254 | (37.7237619311543, -122.47246265254) | |||
151432 | 151432 | 186745 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | |||
152163 | 152163 | 207138 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 123 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991217.227519999 | 2091775.34767 | 37.7231118130309 | -122.472495529957 | (37.7231118130309, -122.472495529957) | |||
154023 | 154023 | 207128 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 5991324.62806 | 2095649.6189400002 | 37.7337558092758 | -122.472406573513 | (37.7337558092758, -122.472406573513) | |||
156319 | 156319 | 186749 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984860.385 | 2106678.2761 | 37.7636612284897 | -122.495568210877 | (37.7636612284897, -122.495568210877) | |||
158536 | 158536 | 207119 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5991353.65823 | 2095688.25461 | 37.733863573243205 | -122.47230902406099 | (37.7338635732432, -122.472309024061) | |||
160044 | 160044 | 186041 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1900 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984992.0482 | 2102149.6578 | 37.7512346080754 | -122.494778929254 | (37.7512346080754, -122.494778929254) | |||
164114 | 164114 | 184169 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3734 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982587.082 | 2104253.9424 | 37.7568713157118 | -122.503251214898 | (37.7568713157118, -122.503251214898) | |||
164300 | 164300 | 186000 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1883 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5981612.0444 | 2102288.7145 | 37.7514179925848 | -122.506477461595 | (37.7514179925848, -122.506477461595) | |||
164558 | 164558 | 138264 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2600 GEARY BLVD | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.44699593627199 | (37.7823276740968, -122.446995936272) | |||
167635 | 167635 | 207136 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 100 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991240.31686 | 2092039.5475299999 | 37.723838576763896 | -122.47243496690399 | (37.7238385767639, -122.472434966904) | |||
169951 | 169951 | 183438 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2506 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5988326.6233 | 2098215.7152 | 37.7406276663345 | -122.48295944841401 | (37.7406276663345, -122.482959448414) | |||
170757 | 170757 | 184168 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3732 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5982616.4158 | 2104253.9424 | 37.756873039994204 | -122.503149769389 | (37.7568730399942, -122.503149769389) | |||
171541 | 171541 | 186059 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1901 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984803.9529 | 2102180.8195 | 37.751309157700604 | -122.495431671777 | (37.7513091577006, -122.495431671777) | |||
174722 | 174722 | 207118 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 0ft | 5991361.11034 | 2095702.06647 | 37.7339019284143 | -122.472284266614 | (37.7339019284143, -122.472284266614) | |||
178438 | 178438 | 207120 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991349.86178 | 2095682.72956 | 37.7338481831293 | -122.472321746778 | (37.7338481831293, -122.472321746778) | |||
178737 | 178737 | 186058 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1901 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984794.5256 | 2102183.7824 | 37.7513167410032 | -122.495464490464 | (37.7513167410032, -122.495464490464) | |||
179845 | 179845 | 207123 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 5991338.6165 | 2095665.48618 | 37.733800186326604 | -122.472359368113 | (37.7338001863266, -122.472359368113) | |||
180846 | 180846 | 207121 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 0ft | 5991346.9817 | 2095677.27593 | 37.733833042151105 | -122.47233130655898 | (37.7338330421511, -122.472331306559) | |||
182655 | 182655 | 186512 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | |||
182990 | 182990 | 182942 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2671 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982115.1 | 2096931.8144 | 37.736739035882394 | -122.504341059874 | (37.7367390358824, -122.504341059874) | |||
184000 | 184000 | 186754 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984863.7808 | 2106693.8 | 37.763704051609004 | -122.49555761110202 | (37.763704051609, -122.495557611102) | |||
184814 | 184814 | 207122 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 5991343.33969 | 2095670.4637 | 37.7338141267018 | -122.47234340152399 | (37.7338141267018, -122.472343401524) | |||
185196 | 185196 | 207133 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 700 Junipero Serra Blvd | 90 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991231.48328 | 2092142.9158700001 | 37.724121889294295 | -122.472473035196 | (37.7241218892943, -122.472473035196) | |||
186526 | 186526 | 183209 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4212 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5982952.5112 | 2098143.3306 | 37.740114745803204 | -122.501535410067 | (37.7401147458032, -122.501535410067) | |||
188736 | 188736 | 207124 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 5991335.55729 | 2095661.67857 | 37.7337895545331 | -122.472369667134 | (37.7337895545331, -122.472369667134) | |||
189013 | 189013 | 183208 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4208 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5982977.5431 | 2098144.6836 | 37.74011993093129 | -122.501448961428 | (37.7401199309313, -122.501448961428) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");