trees

400 rows where qSpecies_id = 43 sorted by Police Districts

✎ 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)
182131 40049 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1435 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41286 6015948.92421606 2093724.14562026 37.7298633009427 -122.38713803352 (37.7298633009427, -122.38713803352) 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
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
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
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
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
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
3588 37560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4645 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 39999 6000466.36495931 2104620.54811441 37.758912703603 -122.44144447135 (37.758912703603, -122.44144447135) 2 4 5 28862 38
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
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
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
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
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
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
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
37916 233997 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1027 Douglass St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6001336.17311 2100800.0445 37.7484720346532 -122.438162590655 (37.7484720346532, -122.438162590655) 2 4 5 28862 22
39432 37587 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
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
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
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
62613 37588 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
65609 37589 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
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
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
72751 37286 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 699 Castro St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2002 12:00:00 AM     Permit Number 39818 6002432.10165251 2104152.77929012 37.757740114019 -122.434612596377 (37.757740114019, -122.434612596377) 2 4 5 28862 3
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
79487 37590 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2805 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40018 6001080.41648379 2105487.69270452 37.7613286337784 -122.439382956636 (37.7613286337784, -122.439382956636) 15 4 5 28862 3
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
151337 36907 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 884 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40695 6000695.68812692 2102606.86536781 37.7533966824522 -122.440506941015 (37.7533966824522, -122.440506941015) 2 4 5 28862 22
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
7624 246397 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999315.6516 2108414.4782 37.769264264093 -122.445696997639 (37.769264264093, -122.445696997639) 15 5 11 29492 9
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
32393 246393 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1318 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999383.4853 2108424.4716 37.7692955761214 -122.445463083857 (37.7692955761214, -122.445463083857) 15 5 11 29492 9
58011 246391 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1302 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999418.9163 2108430.2253 37.7693133969257 -122.445340943975 (37.7693133969257, -122.445340943975) 15 5 11 29492 9
65565 246392 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1310 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999402.5635 2108427.4999 37.7693049801732 -122.445397311319 (37.7693049801732, -122.445397311319) 15 5 11 29492 9
68367 14603 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1265 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 3X3   5999439.61797 2108531.98026 37.7695939720606 -122.44527665521 (37.7695939720606, -122.44527665521) 15 5 11 29492 9
91821 246394 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999365.9212 2108422.0489 37.7692879212962 -122.445523662753 (37.7692879212962, -122.445523662753) 15 5 11 29492 9
106912 246396 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999332.61 2108417.5065 37.769273547251 -122.445638557414 (37.769273547251, -122.445638557414) 15 5 11 29492 9
124314 246395 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999349.2656 2108419.0206 37.7692786554823 -122.445581055639 (37.7692786554823, -122.445581055639) 15 5 11 29492 9
150043 246390 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1267 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 Width 0ft   5999435.2691 2108467.7761 37.7694174354079 -122.445287080875 (37.7694174354079, -122.445287080875) 15 5 11 29492 9
166774 141601 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1882 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998863.8341 2110436.3604 37.77479003056 -122.447405354515 (37.77479003056, -122.447405354515) 15 5 11 29492 16
180644 248448 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 136 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998284.3672 2107976.1331 37.768001745714 -122.449232557107 (37.768001745714, -122.449232557107) 15 5 11 29492 9
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
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
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
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
41684 68560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32450 5981950.36786377 2112213.67297772 37.7786889858471 -122.506043321809 (37.7786889858471, -122.506043321809) 11 6 2 55 26
47019 39910 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
49210 114656 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6001274.7016 2113900.9823 37.78444047533 -122.439314075739 (37.78444047533, -122.439314075739) 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
49579 114652 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6001448.056 2113923.3749 37.7845118231904 -122.438715935573 (37.7845118231904, -122.438715935573) 15 6 11 29490 13
61291 113491 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 366x 07TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712 2113143 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165) 11 6 2 54 11
64036 43694 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 750 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43338 5993218.66242977 2110366.15850001 37.7742730687673 -122.46692789928 (37.7742730687673, -122.46692789928) 11 6 2 54 11
64436 114654 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001378.1104 2113915.8269 37.7844871189173 -122.438957381866 (37.7844871189173, -122.438957381866) 15 6 11 29490 13
67090 90956 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4645 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2008 12:00:00 AM 3 3x3   5981155.43871 2110931.20899 37.7751208933778 -122.508698002643 (37.7751208933778, -122.508698002643) 11 6 2 55 26
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
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
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
77186 39908 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
77362 42163 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4630 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42458 5989047.18920071 2109907.45432155 37.7727719459225 -122.481324019174 (37.7727719459225, -122.481324019174) 11 6 2 55 26
79658 141253 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 45 PARKER AVE 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5996809.5439 2114265.4407 37.7851860717648 -122.454788237668 (37.7851860717648, -122.454788237668) 11 6 1 54 31
86961 39907 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 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
89820 39905 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
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

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