Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79364 | 79364 | 20662 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1501X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
78581 | 78581 | 20664 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1501X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
17928 | 17928 | 22547 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6001443.018180001 | 2098660.99719 | 37.7426047928778 | -122.437639954147 | (37.7426047928778, -122.437639954147) | |||
19157 | 19157 | 22548 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 19 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 6001457.66842 | 2098646.06303 | 37.7425646201593 | -122.437588228722 | (37.7425646201593, -122.437588228722) | |||
20254 | 20254 | 23999 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 300 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 5992235.8832 | 2097133.9008 | 37.7378839736291 | -122.469364124733 | (37.7378839736291, -122.469364124733) | |||
13219 | 13219 | 24279 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350X Winding Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000809.6312 | 2086798.35513 | 37.709996659695 | -122.43898005820299 | (37.709996659695, -122.438980058203) | |||
13014 | 13014 | 24510 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5981246.2202 | 2105482.1578 | 37.7601647328681 | -122.507979481979 | (37.7601647328681, -122.507979481979) | |||
12649 | 12649 | 24533 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1395 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5981505.7764 | 2105644.9273 | 37.7606269413357 | -122.507093890918 | (37.7606269413357, -122.507093890918) | |||
87683 | 87683 | 24704 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 7040 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5985122.8914 | 2112550.40448 | 37.7797997921083 | -122.49509333148701 | (37.7797997921083, -122.495093331487) | |||
139086 | 139086 | 24723 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 7328 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5 | 5984257.95448 | 2112521.20375 | 37.779668941128605 | -122.49808332519899 | (37.7796689411286, -122.498083325199) | |||
81459 | 81459 | 25185 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3638 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 3X3 | 6000425.6878797 | 2103367.625274 | 37.7554701662116 | -122.441495243201 | (37.7554701662116, -122.441495243201) | |||
23165 | 23165 | 25259 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5994884.3509 | 2092299.7091 | 37.724763157858796 | -122.45985706395399 | (37.7247631578588, -122.459857063954) | |||
138760 | 138760 | 25260 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5995011.81264 | 2092264.9607400002 | 37.7246750767236 | -122.45941393184799 | (37.7246750767236, -122.459413931848) | |||
91329 | 91329 | 25556 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | |||
144391 | 144391 | 25557 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2000 12:00:00 AM | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | ||
117689 | 117689 | 25566 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | |||
94657 | 94657 | 25957 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2695X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2004 12:00:00 AM | 3 | 2x3 | 6011407.61362 | 2098218.7686799997 | 37.741952058974796 | -122.40315399409201 | (37.7419520589748, -122.403153994092) | ||
93616 | 93616 | 25960 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2301X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2x3 | 6011400.367219999 | 2098224.16578 | 37.741966473568795 | -122.40317942951 | (37.7419664735688, -122.40317942951) | ||
14583 | 14583 | 25961 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 2x3 | 6011423.37679 | 2098134.57194 | 37.7417217530491 | -122.403093568809 | (37.7417217530491, -122.403093568809) | ||
15432 | 15432 | 25962 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2X3 | 6011447.1772300005 | 2098118.06457 | 37.7416777564365 | -122.40301011353901 | (37.7416777564365, -122.403010113539) | ||
23093 | 23093 | 26475 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 106 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001338.90016 | 2098832.9571 | 37.7430710337942 | -122.438012277952 | (37.7430710337942, -122.438012277952) | |||
17849 | 17849 | 26939 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005048.52765 | 2102486.42553 | 37.7533128811044 | -122.42544532345501 | (37.7533128811044, -122.425445323455) | |||
17169 | 17169 | 29607 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.48666 | 2091034.59302 | 37.7210755258009 | -122.472582381082 | (37.7210755258009, -122.472582381082) | ||
20519 | 20519 | 29614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.98096 | 2090921.81223 | 37.720765307364395 | -122.47260702069599 | (37.7207653073644, -122.472607020696) | ||
18962 | 18962 | 29617 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991168.23882 | 2090896.94142 | 37.7206970910675 | -122.472600860348 | (37.7206970910675, -122.472600860348) | ||
98286 | 98286 | 30056 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 410X Brotherhood Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
84871 | 84871 | 31201 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 257 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1969 12:00:00 AM | Permit Number 34892 | 5995623.87772067 | 2091687.20373025 | 37.723123866844894 | -122.457256336737 | (37.7231238668449, -122.457256336737) | |||
77652 | 77652 | 31202 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 276 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1969 12:00:00 AM | Permit Number 34894 | 5995678.83964111 | 2091843.96330625 | 37.7235574477937 | -122.45707767911101 | (37.7235574477937, -122.457077679111) | |||
87239 | 87239 | 31218 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2302 Steiner St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34907 | 6002345.06195587 | 2116106.2366551002 | 37.79055639288929 | -122.43576883650199 | (37.7905563928893, -122.435768836502) | ||||
36508 | 36508 | 31629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2667 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35146 | 5981804.4287 | 2096935.1986 | 37.736730050914296 | -122.505415418144 | (37.7367300509143, -122.505415418144) | |
142341 | 142341 | 32011 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35406 | 5994862.5482333 | 2097095.53050341 | 37.7379300603176 | -122.460279744028 | (37.7379300603176, -122.460279744028) | ||||
91684 | 91684 | 32012 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Casitas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35406 | 5994862.5482333 | 2097095.53050341 | 37.7379300603176 | -122.460279744028 | (37.7379300603176, -122.460279744028) | ||||
143090 | 143090 | 32410 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | |||
139715 | 139715 | 32413 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/06/2002 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | ||
109409 | 109409 | 32427 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1901 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36954 | 6003387.68416895 | 2115217.90617727 | 37.7881764318356 | -122.432097963893 | (37.7881764318356, -122.432097963893) | |||
109051 | 109051 | 33491 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 29 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49655 | 6006996.29665496 | 2099574.0262700003 | 37.7454259501675 | -122.418503020578 | (37.7454259501675, -122.418503020578) | |||
128916 | 128916 | 33827 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 405 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37843 | 5999402.87583246 | 2094395.39820181 | 37.730776257944 | -122.44438766473101 | (37.730776257944, -122.444387664731) | |||
144574 | 144574 | 33894 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4152 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1997 12:00:00 AM | Permit Number 37868 | 6002903.75621342 | 2100679.60251963 | 37.74823035826571 | -122.43273331953199 | (37.7482303582657, -122.432733319532) | |||
92242 | 92242 | 33912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 665 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 37882 | 6002076.88418057 | 2102621.6953038997 | 37.753515953271496 | -122.435731542402 | (37.7535159532715, -122.435731542402) | ||
103706 | 103706 | 34223 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4353 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | Permit Number 38036 | 6001597.05586573 | 2101140.27274833 | 37.7494210542971 | -122.43728482259199 | (37.7494210542971, -122.437284822592) | |||
74676 | 74676 | 34232 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 378 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | 6 | Permit Number 48201 | 5986869.968169999 | 2113396.40571 | 37.7822247950158 | -122.48911172009899 | (37.7822247950158, -122.489111720099) | ||
103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
100877 | 100877 | 34518 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
129072 | 129072 | 34519 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
174161 | 174161 | 34851 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2036 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Permit Number 38474 | 5987708.54863135 | 2103068.55697664 | 37.7539162921572 | -122.485452515625 | (37.7539162921572, -122.485452515625) | |||
160379 | 160379 | 35170 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 414 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 17 | Permit Number 38703 | 5984711.39216 | 2113056.75346 | 37.7811659806757 | -122.496554242469 | (37.7811659806757, -122.496554242469) | ||
31069 | 31069 | 35171 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 400 40th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 13 | Permit Number 38706 | 5983467.302999999 | 2113078.2669599997 | 37.7811520854856 | -122.500859695146 | (37.7811520854856, -122.500859695146) | ||
30347 | 30347 | 35172 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 400 40th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 12 | Permit Number 38706 | 5983466.53844 | 2113086.7632299997 | 37.7811753688678 | -122.50086296861099 | (37.7811753688678, -122.500862968611) | ||
75879 | 75879 | 35907 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2295 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 14 | Permit Number 39091 | 6011293.56173 | 2098002.1271 | 37.7413508375758 | -122.403533112479 | (37.7413508375758, -122.403533112479) | |
76036 | 76036 | 37096 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1467 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 7 | Permit Number 39696 | 5981524.9714 | 2105106.2752 | 37.759149087294794 | -122.506987547698 | (37.7591490872948, -122.506987547698) | |
78222 | 78222 | 38067 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1654X SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8x5 | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |
95978 | 95978 | 38435 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40462 | 6003103.32448359 | 2102701.71275072 | 37.7537939125694 | -122.43218760661101 | (37.7537939125694, -122.432187606611) | |||
92083 | 92083 | 38475 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 162 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40476 | 5999822.84916102 | 2087316.82231241 | 37.7113640595721 | -122.44242775396002 | (37.7113640595721, -122.44242775396) | ||
104528 | 104528 | 39968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 20 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41229 | 5994642.74946915 | 2095844.31987513 | 37.7344818986137 | -122.460949031683 | (37.7344818986137, -122.460949031683) | |||
126881 | 126881 | 40087 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 708 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41310 | 6002385.65008555 | 2104050.52983918 | 37.7574567244894 | -122.434765933114 | (37.7574567244894, -122.434765933114) | |||
78233 | 78233 | 40342 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 170 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41473 | 5993510.486220299 | 2094049.6713278 | 37.7294890191855 | -122.464733328734 | (37.7294890191855, -122.464733328734) | |||
113184 | 113184 | 40561 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 25 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1999 12:00:00 AM | Permit Number 41605 | 6002662.09875993 | 2105750.86481793 | 37.7621411257649 | -122.43393140036699 | (37.7621411257649, -122.433931400367) | |||
127812 | 127812 | 40861 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41784 | 5994083.13181366 | 2093531.57356405 | 37.728099447432896 | -122.462716082104 | (37.7280994474329, -122.462716082104) | |||
75161 | 75161 | 41044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1444 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41825 | 6007214.22869275 | 2117785.20726397 | 37.795441807697294 | -122.41904090928001 | (37.7954418076973, -122.41904090928) | ||
125247 | 125247 | 41048 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 LINCOLN WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 41828 | 5993076.0 | 2107259.0 | 37.7657334037891 | -122.46719542706002 | (37.7657334037891, -122.46719542706) | |
109527 | 109527 | 41271 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 229 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41954 | 5994679.37055115 | 2091871.07942789 | 37.723574453453494 | -122.460534605902 | (37.7235744534535, -122.460534605902) | |||
96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
177905 | 177905 | 43789 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 121 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 10 | Permit Number 43419 | 5988953.60454 | 2114542.0898700003 | 37.7854919174236 | -122.481987309149 | (37.7854919174236, -122.481987309149) | |
160490 | 160490 | 43880 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1828 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 9 | Permit Number 43493 | 6001514.0134 | 2112541.0633 | 37.7807200997255 | -122.43838867760799 | (37.7807200997255, -122.438388677608) | ||
119890 | 119890 | 43991 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | Permit Number 43551 | 6009974.46243584 | 2107504.86062599 | 37.767369454596 | -122.408764367283 | (37.767369454596, -122.408764367283) | |||
53078 | 53078 | 43995 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 6 | Permit Number 43551 | 6009986.76566 | 2107516.11876 | 37.767401055952604 | -122.408722606278 | (37.7674010559526, -122.408722606278) | ||
104451 | 104451 | 44044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 15 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2000 12:00:00 AM | 3x3 | Permit Number 52166 | 6007300.39530105 | 2099500.4637239 | 37.7452410789231 | -122.417446281159 | (37.7452410789231, -122.417446281159) | ||
70080 | 70080 | 44059 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 257 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43586 | 6006396.21431 | 2086366.5390599999 | 37.7091272643882 | -122.419641098064 | (37.7091272643882, -122.419641098064) | |
51833 | 51833 | 44251 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1735 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Permit Number 43686 | 6000810.1983 | 2111352.5828 | 37.7774167767615 | -122.440738231786 | (37.7774167767615, -122.440738231786) | |||
90890 | 90890 | 44755 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | |||
140399 | 140399 | 44756 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | ||
77956 | 77956 | 45719 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 227 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | Permit Number 44389 | 5993425.80357844 | 2089157.89359185 | 37.7160525030782 | -122.464671006022 | (37.7160525030782, -122.464671006022) | |||
148976 | 148976 | 47819 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2 Seymour St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | 11 | Permit Number 45583 | 6001696.6687 | 2111985.4923 | 37.7792050300035 | -122.43771698483499 | (37.7792050300035, -122.437716984835) | ||
91357 | 91357 | 49091 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
113123 | 113123 | 49092 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
116320 | 116320 | 49878 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 511@ PAGE Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2003 12:00:00 AM | Permit Number 46644 | 5998896.54514998 | 2108984.87658964 | 37.77080649578671 | -122.44718771644301 | (37.7708064957867, -122.447187716443) | |||
157863 | 157863 | 50783 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 770 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2004 12:00:00 AM | 14 | Permit Number 47309 | 5980766.08534 | 2110461.55309 | 37.7738083996933 | -122.51000993912201 | (37.7738083996933, -122.510009939122) | ||
143850 | 143850 | 50968 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2004 12:00:00 AM | 3x3 | Permit Number 778895 | 6002458.87676393 | 2102943.00430693 | 37.7544198816731 | -122.43443350231001 | (37.7544198816731, -122.43443350231) | ||
67490 | 67490 | 51036 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2614 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47511 | 5981836.5788 | 2097266.1752 | 37.7376407136614 | -122.50532878706001 | (37.7376407136614, -122.50532878706) | ||
158901 | 158901 | 51084 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1358 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 5 | Permit Number 47542 | 5981543.7588 | 2105841.1993 | 37.7611680849155 | -122.50697708881701 | (37.7611680849155, -122.506977088817) | ||
113608 | 113608 | 51648 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1430 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47932 | 5999618.72813404 | 2107626.34389142 | 37.7671175447299 | -122.444592021369 | (37.7671175447299, -122.444592021369) | |||
110464 | 110464 | 51814 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 266 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48060 | 5994901.32061156 | 2096492.00794019 | 37.736275166275796 | -122.460101979176 | (37.7362751662758, -122.460101979176) | |||
108792 | 108792 | 52088 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 533 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48285 | 6003018.90245389 | 2105154.15611633 | 37.7605229492534 | -122.432654727925 | (37.7605229492534, -122.432654727925) | ||||
129331 | 129331 | 52144 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2695 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48326 | 5983357.46927228 | 2096816.23912163 | 37.7364946892524 | -122.500037175829 | (37.7364946892524, -122.500037175829) | ||||
110927 | 110927 | 52190 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 71 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48381 | 5999969.39262726 | 2104422.33072392 | 37.758340122613795 | -122.44314899255 | (37.7583401226138, -122.44314899255) | ||||
174982 | 174982 | 52214 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2001 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2005 12:00:00 AM | 17 | Permit Number 48397 | 6003318.2213 | 2118578.20562 | 37.797399014802 | -122.432578411388 | (37.797399014802, -122.432578411388) | ||
159091 | 159091 | 52591 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2006 12:00:00 AM | 24 | Permit Number 48684 | 6005626.503190001 | 2117904.3459900003 | 37.7956793968408 | -122.424543191035 | (37.7956793968408, -122.424543191035) | ||
142181 | 142181 | 52735 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
90341 | 90341 | 52736 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
114027 | 114027 | 52737 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
108150 | 108150 | 52738 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
35388 | 35388 | 53227 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1419 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1969 12:00:00 AM | 13 | 3x3 | Permit Number 6110 | 6007265.78904 | 2117749.89162 | 37.795347743065 | -122.41885999550301 | (37.795347743065, -122.418859995503) | |
8885 | 8885 | 53229 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 6112 | 6007249.74611 | 2117746.2070299997 | 37.795336722764795 | -122.41891524533999 | (37.7953367227648, -122.41891524534) | |
133273 | 133273 | 53674 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1970 12:00:00 AM | 27 | 3x3 | Permit Number 6615 | 6000847.30796 | 2116375.23213 | 37.7912097941415 | -122.44097026868401 | (37.7912097941415, -122.440970268684) | |
124556 | 124556 | 53759 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 492x Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/1972 12:00:00 AM | Permit Number 9439 845-849 Diamond St | 6001965.94583867 | 2101505.01209507 | 37.750443505469605 | -122.43603528995001 | (37.7504435054696, -122.43603528995) | |||
136240 | 136240 | 53866 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1746 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1972 12:00:00 AM | 13 | Permit Number 9576 | 5983496.0301 | 2103256.2411 | 37.754185295753295 | -122.50003403412201 | (37.7541852957533, -122.500034034122) | ||
129286 | 129286 | 53959 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1661 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | Permit Number 9674 | 6004995.7689664 | 2119500.86037361 | 37.800027377944495 | -122.42683940106701 | (37.8000273779445, -122.426839401067) | |||
148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
116224 | 116224 | 53992 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | Permit Number 9709 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||
1423 | 1423 | 54061 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 12 | Permit Number 779745 | 5988745.7457 | 2113084.32895 | 37.7814772265446 | -122.482599571173 | (37.7814772265446, -122.482599571173) |
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");