trees

400 rows where qSpecies_id = 43 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID ▼ qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
184586 37749 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1271 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/17/1999 12:00:00 AM     Permit Number 40096 6009537.93489258 2101780.18844977 37.7516263413346 -122.409870111191 (37.7516263413346, -122.409870111191) 2 4 7 28859 19
44351 37782 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 289 Hamilton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM     Permit Number 40117 6009320.94225991 2092982.60267054 37.7274579192917 -122.409999500097 (37.7274579192917, -122.409999500097) 10 3 7 309 28
187515 37783 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 289 Hamilton St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM     Permit Number 40117 6009320.94225991 2092982.60267054 37.7274579192917 -122.409999500097 (37.7274579192917, -122.409999500097) 10 3 7 309 28
185863 37786 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 301 Hamilton St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/06/1998 12:00:00 AM     Permit Number 40119 6009341.93324933 2092913.86947002 37.7272703689284 -122.409922083912 (37.7272703689284, -122.409922083912) 10 3 7 309 28
169743 37845 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 132 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2005 12:00:00 AM     Permit Number 40137 6010294.81147281 2099208.35616527 37.7446070428057 -122.40707146066 (37.7446070428057, -122.40707146066) 2 7 7 28859 2
137049 37869 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/2002 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
96443 37870 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
136572 37871 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 135 Colon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM     Permit Number 40155 5996120.55604725 2093902.0241844 37.7292337486651 -122.455699446357 (37.7292337486651, -122.455699446357) 9 7 4 28861 40
179725 38035 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 111 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40238 5993036.05890767 2098279.23820641 37.7410749908436 -122.466680779864 (37.7410749908436, -122.466680779864) 1 8 4 59 40
72873 38036 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 111 Wawona St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40238 5993036.05890767 2098279.23820641 37.7410749908436 -122.466680779864 (37.7410749908436, -122.466680779864) 1 8 4 59 40
143533 38037 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40239 5992979.27513605 2098217.94646306 37.7409034220219 -122.466872661258 (37.7409034220219, -122.466872661258) 1 8 4 59 40
88322 38072 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000643.06501 2113866.93101 37.7843110146233 -122.441496870623 (37.7843110146233, -122.441496870623) 15 6 11 29490 13
149752 38073 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000616.76201 2114062.24301 37.7848457925173 -122.441601890436 (37.7848457925173, -122.441601890436) 15 6 11 29490 13
181292 38074 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000621.45001 2114020.83701 37.7847323694056 -122.441582699114 (37.7847323694056, -122.441582699114) 15 6 11 29490 13
161249 38075 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000624.05401 2114007.81601 37.7846967654532 -122.441572755427 (37.7846967654532, -122.441572755427) 15 6 11 29490 13
70486 38076 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000627.17901 2113992.97301 37.7846561884399 -122.441560878475 (37.7846561884399, -122.441560878475) 15 6 11 29490 13
177223 38077 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000633.42901 2113935.94101 37.7844999493368 -122.441535161579 (37.7844999493368, -122.441535161579) 15 6 11 29490 13
109355 38078 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000636.81501 2113914.58701 37.7844415096587 -122.441521914323 (37.7844415096587, -122.441521914323) 15 6 11 29490 13
73346 38079 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000639.41901 2113899.22301 37.7843994724246 -122.441511802515 (37.7843994724246, -122.441511802515) 15 6 11 29490 13
190764 38080 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000641.24201 2113883.59801 37.7843566740562 -122.441504373964 (37.7843566740562, -122.441504373964) 15 6 11 29490 13
49379 38081 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000619.36701 2114044.53501 37.7847973193303 -122.441591606798 (37.7847973193303, -122.441591606798) 15 6 11 29490 13
31600 38082 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000645.66901 2113851.82701 37.7842696912791 -122.44148677751 (37.7842696912791, -122.44148677751) 15 6 11 29490 13
136957 38083 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
127672 38084 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000626.16659083 2114103.31583795 37.7849591037257 -122.441572302214 (37.7849591037257, -122.441572302214) 15 6 11 29490 13
33819 38088 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2501 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1999 12:00:00 AM     Permit Number 40260 6000614.67901 2114079.17001 37.7848921510189 -122.441610312074 (37.7848921510189, -122.441610312074) 15 6 11 29490 13
19177 38121 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1332 31st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM     Permit Number 40285 5986502.93855263 2106173.76895003 37.7623720383861 -122.489850100877 (37.7623720383861, -122.489850100877) 1 8 3 56 35
173565 38123 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1200 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/13/1998 12:00:00 AM 5   Permit Number 40287 5985851.366 2107007.0192 37.7646218448258 -122.492164972302 (37.7646218448258, -122.492164972302) 1 8 3 56 35
18513 38167 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 315 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40305 6010555.26362325 2092792.3936381 37.7270047480515 -122.405719032848 (37.7270047480515, -122.405719032848) 10 3 7 309 28
191442 38168 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 349 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40306 6010462.31979056 2092763.8646761 37.7269212154772 -122.40603833072 (37.7269212154772, -122.40603833072) 10 3 7 309 28
178631 38169 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 349 Bacon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40306 6010462.31979056 2092763.8646761 37.7269212154772 -122.40603833072 (37.7269212154772, -122.40603833072) 10 3 7 309 28
157106 38170 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 349 Bacon St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40306 6010462.31979056 2092763.8646761 37.7269212154772 -122.40603833072 (37.7269212154772, -122.40603833072) 10 3 7 309 28
43878 38172 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 433 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40308 6010665.04465284 2092691.20819375 37.7267330524509 -122.405332397121 (37.7267330524509, -122.405332397121) 10 3 7 309 28
136441 38176 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 5 Dwight St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40311 6011565.07182758 2091659.31063556 37.7239499540685 -122.402148496173 (37.7239499540685, -122.402148496173) 10 3 7 309 28
111237 38179 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 36 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40312 6011464.3100447 2091682.81198966 37.7240088592297 -122.402498467389 (37.7240088592297, -122.402498467389) 10 3 7 309 28
179341 38180 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 42 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40313 6011447.25206772 2091677.58315317 37.7239935496068 -122.402557066965 (37.7239935496068, -122.402557066965) 10 3 7 309 28
181109 38195 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 730 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40323 6011305.3220934 2091453.71988413 37.7233709423274 -122.403031960796 (37.7233709423274, -122.403031960796) 10 3 7 309 28
23158 38196 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 730 Girard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40323 6011305.3220934 2091453.71988413 37.7233709423274 -122.403031960796 (37.7233709423274, -122.403031960796) 10 3 7 309 28
184921 38197 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 731 Girard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40324 6011355.00492598 2091469.0696772 37.7234158640083 -122.402861294571 (37.7234158640083, -122.402861294571) 10 3 7 309 28
86025 38199 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 455 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40326 6010407.74547618 2092510.58020697 37.7262226967111 -122.406209156508 (37.7262226967111, -122.406209156508) 10 3 7 309 28
72189 38209 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 830 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40332 6010874.68113014 2090828.02861629 37.7216288654759 -122.40447659257 (37.7216288654759, -122.40447659257) 10 3 7 309 28
147396 38211 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 201 Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1998 12:00:00 AM     Permit Number 40334 6011139.75939059 2091047.44760609 37.7222461553598 -122.403575712805 (37.7222461553598, -122.403575712805) 10 3 7 309 28
34131 38301 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
112873 38302 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
5456 38303 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
58172 38315 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2000 Folsom St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
46799 38320 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1810 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1998 12:00:00 AM     Permit Number 40378 6008623.68390919 2107918.42733823 37.7684292621485 -122.413465790173 (37.7684292621485, -122.413465790173) 8 4 7 28853 19
85584 38345 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1859 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM 0   Permit Number 40412 5982231.73051381 2102455.52324126 37.7519124687384 -122.504346906094 (37.7519124687384, -122.504346906094) 1 8 3 56 35
82029 38347 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1567 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1998 12:00:00 AM     Permit Number 40414 5981854.03597748 2104432.31461127 37.757317957298 -122.5057995404 (37.757317957298, -122.5057995404) 1 8 3 56 35
9023 38354 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1875 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1998 12:00:00 AM 0   Permit Number 40422 5981305.52143941 2102319.66652747 37.7514849260003 -122.507539731955 (37.7514849260003, -122.507539731955) 1 8 3 56 35
86559 38511 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 64 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/01/1998 12:00:00 AM     Permit Number 40500 6008516.43042503 2087785.37039582 37.7131422875132 -122.412413505045 (37.7131422875132, -122.412413505045) 9 7 8 309 39
123655 38553 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1791 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40521 6014535.26572589 2096873.10267881 37.7384313099375 -122.392245401183 (37.7384313099375, -122.392245401183) 10 3 8 58 1
166378 38565 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
16009 38566 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
137180 38567 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
165786 38568 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
117190 38569 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
9053 38570 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
98576 38571 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1360 Oakdale Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40531 6016200.74571731 2094639.7722335 37.7323913709995 -122.386331262014 (37.7323913709995, -122.386331262014) 10 3 8 58 1
58227 38593 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
118676 38594 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
20690 38595 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
82292 38596 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
5387 38597 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1301 Revere Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40548 6016653.84193156 2093198.66483066 37.7284594450303 -122.384664438105 (37.7284594450303, -122.384664438105) 10 3 8 58 1
150948 38598 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1329 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40549 6016511.31684241 2093304.91013991 37.7287432904596 -122.385164559023 (37.7287432904596, -122.385164559023) 10 3 8 58 1
139109 38601 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1534 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40552 6015446.13574073 2094163.07491578 37.7310406573671 -122.388906878559 (37.7310406573671, -122.388906878559) 10 3 8 58 1
15667 38606 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1558 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 6   Permit Number 40554 6015323.31475554 2094254.15832382 37.7312839455717 -122.389337853373 (37.7312839455717, -122.389337853373) 10 3 8 58 1
89942 38612 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
21583 38613 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
26720 38614 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
8969 38615 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
183262 38616 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1602 Revere Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40557 6015083.62753499 2094431.96361447 37.7317588716397 -122.390178919908 (37.7317588716397, -122.390178919908) 10 3 8 58 1
125189 38617 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1619 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40558 6014993.23240611 2094434.43177017 37.7317606344589 -122.390491609305 (37.7317606344589, -122.390491609305) 10 3 8 58 1
146098 38618 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1648 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40559 6014913.01600852 2094558.97753063 37.7320981616183 -122.390777636678 (37.7320981616183, -122.390777636678) 10 3 8 58 1
93563 38619 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1998 12:00:00 AM     Permit Number 40560 6016538.96174012 2092935.06529127 37.7277292986583 -122.385043230392 (37.7277292986583, -122.385043230392) 10 3 8 58 1
140640 38620 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1998 12:00:00 AM     Permit Number 40560 6016538.96174012 2092935.06529127 37.7277292986583 -122.385043230392 (37.7277292986583, -122.385043230392) 10 3 8 58 1
152483 38621 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1998 12:00:00 AM     Permit Number 40560 6016538.96174012 2092935.06529127 37.7277292986583 -122.385043230392 (37.7277292986583, -122.385043230392) 10 3 8 58 1
59390 38622 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1295 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1998 12:00:00 AM     Permit Number 40560 6016538.96174012 2092935.06529127 37.7277292986583 -122.385043230392 (37.7277292986583, -122.385043230392) 10 3 8 58 1
12770 38626 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
155651 38627 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
160706 38628 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1998 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
58314 38629 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Shafter Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/10/2005 12:00:00 AM     Permit Number 40563 6016028.15247737 2093380.70622124 37.7289246716671 -122.386840188027 (37.7289246716671, -122.386840188027) 10 3 8 58 1
72918 38642 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1396 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM     Permit Number 40567 6015859.80735798 2093156.47365065 37.7282996512663 -122.38740653837 (37.7282996512663, -122.38740653837) 10 3 8 58 1
108586 38812 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 343 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1998 12:00:00 AM     Permit Number 40648 5992447.48955931 2113145.89233921 37.7818609227719 -122.469797921948 (37.7818609227719, -122.469797921948) 11 6 2 54 11
70992 38813 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 343 11th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1998 12:00:00 AM     Permit Number 40648 5992447.48955931 2113145.89233921 37.7818609227719 -122.469797921948 (37.7818609227719, -122.469797921948) 11 6 2 54 11
119260 38854 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1466 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 3   Permit Number 40681 5989630.3392 2105375.4166 37.7603620895733 -122.478975308071 (37.7603620895733, -122.478975308071) 1 8 3 56 35
65067 38860 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1549 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 0   Permit Number 40687 5989292.62615578 2104803.36922141 37.758771784472 -122.480101420695 (37.758771784472, -122.480101420695) 1 8 3 56 35
178986 38863 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1565 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 0   Permit Number 40690 5989296.21457943 2104699.06297943 37.7584855960627 -122.480081376814 (37.7584855960627, -122.480081376814) 1 8 3 56 35
139892 38864 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1442 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 4   Permit Number 40691 5989006.457 2105496.048 37.7606570618134 -122.481141834437 (37.7606570618134, -122.481141834437) 1 8 3 56 35
67646 39064 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 238 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2003 12:00:00 AM     Permit Number 40776 6007140.57976269 2105924.49860202 37.7628710155664 -122.418454324135 (37.7628710155664, -122.418454324135) 8 4 7 28859 19
100539 39065 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 238 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2003 12:00:00 AM     Permit Number 40776 6007140.57976269 2105924.49860202 37.7628710155664 -122.418454324135 (37.7628710155664, -122.418454324135) 8 4 7 28859 19
155234 39134 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 810 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/30/2000 12:00:00 AM     Permit Number 40813 6007325.69907761 2102579.12781976 37.7536958179011 -122.417576944272 (37.7536958179011, -122.417576944272) 2 4 7 28859 19
168287 39138 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1081 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40817 6007463.5839422 2101024.83737451 37.7494358467299 -122.416989987658 (37.7494358467299, -122.416989987658) 2 4 7 28859 19
165109 39139 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1081 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40817 6007463.5839422 2101024.83737451 37.7494358467299 -122.416989987658 (37.7494358467299, -122.416989987658) 2 4 7 28859 19
42365 39173 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 7461 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40835 6007491.70606937 2105311.60400293 37.7612079095392 -122.417196465004 (37.7612079095392, -122.417196465004) 2 4 7 28859 19
87797 39174 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 7461 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40835 6007491.70606937 2105311.60400293 37.7612079095392 -122.417196465004 (37.7612079095392, -122.417196465004) 2 4 7 28859 19
172670 39490 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4054 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40948 6002823.01095214 2101848.4791437 37.7514352381886 -122.433096036215 (37.7514352381886, -122.433096036215) 2 4 5 28862 22
43841 39675 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 Orizaba Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41061 5994057.0703552 2090076.01512202 37.7186098185096 -122.462555624891 (37.7186098185096, -122.462555624891) 9 8 6 28861 24
100219 39676 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 Orizaba Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM     Permit Number 41061 5994057.0703552 2090076.01512202 37.7186098185096 -122.462555624891 (37.7186098185096, -122.462555624891) 9 8 6 28861 24
101538 39689 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 56 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41074 6013706.29242939 2094956.2180602 37.7331218759444 -122.394977388495 (37.7331218759444, -122.394977388495) 10 3 8 58 1
60108 39693 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1475 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41078 6015709.80747314 2094943.53448428 37.7331982540931 -122.388049755187 (37.7331982540931, -122.388049755187) 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)
);