trees
835 rows where qSpecies_id = 122 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
1577 | 19793 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
1762 | 30595 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
5787 | 19577 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
6630 | 30591 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34560 | |||||||||||||
9025 | 30594 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34562 | |||||||||||||
13029 | 20056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
13475 | 20057 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
14833 | 20055 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
14981 | 20060 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
16044 | 19729 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
2461 | 73754 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.409684302662 | (37.8025101678048, -122.409684302662) | 3 | 1 | 10 | 308 | 23 | |||
33613 | 49479 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
41332 | 249768 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 266 Lombard St | 4 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | 3 | 1 | 10 | 308 | 23 | |||
43532 | 250193 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 3 | Back Yard : Yard | Tree | Private 2 | 35 | Width 0ft | 6011782.39923 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | 3 | 1 | 10 | 308 | 23 | |||
60595 | 49477 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
68255 | 42696 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | 5 | 1 | 10 | 28858 | 32 | |
94924 | 250191 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.403342304231 | (37.8016295579248, -122.403342304231) | 3 | 1 | 10 | 308 | 23 | |||
135943 | 124760 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007817.3795 | 2119902.39919 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | 5 | 1 | 1 | 308 | 32 | |||
142595 | 124762 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007906.12641 | 2119914.20021 | 37.8013264288216 | -122.416797725058 | (37.8013264288216, -122.416797725058) | 5 | 1 | 1 | 308 | 32 | |||
155399 | 124761 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.416967423511 | (37.8013029241584, -122.416967423511) | 5 | 1 | 1 | 308 | 32 | |||
161776 | 49478 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 560@ Pacific Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2003 12:00:00 AM | Permit Number 46402 | 6013205.44581331 | 2118473.26826983 | 37.7976666140298 | -122.39835845145 | (37.7976666140298, -122.39835845145) | 3 | 1 | 10 | 28860 | 6 | |||
162974 | 250192 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Alta St | 2 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | 3 | 1 | 10 | 308 | 23 | |||
163483 | 34234 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.412892958068 | (37.8046933049163, -122.412892958068) | 3 | 1 | 10 | 308 | 23 | ||
166730 | 71427 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.8029973115711 | -122.409613538987 | (37.8029973115711, -122.409613538987) | 3 | 1 | 10 | 308 | 23 | |
111975 | 102846 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 29 Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 1x1 | 6014262.35987 | 2114356.78408 | 37.7864225266356 | -122.394412832193 | (37.7864225266356, -122.394412832193) | 6 | 2 | 9 | 28855 | 6 | |||
164166 | 102849 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 31 Guy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1x1 | 6014185 | 2114270 | 37.7861799368485 | -122.394674400267 | (37.7861799368485, -122.394674400267) | 6 | 2 | 9 | 28855 | 6 | |||
5666 | 81675 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6013305 | 2104816 | 37.7601724196148 | -122.397055866002 | (37.7601724196148, -122.397055866002) | 10 | 3 | 8 | 28856 | 29 | |||
7242 | 83227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.397163015669 | (37.7601232913798, -122.397163015669) | 10 | 3 | 8 | 28856 | 29 | |||
9399 | 188509 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 6014325.64698 | 2106424.64729 | 37.7646461780098 | -122.393638496141 | (37.7646461780098, -122.393638496141) | 14 | 3 | 8 | 310 | 29 | ||||
10056 | 188508 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 6014332.46782 | 2106283.64375 | 37.764259392178 | -122.393605035044 | (37.764259392178, -122.393605035044) | 14 | 3 | 8 | 310 | 29 | ||||
10295 | 188526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1427x Innes Ave | 12 | Median : Yard | Tree | DPW 1 | 13 | 6016254.90623 | 2096663.38381 | 37.7379507994938 | -122.386285047323 | (37.7379507994938, -122.386285047323) | 10 | 3 | 8 | 58 | 1 | ||||
12288 | 199070 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1130 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 0 | 6013384.89381 | 2101721.18884 | 37.7516791861622 | -122.3965626049 | (37.7516791861622, -122.3965626049) | 10 | 3 | 8 | 28856 | 29 | ||||
13307 | 37952 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1308 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40191 | 6013419.73141926 | 2106176.98186548 | 37.7639157629311 | -122.396754475262 | (37.7639157629311, -122.396754475262) | 14 | 3 | 8 | 28856 | 29 | ||
13458 | 37949 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.397224649796 | (37.7586622221997, -122.397224649796) | 10 | 3 | 8 | 28856 | 29 | |
13642 | 78061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 107 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6006671.07774 | 2094291.78297 | 37.7309037694737 | -122.419252940787 | (37.7309037694737, -122.419252940787) | 9 | 3 | 7 | 309 | 28 | |||
17915 | 35351 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) | 10 | 3 | 8 | 28856 | 29 |
19224 | 261621 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1821 25th St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6013134 | 2101730 | 37.751689413587 | -122.397430852298 | (37.751689413587, -122.397430852298) | 10 | 3 | 8 | 28856 | 29 | ||||
19563 | 261622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1281x Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012916 | 2101714 | 37.7516333407735 | -122.398183607514 | (37.7516333407735, -122.398183607514) | 10 | 3 | 8 | 28856 | 29 | ||||
22960 | 54500 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.397179019096 | (37.760298732933, -122.397179019096) | 10 | 3 | 8 | 28856 | 29 | |
23139 | 188511 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 33 | Front Yard : Yard | Tree | Private 2 | 2 | 6014272.76615 | 2106665.73514 | 37.7653052137955 | -122.393838275126 | (37.7653052137955, -122.393838275126) | 14 | 3 | 8 | 310 | 29 | ||||
23190 | 188515 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1401 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6014455.23285 | 2101981.54762 | 37.7524535851846 | -122.392879417078 | (37.7524535851846, -122.392879417078) | 10 | 3 | 8 | 28856 | 1 | ||||
32263 | 67530 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.7660886653923 | -122.394807417822 | (37.7660886653923, -122.394807417822) | 14 | 3 | 8 | 28856 | 20 | |
34409 | 188513 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.394797995654 | (37.7659112417232, -122.394797995654) | 14 | 3 | 8 | 28856 | 20 | |||
41138 | 188519 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1451 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6012046.50101 | 2101636.39558 | 37.7513717861857 | -122.401185012303 | (37.7513717861857, -122.401185012303) | 10 | 3 | 8 | 28856 | 29 | ||||
41465 | 67531 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 55 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31069 | 6014000.26557437 | 2106870.40644282 | 37.7658520487611 | -122.394795132512 | (37.7658520487611, -122.394795132512) | 14 | 3 | 8 | 28856 | 20 | ||
41929 | 35367 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.7237949110596 | -122.401914809778 | (37.7237949110596, -122.401914809778) | 10 | 3 | 7 | 309 | 28 | ||
59364 | 188514 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013990.92762 | 2106981.76261 | 37.7661572890446 | -122.394835230264 | (37.7661572890446, -122.394835230264) | 14 | 3 | 8 | 28856 | 20 | |||
61987 | 67673 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1776 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31276 | 6014200.74997189 | 2095090.82766105 | 37.733518969016 | -122.393277319642 | (37.733518969016, -122.393277319642) | 10 | 3 | 8 | 58 | 1 | ||
64077 | 40191 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008969.32072 | 2093798.8519 | 37.7296794522306 | -122.411272698701 | (37.7296794522306, -122.411272698701) | 9 | 3 | 7 | 309 | 28 | ||
66532 | 67603 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 168 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | Permit Number 31174 | 6013416.46891349 | 2106299.39948246 | 37.7642517131045 | -122.39677434216 | (37.7642517131045, -122.39677434216) | 14 | 3 | 8 | 28856 | 29 | ||
67998 | 67547 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.7555368181877 | -122.401581480218 | (37.7555368181877, -122.401581480218) | 10 | 3 | 8 | 28856 | 29 | |
69627 | 188510 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 25 | Front Yard : Yard | Tree | Private 2 | 2 | 6014318.1653 | 2106535.68944 | 37.7649506596779 | -122.393672146074 | (37.7649506596779, -122.393672146074) | 14 | 3 | 8 | 310 | 29 | ||||
69704 | 188516 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1506 25th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6014137.77003 | 2102020.80679 | 37.7525437439982 | -122.393980012793 | (37.7525437439982, -122.393980012793) | 10 | 3 | 8 | 28856 | 29 | |||
75953 | 40189 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008978.52665 | 2093804.69628 | 37.7296960159571 | -122.411241285381 | (37.7296960159571, -122.411241285381) | 9 | 3 | 7 | 309 | 28 | ||
81003 | 188523 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Whitney Young Cir | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017281.36531 | 2094970.41702 | 37.7333590122106 | -122.382618269437 | (37.7333590122106, -122.382618269437) | 10 | 3 | 8 | 58 | 1 | |||
84098 | 105172 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
90686 | 188520 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) | 10 | 3 | 8 | 28856 | 29 | |||
93321 | 30761 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1575 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34642 | 6014875.77973499 | 2093824.0033781 | 37.7300780049156 | -122.39085502492 | (37.7300780049156, -122.39085502492) | 10 | 3 | 8 | 58 | 1 | ||
95221 | 40190 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | 9 | 3 | 7 | 309 | 28 | ||
98134 | 30758 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | 10 | 3 | 8 | 58 | 1 | ||
100639 | 188525 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 10 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6016572.5482 | 2095212.67149 | 37.7339850114017 | -122.385085743828 | (37.7339850114017, -122.385085743828) | 10 | 3 | 8 | 58 | 1 | |||
100887 | 188524 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Whitney Young Cir | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6017319.36932 | 2094988.95682 | 37.7334120182438 | -122.382488167193 | (37.7334120182438, -122.382488167193) | 10 | 3 | 8 | 58 | 1 | |||
101451 | 105175 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.7352873542424 | -122.390027366589 | (37.7352873542424, -122.390027366589) | 10 | 3 | 8 | 58 | 1 | |||
109969 | 66155 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1741 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1990 12:00:00 AM | Permit Number 29226 | 6013929.0546693 | 2095023.1611058 | 37.7333180723286 | -122.394211919223 | (37.7333180723286, -122.394211919223) | 10 | 3 | 8 | 58 | 1 | ||
113878 | 188522 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6016938.13191 | 2094902.83291 | 37.7331544721811 | -122.383800230417 | (37.7331544721811, -122.383800230417) | 10 | 3 | 8 | 58 | 1 | |||
115064 | 188512 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 41 | Front Yard : Yard | Tree | Private 2 | 5 | 6014229.23402 | 2106696.64866 | 37.7653876762377 | -122.393991007905 | (37.7653876762377, -122.393991007905) | 14 | 3 | 8 | 28856 | 20 | ||||
115504 | 40071 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1459 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41297 | 6015490.41779177 | 2093366.98866113 | 37.7288572181843 | -122.388698234625 | (37.7288572181843, -122.388698234625) | 10 | 3 | 8 | 58 | 1 | ||
118046 | 174966 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 44 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009006.88433 | 2093841.01999 | 37.7297973434756 | -122.411145814235 | (37.7297973434756, -122.411145814235) | 9 | 3 | 7 | 309 | 28 | |||
119130 | 188521 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 495 Connecticut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6013271.44792 | 2104826.12778 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | 10 | 3 | 8 | 28856 | 29 | |||
120281 | 1913 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 8 Bell Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016615.0158523 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | 10 | 3 | 8 | 58 | 1 | ||
121515 | 200693 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1607 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015092.9345 | 2095762.8694 | 37.7354137854933 | -122.39023969269 | (37.7354137854933, -122.39023969269) | 10 | 3 | 8 | 58 | 1 | |||
126712 | 67589 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1005 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31156 | 6015546.93269222 | 2104381.58378925 | 37.7591041527051 | -122.389271681432 | (37.7591041527051, -122.389271681432) | 10 | 3 | 8 | 28856 | 29 | ||
126849 | 42716 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 316 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42729 | 6012832.57789486 | 2094932.06844711 | 37.7330069432561 | -122.397996379955 | (37.7330069432561, -122.397996379955) | 10 | 3 | 8 | 58 | 1 | ||
134490 | 67563 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1067 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31115 | 6011664.16143038 | 2103412.99241656 | 37.7562285940169 | -122.402632116673 | (37.7562285940169, -122.402632116673) | 10 | 3 | 8 | 28856 | 29 | ||
135408 | 188518 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | 10 | 3 | 8 | 28856 | 29 | |||
139274 | 30763 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1542 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34644 | 6014903.15895955 | 2093519.78776627 | 37.7292442091543 | -122.390739119468 | (37.7292442091543, -122.390739119468) | 10 | 3 | 8 | 58 | 1 | ||
146577 | 45337 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1239 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | 14 | 3 | 8 | 28856 | 29 | ||
149308 | 188517 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2000 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6012457.67401 | 2102853.63518 | 37.7547369917341 | -122.399848584652 | (37.7547369917341, -122.399848584652) | 10 | 3 | 8 | 28856 | 29 | |||
150711 | 44091 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 807 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2000 12:00:00 AM | 6 | Permit Number 43606 | 6011323.91393 | 2104520.92035 | 37.7592517161218 | -122.40388677626 | (37.7592517161218, -122.40388677626) | 10 | 3 | 8 | 28856 | 29 | ||
158131 | 38576 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/2005 12:00:00 AM | Permit Number 40536 | 6015316.8681655 | 2094894.06453978 | 37.7330406417059 | -122.389404810986 | (37.7330406417059, -122.389404810986) | 10 | 3 | 8 | 58 | 1 | ||
165333 | 188527 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1427x Innes Ave | 30 | Median : Yard | Tree | DPW 1 | 15 | 6016131.12478 | 2096760.51066 | 37.7382106379019 | -122.386719795784 | (37.7382106379019, -122.386719795784) | 10 | 3 | 8 | 58 | 1 | ||||
166756 | 67583 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1081 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 10 | Permit Number 31148 | 6011670.33317 | 2103332.09659 | 37.7560068164771 | -122.402605084052 | (37.7560068164771, -122.402605084052) | 10 | 3 | 8 | 28856 | 29 | |
176078 | 67651 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1919 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | Permit Number 31250 | 6013521.72915428 | 2095881.08409425 | 37.7356511027367 | -122.395680256471 | (37.7356511027367, -122.395680256471) | 10 | 3 | 8 | 58 | 1 | ||
179587 | 35336 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2311 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2005 12:00:00 AM | 1 | Permit Number 48271 | 6010839.4517 | 2105063.96093 | 37.7607157062843 | -122.405600536935 | (37.7607157062843, -122.405600536935) | 10 | 3 | 8 | 28856 | 29 | |
186832 | 30760 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1571 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34641 | 6014896.23757332 | 2093808.81402101 | 37.7300374330916 | -122.390783237924 | (37.7300374330916, -122.390783237924) | 10 | 3 | 8 | 58 | 1 | ||
186914 | 67491 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1053 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 11 | Permit Number 31016 | 6011662.71218 | 2103457.28078 | 37.7563501191849 | -122.402640243074 | (37.7563501191849, -122.402640243074) | 10 | 3 | 8 | 28856 | 29 | |
191396 | 38575 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1511 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40535 | 6015329.8173 | 2094876.8945 | 37.7329942141717 | -122.389358843431 | (37.7329942141717, -122.389358843431) | 10 | 3 | 8 | 58 | 1 | |
191733 | 38582 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1565 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40542 | 6015429.1390942 | 2094459.97574961 | 37.7318549452945 | -122.388986360684 | (37.7318549452945, -122.388986360684) | 10 | 3 | 8 | 58 | 1 | ||
192293 | 35368 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 627 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | Permit Number 38828 | 6011631.82829511 | 2091600.41039567 | 37.72379195201 | -122.401913589843 | (37.72379195201, -122.401913589843) | 10 | 3 | 7 | 309 | 28 | ||
2797 | 220079 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4021 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003566.56829 | 2104171.42308 | 37.7578556427516 | -122.430690474488 | (37.7578556427516, -122.430690474488) | 2 | 4 | 5 | 28862 | 3 | |||
3321 | 220066 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002537.11463 | 2102291.14962 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | 2 | 4 | 5 | 28862 | 22 | |||
6554 | 51248 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | Permit Number 47625 | 6007471.15651424 | 2105682.67696043 | 37.7622256337552 | -122.417293833991 | (37.7622256337552, -122.417293833991) | 8 | 4 | 7 | 28859 | 19 | ||
7013 | 220677 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6006108.91147 | 2104316.67896 | 37.758398187544 | -122.421908293434 | (37.758398187544, -122.421908293434) | 2 | 4 | 5 | 28859 | 19 | ||
7303 | 220693 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004694.52758 | 2100732.52355 | 37.7484770663623 | -122.426544650217 | (37.7484770663623, -122.426544650217) | 2 | 4 | 5 | 63 | 22 |
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) );