trees

400 rows where qSpecies_id = 43 sorted by Longitude

✎ 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)
128913 43106 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 405 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42935 6009343.77596633 2114320.93489173 37.786049444672 -122.411427426058 (37.786049444672, -122.411427426058) 5 10 9 28852 36
150403 43108 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 405 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42935 6009343.77596633 2114320.93489173 37.786049444672 -122.411427426058 (37.786049444672, -122.411427426058) 5 10 9 28852 36
176908 43107 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 405 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42935 6009343.77596633 2114320.93489173 37.786049444672 -122.411427426058 (37.786049444672, -122.411427426058) 5 10 9 28852 36
114140 43109 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/31/2004 12:00:00 AM     Permit Number 42936 6009339.17842867 2114353.98733566 37.7861399408742 -122.411445668311 (37.7861399408742, -122.411445668311) 5 10 9 28852 36
148461 43110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42936 6009339.17842867 2114353.98733566 37.7861399408742 -122.411445668311 (37.7861399408742, -122.411445668311) 5 10 9 28852 36
88126 43999 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 158 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43556 6009020.46100461 2099081.71622052 37.7441879209123 -122.411468983209 (37.7441879209123, -122.411468983209) 2 7 7 28859 2
3049 43998 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 150 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43555 6008950.71046834 2099077.83692872 37.7441733566649 -122.411709892219 (37.7441733566649, -122.411709892219) 2 7 7 28859 2
86212 43997 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 146 Ripley St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2000 12:00:00 AM     Permit Number 43554 6008915.83516029 2099075.89728061 37.7441660743482 -122.411830346827 (37.7441660743482, -122.411830346827) 2 7 7 28859 2
83598 34569 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 212 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38277 6008791.12126389 2097614.61295509 37.7401467112036 -122.41215832665 (37.7401467112036, -122.41215832665) 10 7 7 28859 2
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
30149 34482 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 840 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38209 6008945.03028541 2119415.9766962 37.8000168102383 -122.413167394928 (37.8000168102383, -122.413167394928) 3 1 10 308 32
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
46836 37543 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 704 Post St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39985 6008763.04341244 2114941.12322015 37.7877197423167 -122.413480489066 (37.7877197423167, -122.413480489066) 5 1 10 28858 21
159345 37542 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 704 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39985 6008763.04341244 2114941.12322015 37.7877197423167 -122.413480489066 (37.7877197423167, -122.413480489066) 5 1 10 28858 21
132556 43498 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4145 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2000 12:00:00 AM     Permit Number 43178 6008355.55350511 2095881.30836855 37.7353629859312 -122.413541790025 (37.7353629859312, -122.413541790025) 10 7 7 28859 2
172758 102442 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 4145 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008344 2095883 37.735366982035 -122.413581854524 (37.735366982035, -122.413581854524) 10 7 7 28859 2
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
126210 37454 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 125 Gates St 1 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
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
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
102213 99920 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1740 Jones St 7 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
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
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
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
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
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
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
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
91288 106921 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 112-118 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6007680.5 2107244.2 37.7665249882726 -122.416680417976 (37.7665249882726, -122.416680417976) 8 4 7 28853 19
98168 37716 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 943 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40086 6007607.04837726 2104169.37424002 37.7580780981898 -122.416716622543 (37.7580780981898, -122.416716622543) 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
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
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
79486 37707 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 720 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40083 6007483.64662361 2105457.13704999 37.7616070561613 -122.417234652367 (37.7616070561613, -122.417234652367) 2 4 7 28859 19
166564 37709 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 720 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40083 6007483.64662361 2105457.13704999 37.7616070561613 -122.417234652367 (37.7616070561613, -122.417234652367) 2 4 7 28859 19
168179 37708 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 720 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40083 6007483.64662361 2105457.13704999 37.7616070561613 -122.417234652367 (37.7616070561613, -122.417234652367) 2 4 7 28859 19
32928 37704 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
96433 37701 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
124119 37706 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
128039 37702 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
168833 37703 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
174203 37705 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
183814 37700 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM     Permit Number 40082 6007477.44704972 2105569.08555176 37.7619140920083 -122.417264027542 (37.7619140920083, -122.417264027542) 2 4 7 28859 19
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
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
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
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
39342 37525 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1150 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/22/1998 12:00:00 AM   3x3 Permit Number 52992 6007323.5106073 2115257.61387493 37.7885078148262 -122.418483459105 (37.7885078148262, -122.418483459105) 13 9 10 28858 21
177318 37526 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1150 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39975 6007323.5106073 2115257.61387493 37.7885078148262 -122.418483459105 (37.7885078148262, -122.418483459105) 13 9 10 28858 21
75154 23668 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 315 Virginia Ave 3 Median : Cutout Tree DPW 1     3 12   6006939.5968988 2098278.7889768 37.7418663267774 -122.418607247372 (37.7418663267774, -122.418607247372) 2 7 7 28859 2
3986 116680 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 100 Esmeralda Ave 19 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
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
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
71856 36717 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1999 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
95507 36720 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
151832 36719 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
170901 36718 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1850 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/14/2004 12:00:00 AM     Permit Number 39504 6006730.53287232 2107601.56248509 37.767452746672 -122.419991553753 (37.767452746672, -122.419991553753) 8 4 7 28853 19
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
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
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
177763 255250 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 209x Willow St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
137219 35519 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 90 Alvarado St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38920 6005793.71652674 2102887.49607432 37.7544562030797 -122.422896805421 (37.7544562030797, -122.422896805421) 2 4 5 28859 19
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
114946 35548 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 25 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38924 6005398.06539258 2103564.19233402 37.7562919206066 -122.424313197508 (37.7562919206066, -122.424313197508) 2 4 5 28859 19
148447 35550 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 50 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38925 6005353.87687584 2103421.76830911 37.7558983622011 -122.424455886685 (37.7558983622011, -122.424455886685) 2 4 5 28859 19
183856 35549 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 50 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38925 6005353.87687584 2103421.76830911 37.7558983622011 -122.424455886685 (37.7558983622011, -122.424455886685) 2 4 5 28859 19
64957 9986 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2007 12:00:00 AM 8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
161440 9987 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
180479 35494 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3763 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38905 6005241.37948762 2104264.99377415 37.758207308358 -122.424904929122 (37.758207308358, -122.424904929122) 2 4 5 28859 19
163982 35510 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3478 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38912 6005194.49677521 2103146.93967049 37.7551347452856 -122.424987522768 (37.7551347452856, -122.424987522768) 2 4 5 28859 19
14912 34353 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 11 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38109 6004890.69932117 2098315.24737801 37.7418508681298 -122.425694266568 (37.7418508681298, -122.425694266568) 2 7 5 63 7
94256 34355 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 84 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2003 12:00:00 AM     Permit Number 38111 6004874.55521399 2097707.40817778 37.7401809675376 -122.425706834494 (37.7401809675376, -122.425706834494) 2 7 5 63 7
161378 34346 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 255 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38104 6004828.12803067 2098393.70147146 37.7420627492496 -122.425916201102 (37.7420627492496, -122.425916201102) 2 7 5 63 7
13812 34364 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1862 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38120 6004563.40220029 2097868.81083057 37.7406065549579 -122.426794167737 (37.7406065549579, -122.426794167737) 2 7 5 63 7
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
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
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
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
14374 34363 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1846 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38119 6004556.0268692 2098000.12862747 37.7409667067108 -122.426829018524 (37.7409667067108, -122.426829018524) 2 7 5 63 7
26194 34414 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 205 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38161 6004190.49432582 2097526.98545022 37.7396468892769 -122.428059186764 (37.7396468892769, -122.428059186764) 2 7 5 63 7
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
45134 34388 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 100 Mateo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38136 6003730.56187145 2096520.40051304 37.7368570045518 -122.429577666227 (37.7368570045518, -122.429577666227) 2 7 5 63 7
140614 37066 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 326 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/16/2004 12:00:00 AM     Permit Number 39668 6003784.55345185 2099265.25748104 37.7443968092105 -122.429586694845 (37.7443968092105, -122.429586694845) 2 7 5 63 22
115816 67467 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4078 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1999 12:00:00 AM     Permit Number 30982 6003350.50488606 2101289.69360575 37.7499308522406 -122.431232018452 (37.7499308522406, -122.431232018452) 2 4 5 28862 22
20564 35401 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 527 30th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38856 6003213.78352736 2098311.09733417 37.7417445720019 -122.431492193982 (37.7417445720019, -122.431492193982) 2 7 5 63 7
122187 35402 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 531 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38857 6003188.18562105 2098310.25744294 37.7417408149917 -122.431580643052 (37.7417408149917, -122.431580643052) 2 7 5 63 7
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
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
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
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
98159 34672 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3112 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/2005 12:00:00 AM     Permit Number 38340 6003381.0349361 2119134.6254032 37.7989303613953 -122.432400821612 (37.7989303613953, -122.432400821612) 13 9 1 57 17
25595 247352 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 717 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003091.9924 2109593.0641 37.7727152549133 -122.432719040926 (37.7727152549133, -122.432719040926) 15 5 11 29492 9

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