trees
400 rows where qSpecies_id = 43 sorted by SiteOrder descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
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 | ||
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 | ||
190993 | 42556 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
68850 | 187339 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985079.354 | 2099690.9452 | 37.7444887635366 | -122.494295807794 | (37.7444887635366, -122.494295807794) | 1 | 8 | 3 | 29491 | 35 | |||
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
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 | ||
13527 | 34657 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38334 | 5988005.8211 | 2105120.9797 | 37.7595690044056 | -122.48457502698 | (37.7595690044056, -122.48457502698) | 1 | 8 | 3 | 56 | 35 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
28494 | 42555 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 519 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42646 | 5993007.97320082 | 2094936.14188553 | 37.7318940637686 | -122.466534957812 | (37.7318940637686, -122.466534957812) | 9 | 8 | 4 | 59 | 40 | ||
29470 | 45414 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 845 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2001 12:00:00 AM | Permit Number 44215 | 5993893.70509068 | 2091558.26488077 | 37.7226703098261 | -122.463227804134 | (37.7226703098261, -122.463227804134) | 9 | 8 | 4 | 59 | 40 | ||
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 | |
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 | ||
36106 | 182248 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1454 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985596.8527 | 2105324.6327 | 37.7599875985541 | -122.492921320569 | (37.7599875985541, -122.492921320569) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
36936 | 31125 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 15 Foerster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34842 | 5998070.62548996 | 2093588.33279569 | 37.7284841438842 | -122.448935330498 | (37.7284841438842, -122.448935330498) | 9 | 7 | 4 | 28861 | 40 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | |
59456 | 44816 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2745 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986280.5132 | 2105006.9468 | 37.7591552772781 | -122.490533528729 | (37.7591552772781, -122.490533528729) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
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 | ||
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 | ||
72685 | 40051 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1439 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41287 | 6015928.43712332 | 2093739.41771764 | 37.729904100557 | -122.387209925263 | (37.729904100557, -122.387209925263) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
106945 | 140845 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 527 EUCLID AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996698.8799 | 2113809.925 | 37.7839289983891 | -122.455138170133 | (37.7839289983891, -122.455138170133) | 11 | 6 | 1 | 54 | 31 | |||
116835 | 43746 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 253 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43378 | 5996396.86656602 | 2089502.57565196 | 37.7171697577055 | -122.454426548253 | (37.7171697577055, -122.454426548253) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||
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 | |||
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 | ||
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 | ||
129093 | 40069 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1410 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41295 | 6015766.58727052 | 2093225.96783558 | 37.7284853051097 | -122.387733653848 | (37.7284853051097, -122.387733653848) | 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 | ||
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 | |
140509 | 34630 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1766 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38311 | 5988776.9552 | 2103320.2277 | 37.7546695008183 | -122.481776191509 | (37.7546695008183, -122.481776191509) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
147085 | 40061 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
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 | ||
149710 | 40034 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | ||
169593 | 43744 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 240 Summit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43377 | 5996455.89048278 | 2089497.50907915 | 37.7171592309734 | -122.454222165987 | (37.7171592309734, -122.454222165987) | 9 | 8 | 6 | 28861 | 24 | ||
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 | ||
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 | ||
180904 | 34527 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | |||
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 | ||
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 | ||
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 | |||
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 | |||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
3187 | 70368 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1442 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983113.9936 | 2105313.3819 | 37.7598111971708 | -122.501507359539 | (37.7598111971708, -122.501507359539) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
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 | ||
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 | |
9754 | 82920 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1734 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5982872.9956 | 2103302.6049 | 37.7542760130661 | -122.502192036803 | (37.7542760130661, -122.502192036803) | 1 | 8 | 3 | 56 | 35 | |||
10339 | 73455 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 24 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009841.50181 | 2111066.87201 | 37.777142462881 | -122.409475680552 | (37.777142462881, -122.409475680552) | 8 | 2 | 9 | 28853 | 34 | |||
10370 | 72596 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1551 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988056.3788 | 2104735.0481 | 37.7585122851486 | -122.484371869742 | (37.7585122851486, -122.484371869742) | 1 | 8 | 3 | 56 | 35 | |||
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 | |||
12226 | 68412 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 33 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32249 | 5993232.78328668 | 2093269.41121212 | 37.7273306024275 | -122.465636703092 | (37.7273306024275, -122.465636703092) | 9 | 8 | 4 | 59 | 40 | ||
13763 | 72614 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1586 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987797.3449 | 2104500.8291 | 37.7578540967372 | -122.485250528016 | (37.7578540967372, -122.485250528016) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
14145 | 52527 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 123 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5 | 2x3 | Permit Number 779986 | 6001343.89555 | 2092234.36388 | 37.7249531074958 | -122.437522568322 | (37.7249531074958, -122.437522568322) | 9 | 7 | 6 | 28861 | 25 |
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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );