trees
400 rows where qSpecies_id = 43 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
49935 | 40037 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 5 | 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 | |||
85527 | 40036 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 4 | 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 | |||
90253 | 40035 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 3 | 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 | |||
119829 | 40038 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 6 | 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 | |||
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 | |||
5387 | 38597 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1301 Revere Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.7284594450303 | -122.384664438105 | (37.7284594450303, -122.384664438105) | 10 | 3 | 8 | 58 | 1 | ||
20690 | 38595 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1301 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.7284594450303 | -122.384664438105 | (37.7284594450303, -122.384664438105) | 10 | 3 | 8 | 58 | 1 | ||
58227 | 38593 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1301 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.7284594450303 | -122.384664438105 | (37.7284594450303, -122.384664438105) | 10 | 3 | 8 | 58 | 1 | ||
82292 | 38596 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1301 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.7284594450303 | -122.384664438105 | (37.7284594450303, -122.384664438105) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
59390 | 38622 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1295 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.7277292986583 | -122.385043230392 | (37.7277292986583, -122.385043230392) | 10 | 3 | 8 | 58 | 1 | ||
93563 | 38619 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1295 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.7277292986583 | -122.385043230392 | (37.7277292986583, -122.385043230392) | 10 | 3 | 8 | 58 | 1 | ||
140640 | 38620 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1295 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.7277292986583 | -122.385043230392 | (37.7277292986583, -122.385043230392) | 10 | 3 | 8 | 58 | 1 | ||
152483 | 38621 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1295 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.7277292986583 | -122.385043230392 | (37.7277292986583, -122.385043230392) | 10 | 3 | 8 | 58 | 1 | ||
150948 | 38598 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1329 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40549 | 6016511.31684241 | 2093304.91013991 | 37.7287432904596 | -122.385164559023 | (37.7287432904596, -122.385164559023) | 10 | 3 | 8 | 58 | 1 | ||
4468 | 40059 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 3 | 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 | ||
47665 | 40058 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 4 | 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 | ||
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 | ||
151562 | 40060 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 1 | 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 | ||
9053 | 38570 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
98576 | 38571 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
117190 | 38569 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
137180 | 38567 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
165786 | 38568 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
166378 | 38565 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
58314 | 38629 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 | ||
155651 | 38627 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 | ||
160706 | 38628 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1998 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
36083 | 40050 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1439 Revere Ave | 1 | 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 | ||
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 | ||
72918 | 38642 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40567 | 6015859.80735798 | 2093156.47365065 | 37.7282996512663 | -122.38740653837 | (37.7282996512663, -122.38740653837) | 10 | 3 | 8 | 58 | 1 | ||
67064 | 40067 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1400 Thomas Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.387554479201 | (37.7283836150635, -122.387554479201) | 10 | 3 | 8 | 58 | 1 | ||
115401 | 40066 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1400 Thomas Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.387554479201 | (37.7283836150635, -122.387554479201) | 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 | ||
146130 | 40068 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1410 Thomas Ave | 1 | 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 | ||
60108 | 39693 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1475 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41078 | 6015709.80747314 | 2094943.53448428 | 37.7331982540931 | -122.388049755187 | (37.7331982540931, -122.388049755187) | 10 | 3 | 8 | 58 | 1 | ||
139109 | 38601 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1534 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40552 | 6015446.13574073 | 2094163.07491578 | 37.7310406573671 | -122.388906878559 | (37.7310406573671, -122.388906878559) | 10 | 3 | 8 | 58 | 1 | ||
15667 | 38606 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1558 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40554 | 6015323.31475554 | 2094254.15832382 | 37.7312839455717 | -122.389337853373 | (37.7312839455717, -122.389337853373) | 10 | 3 | 8 | 58 | 1 | |
86065 | 29418 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2601X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6015194.8940554 | 2091164.3100784 | 37.7227927176508 | -122.389566117231 | (37.7227927176508, -122.389566117231) | 10 | 3 | 8 | 58 | 1 | |||
129068 | 36828 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2600 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | 10 | 3 | 8 | 58 | 1 | ||
145081 | 36827 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2600 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | 10 | 3 | 8 | 58 | 1 | ||
148296 | 36829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2600 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | 10 | 3 | 8 | 58 | 1 | ||
114130 | 36832 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2655 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.389855194073 | (37.7224666226612, -122.389855194073) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
147777 | 36830 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2655 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.389855194073 | (37.7224666226612, -122.389855194073) | 10 | 3 | 8 | 58 | 1 | ||
8969 | 38615 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
21583 | 38613 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
26720 | 38614 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
89942 | 38612 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
183262 | 38616 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
125189 | 38617 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1619 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40558 | 6014993.23240611 | 2094434.43177017 | 37.7317606344589 | -122.390491609305 | (37.7317606344589, -122.390491609305) | 10 | 3 | 8 | 58 | 1 | ||
146098 | 38618 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1648 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40559 | 6014913.01600852 | 2094558.97753063 | 37.7320981616183 | -122.390777636678 | (37.7320981616183, -122.390777636678) | 10 | 3 | 8 | 58 | 1 | ||
30259 | 36821 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
71570 | 36820 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
90544 | 36823 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
124971 | 36826 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
153929 | 36822 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
187434 | 36819 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
123655 | 38553 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1791 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2005 12:00:00 AM | Permit Number 40521 | 6014535.26572589 | 2096873.10267881 | 37.7384313099375 | -122.392245401183 | (37.7384313099375, -122.392245401183) | 10 | 3 | 8 | 58 | 1 | ||
75146 | 42256 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1451 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42500 | 6014382.14951701 | 2101979.25998884 | 37.7524432441755 | -122.39313199334 | (37.7524432441755, -122.39313199334) | 10 | 3 | 8 | 28856 | 1 | |||
101538 | 39689 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 56 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41074 | 6013706.29242939 | 2094956.2180602 | 37.7331218759444 | -122.394977388495 | (37.7331218759444, -122.394977388495) | 10 | 3 | 8 | 58 | 1 | ||
23688 | 68883 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 59 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32855 | 6013060.20442694 | 2090777.05783105 | 37.721610806199 | -122.396918198144 | (37.721610806199, -122.396918198144) | 10 | 3 | 8 | 58 | 1 | ||
138527 | 42740 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 188 Nueva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42736 | 6012851.94955825 | 2087048.25997051 | 37.7113606761586 | -122.397376721388 | (37.7113606761586, -122.397376721388) | 10 | 3 | 8 | 309 | 1 | ||
74396 | 121619 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 1465 Rhode Island St | 1 | Front Yard : Yard | Tree | Private 2 | 6012073 | 2101555 | 37.7511497699027 | -122.401087656443 | (37.7511497699027, -122.401087656443) | 10 | 3 | 8 | 28856 | 29 | |||||
136441 | 38176 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40311 | 6011565.07182758 | 2091659.31063556 | 37.7239499540685 | -122.402148496173 | (37.7239499540685, -122.402148496173) | 10 | 3 | 7 | 309 | 28 | ||
89187 | 251679 | Undocumented 4 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011495 | 2091622 | 37.7238435952898 | -122.402388102511 | (37.7238435952898, -122.402388102511) | 10 | 3 | 7 | 309 | 28 | |||||
111237 | 38179 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 36 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40312 | 6011464.3100447 | 2091682.81198966 | 37.7240088592297 | -122.402498467389 | (37.7240088592297, -122.402498467389) | 10 | 3 | 7 | 309 | 28 | ||
179341 | 38180 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 42 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40313 | 6011447.25206772 | 2091677.58315317 | 37.7239935496068 | -122.402557066965 | (37.7239935496068, -122.402557066965) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||
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 | ||
181109 | 38195 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 730 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40323 | 6011305.3220934 | 2091453.71988413 | 37.7233709423274 | -122.403031960796 | (37.7233709423274, -122.403031960796) | 10 | 3 | 7 | 309 | 28 | ||
147396 | 38211 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 201 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40334 | 6011139.75939059 | 2091047.44760609 | 37.7222461553598 | -122.403575712805 | (37.7222461553598, -122.403575712805) | 10 | 3 | 7 | 309 | 28 | ||
72189 | 38209 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 830 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40332 | 6010874.68113014 | 2090828.02861629 | 37.7216288654759 | -122.40447659257 | (37.7216288654759, -122.40447659257) | 10 | 3 | 7 | 309 | 28 | ||
43878 | 38172 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 433 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40308 | 6010665.04465284 | 2092691.20819375 | 37.7267330524509 | -122.405332397121 | (37.7267330524509, -122.405332397121) | 10 | 3 | 7 | 309 | 28 | ||
18513 | 38167 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 315 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40305 | 6010555.26362325 | 2092792.3936381 | 37.7270047480515 | -122.405719032848 | (37.7270047480515, -122.405719032848) | 10 | 3 | 7 | 309 | 28 | ||
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 | ||
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 | ||
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 | ||
86025 | 38199 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 455 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40326 | 6010407.74547618 | 2092510.58020697 | 37.7262226967111 | -122.406209156508 | (37.7262226967111, -122.406209156508) | 10 | 3 | 7 | 309 | 28 | ||
105045 | 37437 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 51 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39912 | 6010454.2114909 | 2099614.59600709 | 37.745731407921 | -122.406548905427 | (37.745731407921, -122.406548905427) | 2 | 7 | 7 | 28859 | 2 | ||
169743 | 37845 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 132 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2005 12:00:00 AM | Permit Number 40137 | 6010294.81147281 | 2099208.35616527 | 37.7446070428057 | -122.40707146066 | (37.7446070428057, -122.40707146066) | 2 | 7 | 7 | 28859 | 2 | ||
170691 | 37458 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 25 MacEdonia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39930 | 6010305.7989409 | 2099791.60340169 | 37.7462091274065 | -122.407074571233 | (37.7462091274065, -122.407074571233) | 2 | 7 | 7 | 28859 | 2 | ||
134688 | 43251 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 270 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | Permit Number 43039 | 6009534.75313896 | 2093131.57732831 | 37.727878953409 | -122.409270860276 | (37.727878953409, -122.409270860276) | 10 | 3 | 7 | 309 | 28 | ||
139804 | 191035 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 30 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009859.31671 | 2111047.24968 | 37.7770895827422 | -122.409412667772 | (37.7770895827422, -122.409412667772) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | ||
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 | |||
44351 | 37782 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 289 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40117 | 6009320.94225991 | 2092982.60267054 | 37.7274579192917 | -122.409999500097 | (37.7274579192917, -122.409999500097) | 10 | 3 | 7 | 309 | 28 | ||
187515 | 37783 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 289 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40117 | 6009320.94225991 | 2092982.60267054 | 37.7274579192917 | -122.409999500097 | (37.7274579192917, -122.409999500097) | 10 | 3 | 7 | 309 | 28 | ||
139708 | 31829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
156451 | 31830 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 222 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35288 | 6009542.64532801 | 2109092.58934898 | 37.7717047944846 | -122.410370088519 | (37.7717047944846, -122.410370088519) | 8 | 2 | 9 | 28853 | 34 | ||
131078 | 31826 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 204 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35286 | 6009467.18551703 | 2109171.58635448 | 37.7719174714901 | -122.410636689386 | (37.7719174714901, -122.410636689386) | 8 | 2 | 9 | 28853 | 34 | ||
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 | ||
89415 | 40641 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 187 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41639 | 6009210.87994007 | 2099144.38708889 | 37.7443706801351 | -122.410814978675 | (37.7443706801351, -122.410814978675) | 2 | 7 | 7 | 28859 | 2 | |||
172957 | 40642 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 185 Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1999 12:00:00 AM | Permit Number 41640 | 6009192.03574967 | 2099143.33903301 | 37.7443667457738 | -122.410880064189 | (37.7443667457738, -122.410880064189) | 2 | 7 | 7 | 28859 | 2 | |||
69645 | 43105 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2004 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 |
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) );