trees

400 rows where qSpecies_id = 43 sorted by PlantDate

✎ 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)
20022 35741 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 231 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39015 6007788.68777846 2092857.60054619 37.7270286926321 -122.415287680245 (37.7270286926321, -122.415287680245) 9 3 7 309 28
116815 35745 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1005 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/15/1998 12:00:00 AM     Permit Number 39018 6007884.66062501 2093417.72691387 37.728572072766 -122.414995531053 (37.728572072766, -122.414995531053) 9 3 7 309 5
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
100897 68054 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1881 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1993 12:00:00 AM     Permit Number 31791 5993737.20481548 2102706.11474697 37.7532705090115 -122.46457785688 (37.7532705090115, -122.46457785688) 1 8 4 56 12
3336 35927 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 22 Appleton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1998 12:00:00 AM     Permit Number 39097 6005564.10753047 2097077.73566378 37.738490969573 -122.423277889221 (37.738490969573, -122.423277889221) 2 7 7 28859 2
21691 35960 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 555 Holly Park Cir 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39118 6006291.48461818 2096239.28811556 37.7362298031477 -122.420703460764 (37.7362298031477, -122.420703460764) 2 7 7 28859 2
36633 35970 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 190 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39128 6006126.55379065 2096333.04753419 37.7364779485792 -122.421280351482 (37.7364779485792, -122.421280351482) 2 7 7 28859 2
37192 35942 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 21 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39105 6007225.31509594 2097693.4445482 37.7402751828319 -122.417577847872 (37.7402751828319, -122.417577847872) 2 7 7 28859 2
42461 35961 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 555 Holly Park Cir 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39118 6006291.48461818 2096239.28811556 37.7362298031477 -122.420703460764 (37.7362298031477, -122.420703460764) 2 7 7 28859 2
126442 35941 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 19 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39104 6007226.10455525 2097703.31078326 37.7403023177454 -122.417575817322 (37.7403023177454, -122.417575817322) 2 7 7 28859 2
28860 36076 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2091 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39189 6008123.15826597 2106262.62233667 37.7638546903501 -122.415079851694 (37.7638546903501, -122.415079851694) 8 4 7 28859 19
172166 36078 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2134 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39191 6008086.14600314 2105996.63644369 37.7631222746353 -122.415189036821 (37.7631222746353, -122.415189036821) 8 4 7 28859 19
97486 36111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1290 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39208 5992413.02593495 2106678.51938145 37.7641012654702 -122.469446232974 (37.7641012654702, -122.469446232974) 11 8 11 56 12
104093 36188 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 35 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM 7   Permit Number 39256 5996804.8059 2114366.2904 37.7854627064304 -122.454811918638 (37.7854627064304, -122.454811918638) 11 6 1 54 31
140389 36187 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 35 Parker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/04/1998 12:00:00 AM 8   Permit Number 39256 5996805.8212 2114349.7078 37.7854172332631 -122.45480720749 (37.7854172332631, -122.45480720749) 11 6 1 54 31
152141 40299 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2155 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1999 12:00:00 AM     Permit Number 41445 6006883.99939755 2105792.08668164 37.7624929958367 -122.419332354319 (37.7624929958367, -122.419332354319) 8 4 7 28859 19
193933 40300 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2155 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/1999 12:00:00 AM     Permit Number 41445 6006883.99939755 2105792.08668164 37.7624929958367 -122.419332354319 (37.7624929958367, -122.419332354319) 8 4 7 28859 19
10411 47385 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1231 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2002 12:00:00 AM     Permit Number 45301 6001377.58877778 2100188.59270033 37.7467954887327 -122.437975585037 (37.7467954887327, -122.437975585037) 2 4 5 63 22
22083 36334 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 44 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1998 12:00:00 AM     Permit Number 39301 5995656.19844855 2092807.02452797 37.7262004833581 -122.457225579924 (37.7262004833581, -122.457225579924) 9 7 4 28861 40
189493 36335 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 44 Eastwood Dr 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1998 12:00:00 AM     Permit Number 39301 5995656.19844855 2092807.02452797 37.7262004833581 -122.457225579924 (37.7262004833581, -122.457225579924) 9 7 4 28861 40
22221 36454 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1315 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39355 5995842.07912733 2092771.30842103 37.7261130893774 -122.45658042282 (37.7261130893774, -122.45658042282) 9 7 4 28861 40
25563 36489 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 5 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
35658 36470 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 101 San Ramon Way 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39368 5995817.82622595 2092643.889646 37.7257618354228 -122.456655052435 (37.7257618354228, -122.456655052435) 9 7 4 28861 40
47043 36453 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1315 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39355 5995842.07912733 2092771.30842103 37.7261130893774 -122.45658042282 (37.7261130893774, -122.45658042282) 9 7 4 28861 40
47534 34111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1398 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39363 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
67437 36510 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 406 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39387 6007487.22983868 2096928.20854387 37.7381887481689 -122.416618053798 (37.7381887481689, -122.416618053798) 2 7 7 28859 2
97659 36491 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 6 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
106874 34110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1398 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39363 5995892.17100072 2093289.41859175 37.7275385716585 -122.456444707829 (37.7275385716585, -122.456444707829) 9 7 4 28861 40
119125 36493 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
140321 36492 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
144944 36488 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
172042 36471 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 101 San Ramon Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39368 5995817.82622595 2092643.889646 37.7257618354228 -122.456655052435 (37.7257618354228, -122.456655052435) 9 7 4 28861 40
173715 36487 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 95 Westwood Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
142691 36568 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 327 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/19/1998 12:00:00 AM     Permit Number 39430 6006720.99763739 2096073.95090972 37.7358000222337 -122.419206729617 (37.7358000222337, -122.419206729617) 2 7 7 28859 2
32857 47691 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2858 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45490 6001036.99468682 2116264.16139907 37.7909156246348 -122.440305990836 (37.7909156246348, -122.440305990836) 13 6 1 29490 27
30259 36821 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
71570 36820 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
90544 36823 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
114130 36832 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2655 Ingalls St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39536 6015108.90537025 2091047.28537032 37.7224666226612 -122.389855194073 (37.7224666226612, -122.389855194073) 10 3 8 58 1
124971 36826 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
129068 36828 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2600 Ingalls St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39535 6015154.00494247 2091194.79088837 37.7228741446414 -122.38970959128 (37.7228741446414, -122.38970959128) 10 3 8 58 1
135659 36831 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2655 Ingalls St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39536 6015108.90537025 2091047.28537032 37.7224666226612 -122.389855194073 (37.7224666226612, -122.389855194073) 10 3 8 58 1
145081 36827 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2600 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39535 6015154.00494247 2091194.79088837 37.7228741446414 -122.38970959128 (37.7228741446414, -122.38970959128) 10 3 8 58 1
147777 36830 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2655 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39536 6015108.90537025 2091047.28537032 37.7224666226612 -122.389855194073 (37.7224666226612, -122.389855194073) 10 3 8 58 1
148296 36829 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2600 Ingalls St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39535 6015154.00494247 2091194.79088837 37.7228741446414 -122.38970959128 (37.7228741446414, -122.38970959128) 10 3 8 58 1
153929 36822 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
187434 36819 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Fitzgerald Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39534 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
80984 36908 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 394 Diamond St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/27/1998 12:00:00 AM     Permit Number 39556 6001774.84404362 2103557.93464621 37.7560694803843 -122.436843078117 (37.7560694803843, -122.436843078117) 2 4 5 28862 3
18989 37041 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
29030 37044 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
31546 37131 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4234 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 6   Permit Number 39713 5981666.4542 2104905.7911 37.7586069464275 -122.506483373023 (37.7586069464275, -122.506483373023) 1 8 3 56 35
32817 37130 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4234 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 4   Permit Number 39713 5981688.5295 2104905.7911 37.758608246146 -122.506407027964 (37.758608246146, -122.506407027964) 1 8 3 56 35
44466 37043 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
49100 37124 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
67140 37133 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1496 La Playa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39716 5980947.80639526 2104858.25790377 37.758434095357 -122.508965208548 (37.758434095357, -122.508965208548) 1 8 3 56 35
86192 37106 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1495 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39704 5981217.84304819 2104908.99665532 37.7585893245545 -122.508035083937 (37.7585893245545, -122.508035083937) 1 8 3 56 35
99205 37134 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1496 La Playa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39716 5980947.80639526 2104858.25790377 37.758434095357 -122.508965208548 (37.758434095357, -122.508965208548) 1 8 3 56 35
126430 37123 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
127677 37042 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
142418 37039 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
146257 37125 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4200 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 0   Permit Number 39711 5981854.3307572 2104909.94156092 37.7586294023629 -122.505833929701 (37.7586294023629, -122.505833929701) 1 8 3 56 35
159010 37040 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1660 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/01/1998 12:00:00 AM     Permit Number 39650 6004584.07651504 2099217.83848958 37.7443118455047 -122.426818732995 (37.7443118455047, -122.426818732995) 2 7 5 63 22
168308 37063 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1468 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39664 6003912.84552522 2099719.17052238 37.7456504127787 -122.429175446828 (37.7456504127787, -122.429175446828) 2 7 5 63 22
171637 37105 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1495 48th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM     Permit Number 39704 5981217.84304819 2104908.99665532 37.7585893245545 -122.508035083937 (37.7585893245545, -122.508035083937) 1 8 3 56 35
175884 37069 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1474 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/01/1998 12:00:00 AM 4   Permit Number 39671 5983120.2149 2105112.095 37.7592588855971 -122.501470953069 (37.7592588855971, -122.501470953069) 1 8 3 56 35
34181 68180 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 75 Rossi Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM     Permit Number 31952 5996329.36645327 2111693.70801186 37.7780972208044 -122.456263479509 (37.7780972208044, -122.456263479509) 11 6 2 54 16
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
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
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
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
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
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
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
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
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
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
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
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
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
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
20587 40463 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 378 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/1999 12:00:00 AM     Permit Number 41548 6007684.60346868 2097335.44684482 37.7393180333935 -122.415964462581 (37.7393180333935, -122.415964462581) 2 7 7 28859 2
46004 37213 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1443 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 6   Permit Number 39778 5985860.9109 2105407.8744 37.7602315957486 -122.492014212427 (37.7602315957486, -122.492014212427) 1 8 3 56 35
46689 37212 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1443 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM 5   Permit Number 39778 5985860.9109 2105390.2338 37.760183159546 -122.492012913605 (37.760183159546, -122.492012913605) 1 8 3 56 35
69553 37195 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1742 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM     Permit Number 39762 5986908.61171996 2103401.39400305 37.7547835348007 -122.488243305818 (37.7547835348007, -122.488243305818) 1 8 3 56 35
100442 37225 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1471 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/1998 12:00:00 AM     Permit Number 39789 5985552.67131947 2105212.4791892 37.759677072307 -122.493065858593 (37.759677072307, -122.493065858593) 1 8 3 56 35
19915 37424 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
36835 37313 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 485 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39829 6003203.23907746 2103274.86360864 37.7553733132886 -122.431883001431 (37.7553733132886, -122.431883001431) 2 4 5 28862 22
110816 37426 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
125708 37427 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
126600 37423 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39902 6003190.5059195 2101131.09771587 37.7494863167503 -122.431773980118 (37.7494863167503, -122.431773980118) 2 4 5 28862 22
131612 37420 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 679 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39898 6002152.44125634 2099703.71933952 37.7455081743626 -122.435261547297 (37.7455081743626, -122.435261547297) 2 7 5 63 22
154775 37314 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 485 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39829 6003203.23907746 2103274.86360864 37.7553733132886 -122.431883001431 (37.7553733132886, -122.431883001431) 2 4 5 28862 22
173663 37275 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3894 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/15/1998 12:00:00 AM     Permit Number 39816 6002513.25180394 2102998.13185029 37.754574335137 -122.434249400487 (37.754574335137, -122.434249400487) 2 4 5 28862 22
111332 32293 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 160 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1999 12:00:00 AM     Permit Number 41561 5996702.09015079 2089306.207139 37.7166480756618 -122.453357371649 (37.7166480756618, -122.453357371649) 9 8 6 28861 24
131078 31826 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
139708 31829 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 222 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35288 6009542.64532801 2109092.58934898 37.7717047944846 -122.410370088519 (37.7717047944846, -122.410370088519) 8 2 9 28853 34
156451 31830 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 222 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35288 6009542.64532801 2109092.58934898 37.7717047944846 -122.410370088519 (37.7717047944846, -122.410370088519) 8 2 9 28853 34
172252 31827 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
100434 37455 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Gates St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39928 6008336.46582591 2098008.78903327 37.7412035106459 -122.413758220259 (37.7412035106459, -122.413758220259) 2 7 7 28859 2
105045 37437 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 51 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39912 6010454.2114909 2099614.59600709 37.745731407921 -122.406548905427 (37.745731407921, -122.406548905427) 2 7 7 28859 2

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