trees
180 rows where qSpecies_id = 150 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
154745 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
157275 | 173625 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1200X Junipero Serra Blvd | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
157656 | 142164 | Undocumented 4 | Acacia longifolia :: Golden Wattle 150 | 490 Baker St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6000672.4904 | 2110619.9435 | 37.7753972916401 | -122.44116203009 | (37.7753972916401, -122.44116203009) | 15 | 5 | 11 | 29492 | 10 | |||
158251 | 188550 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6013235.33415 | 2102896.38806 | 37.7548977050817 | -122.397162202681 | (37.7548977050817, -122.397162202681) | 10 | 3 | 8 | 28856 | 29 | ||||
159120 | 12858 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2455 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 5987787.46088 | 2114620.72752 | 37.7856399434951 | -122.486027545007 | (37.7856399434951, -122.486027545007) | 11 | 6 | 2 | 55 | 26 | |||
162939 | 116890 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 799X Marina Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999183.52163 | 2121463.27937 | 37.8050853080999 | -122.447093221893 | (37.8050853080999, -122.447093221893) | 13 | 9 | 1 | 57 | 17 | |||
165218 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
165268 | 188545 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 651 Missouri St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013660.85413 | 2103803.37059 | 37.75741176256 | -122.395754171925 | (37.75741176256, -122.395754171925) | 10 | 3 | 8 | 28856 | 29 | ||||
170130 | 186367 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1801 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984825.2316 | 2102541.2113 | 37.7522999403759 | -122.495384664955 | (37.7522999403759, -122.495384664955) | 1 | 8 | 3 | 56 | 35 | |||
170265 | 220120 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 15 | 6005087.11734 | 2097092.81243 | 37.738505435679 | -122.424928164698 | (37.738505435679, -122.424928164698) | 2 | 7 | 5 | 63 | 7 | ||||
170310 | 188563 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1 Waterville St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6011470.31075 | 2096143.82241 | 37.7362581989524 | -122.402791312072 | (37.7362581989524, -122.402791312072) | 10 | 3 | 8 | 58 | 1 | ||||
170593 | 142166 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1477 GROVE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000715.4928 | 2110652.1954 | 37.7754882965725 | -122.441015589387 | (37.7754882965725, -122.441015589387) | 15 | 5 | 11 | 29492 | 10 | |||
171557 | 6704 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1200X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
172468 | 141736 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1420 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003702.0095 | 2113653.0853 | 37.7838976435553 | -122.430898731444 | (37.7838976435553, -122.430898731444) | 13 | 9 | 11 | 29490 | 41 | |||
173199 | 186270 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1800 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984992.9477 | 2102426.3669 | 37.7519944279313 | -122.49479621795 | (37.7519944279313, -122.49479621795) | 1 | 8 | 3 | 56 | 35 | |||
173327 | 97334 | Undocumented 4 | Acacia longifolia :: Golden Wattle 150 | 211 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5987387.3 | 2114536.2 | 37.7853845267129 | -122.487405756991 | (37.7853845267129, -122.487405756991) | 11 | 6 | 1 | 55 | 33 | ||||
173340 | 22130 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3795X 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
173544 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
175670 | 21440 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2692X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
175920 | 188561 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2230 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6012197.23492 | 2099395.45129 | 37.7452270442016 | -122.400506356909 | (37.7452270442016, -122.400506356909) | 10 | 3 | 8 | 58 | 1 | |||
178060 | 120395 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 735 24th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5988459.66888 | 2110795.13561 | 37.7751750962322 | -122.483421379665 | (37.7751750962322, -122.483421379665) | 11 | 6 | 2 | 55 | 26 | ||||
179418 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
180412 | 6835 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1485 FAIRFAX AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/2017 08:13:00 AM | 3 | 3X3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | ||
180735 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard | Tree | Private 2 | 12 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
181814 | 247417 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 981 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001920.2327 | 2109431.4693 | 37.7722050316748 | -122.436760709737 | (37.7722050316748, -122.436760709737) | 15 | 5 | 11 | 29492 | 9 | |||
184496 | 101135 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1477 Grove St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||||
184558 | 186118 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1700 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984966.576 | 2103035.9667 | 37.7536666774921 | -122.49493235749 | (37.7536666774921, -122.49493235749) | 1 | 8 | 3 | 56 | 35 | |||
185709 | 26889 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1601 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6015842.1307553 | 2097647.0535434 | 37.7406288998504 | -122.387780842816 | (37.7406288998504, -122.387780842816) | 10 | 3 | 8 | 58 | 1 | |||
185977 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
187481 | 22125 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3795X 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
189813 | 185642 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2100 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985069.1522 | 2100447.6812 | 37.7465659581193 | -122.494386853704 | (37.7465659581193, -122.494386853704) | 1 | 8 | 3 | 29491 | 35 | |||
190012 | 6427 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1100X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018163.14059 | 2096688.19053 | 37.7381243524454 | -122.379688994958 | (37.7381243524454, -122.379688994958) | 10 | 3 | 8 | 58 | 1 | |||
191870 | 188555 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013407.82956 | 2102894.99959 | 37.7549034940071 | -122.396565563648 | (37.7549034940071, -122.396565563648) | 10 | 3 | 8 | 28856 | 29 | ||||
25182 | 30293 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 2101 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | Permit Number 136 | 6003511.17021246 | 2117907.12338032 | 37.795567335959 | -122.431862816552 | (37.795567335959, -122.431862816552) | 13 | 9 | 1 | 29490 | 27 | |||
126091 | 30294 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 2705 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | Permit Number 137 | 6003541.5840662 | 2117604.65844184 | 37.7947385690082 | -122.43173597332 | (37.7947385690082, -122.43173597332) | 13 | 9 | 1 | 29490 | 27 | |||
154388 | 61492 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 171 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/1984 12:00:00 AM | Permit Number 21441 | 5989584.76357215 | 2114231.48161607 | 37.7846757617561 | -122.479780973493 | (37.7846757617561, -122.479780973493) | 11 | 6 | 2 | 55 | 26 | ||
172070 | 61500 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 155 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1984 12:00:00 AM | Permit Number 21453 | 5989580.98367675 | 2114335.37160458 | 37.784960794856 | -122.479801655238 | (37.784960794856, -122.479801655238) | 11 | 6 | 2 | 55 | 26 | ||
73044 | 56310 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | Permit Number 21650 | 5993077.11990526 | 2114307.36148956 | 37.7850863731263 | -122.467704208587 | (37.7850863731263, -122.467704208587) | 11 | 6 | 2 | 54 | 11 | ||
85742 | 62544 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22739 | 6001803.31467833 | 2109086.42479932 | 37.7712509798957 | -122.437140429673 | (37.7712509798957, -122.437140429673) | 15 | 5 | 11 | 29492 | 9 | ||
108542 | 62546 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 324 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22741 | 6001810.43023006 | 2109526.13327918 | 37.7724587144958 | -122.437147304211 | (37.7724587144958, -122.437147304211) | 15 | 5 | 11 | 29492 | 9 | ||
166484 | 62547 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 339 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22742 | 6001725.06048849 | 2109561.60697562 | 37.772551263359 | -122.43744514665 | (37.772551263359, -122.43744514665) | 15 | 5 | 11 | 29492 | 9 | ||
119874 | 62548 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22743 | 6001791.89658849 | 2109658.78296356 | 37.7728218839519 | -122.437220913321 | (37.7728218839519, -122.437220913321) | 15 | 5 | 11 | 29492 | 9 | ||
10494 | 62550 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 851 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22746 | 6002504.62213879 | 2109507.36231307 | 37.7724466097716 | -122.43474468697 | (37.7724466097716, -122.43474468697) | 15 | 5 | 11 | 29492 | 9 | ||
122138 | 59644 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 865 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22747 | 6002440.7343378 | 2109498.78550878 | 37.7724194326945 | -122.434965067297 | (37.7724194326945, -122.434965067297) | 15 | 5 | 11 | 29492 | 9 | ||
23013 | 62551 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 873 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22748 | 6002404.22700345 | 2109493.88447514 | 37.7724039027427 | -122.435090998906 | (37.7724039027427, -122.435090998906) | 15 | 5 | 11 | 29492 | 9 | ||
88750 | 62552 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 925 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22749 | 6002145.34756636 | 2109458.3701838 | 37.7722916859717 | -122.435983944483 | (37.7722916859717, -122.435983944483) | 15 | 5 | 11 | 29492 | 9 | ||
15340 | 62553 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 932 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22750 | 6002100.93353536 | 2109504.64892618 | 37.7724162326817 | -122.436140888716 | (37.7724162326817, -122.436140888716) | 15 | 5 | 11 | 29492 | 9 | ||
167077 | 62554 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 950 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22751 | 6002017.25559301 | 2109492.91057277 | 37.772379247666 | -122.436429497983 | (37.772379247666, -122.436429497983) | 15 | 5 | 11 | 29492 | 9 | ||
171859 | 62555 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 968 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22753 | 6001933.57765066 | 2109481.17221936 | 37.7723422619436 | -122.436718106962 | (37.7723422619436, -122.436718106962) | 15 | 5 | 11 | 29492 | 9 | ||
132213 | 62556 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1009 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22755 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
164894 | 62557 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 231 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22756 | 6002274.80033002 | 2109264.35337792 | 37.7717663171547 | -122.435522274291 | (37.7717663171547, -122.435522274291) | 15 | 5 | 11 | 29492 | 9 | ||
2897 | 62561 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 263 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22761 | 6002735.54596737 | 2109434.34982555 | 37.7722592430025 | -122.433940680004 | (37.7722592430025, -122.433940680004) | 15 | 5 | 11 | 29492 | 9 | ||
58313 | 62564 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 401 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22765 | 6001708.19271751 | 2109769.06982879 | 37.7731199456311 | -122.437518353384 | (37.7731199456311, -122.437518353384) | 15 | 5 | 11 | 29492 | 9 | ||
160672 | 63206 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 3641 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23748 | 5984253.92200128 | 2113128.61080648 | 37.7813364679992 | -122.498142145884 | (37.7813364679992, -122.498142145884) | 11 | 6 | 2 | 55 | 26 | ||
40967 | 63210 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 3601 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23753 | 5984371.56597884 | 2113133.02236934 | 37.7813554779566 | -122.497735487323 | (37.7813554779566, -122.497735487323) | 11 | 6 | 2 | 55 | 26 | ||
161808 | 63217 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 3621 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23761 | 5984312.74399006 | 2113130.81658791 | 37.7813459731532 | -122.497938816629 | (37.7813459731532, -122.497938816629) | 11 | 6 | 2 | 55 | 26 | ||
124619 | 63746 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 963 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24418 | 6001968.69414602 | 2109433.58921739 | 37.7722136064806 | -122.436593229472 | (37.7722136064806, -122.436593229472) | 15 | 5 | 11 | 29492 | 9 | ||
57534 | 64732 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1988 12:00:00 AM | Permit Number 25691 | 6001783.83117373 | 2109148.55885484 | 37.7714204770503 | -122.437212273367 | (37.7714204770503, -122.437212273367) | 15 | 5 | 11 | 29492 | 9 | ||
119903 | 30340 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 175 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/1956 12:00:00 AM | Permit Number 26 | 5994414.04695782 | 2098601.44324242 | 37.7420391129783 | -122.461939590962 | (37.7420391129783, -122.461939590962) | 1 | 8 | 4 | 59 | 40 | |||
125502 | 65122 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 328 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27092 | 5989675.82756959 | 2113141.97698014 | 37.7816895771658 | -122.479386191274 | (37.7816895771658, -122.479386191274) | 11 | 6 | 2 | 55 | 26 | ||
28787 | 65914 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 431 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28924 | 5994447.75768828 | 2106990.5338514 | 37.7650753550186 | -122.462431373492 | (37.7650753550186, -122.462431373492) | 11 | 5 | 11 | 56 | 12 | ||
85297 | 65918 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1346 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28933 | 5994594.09113824 | 2106359.56698751 | 37.7633513097166 | -122.461879489309 | (37.7633513097166, -122.461879489309) | 15 | 5 | 11 | 56 | 12 | ||
120558 | 62558 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 240 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30458 | 6002321.70129221 | 2109304.4334506 | 37.771879030768 | -122.43536290852 | (37.771879030768, -122.43536290852) | 15 | 5 | 11 | 29492 | 9 | ||
144633 | 34853 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 85 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/01/1997 12:00:00 AM | Permit Number 38476 | 6001445.41488356 | 2093713.29123004 | 37.7290196763486 | -122.437277475077 | (37.7290196763486, -122.437277475077) | 9 | 7 | 6 | 28861 | 25 | ||
153103 | 34992 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 829 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/17/2000 12:00:00 AM | Permit Number 38570 | 5998631.01806421 | 2107405.55103252 | 37.7664548933778 | -122.447992448577 | (37.7664548933778, -122.447992448577) | 15 | 5 | 11 | 29492 | 9 | ||
147928 | 35038 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 955 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/1998 12:00:00 AM | Permit Number 38604 | 6002005.88434069 | 2109438.80626308 | 37.7722300445304 | -122.436464959051 | (37.7722300445304, -122.436464959051) | 15 | 5 | 11 | 29492 | 9 | ||
177158 | 36668 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 973 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39474 | 6001922.20638095 | 2109427.06790723 | 37.7721930587125 | -122.436753567493 | (37.7721930587125, -122.436753567493) | 15 | 5 | 11 | 29492 | 9 | ||
156189 | 40632 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1385 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.444881875249 | (37.7677198855431, -122.444881875249) | 15 | 5 | 11 | 29492 | 9 | |||
63575 | 44253 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1375 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.384281551427 | (37.7404816352752, -122.384281551427) | 10 | 3 | 8 | 58 | 1 | |||
101683 | 44252 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1375 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.384281551427 | (37.7404816352752, -122.384281551427) | 10 | 3 | 8 | 58 | 1 | |||
185791 | 45128 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 232 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43985 | 6004034.46486858 | 2105728.24125402 | 37.7621567917777 | -122.429183297925 | (37.7621567917777, -122.429183297925) | 8 | 4 | 5 | 28862 | 3 | |||
51132 | 85506 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
50068 | 86923 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 195 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49881 | 6004763 | 2102539 | 37.7534411018365 | -122.426436480741 | (37.7534411018365, -122.426436480741) | 2 | 4 | 5 | 28862 | 22 | |||
176679 | 53569 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 718 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1988 12:00:00 AM | Permit Number 6489 | 6002262.08955542 | 2108831.48537983 | 37.7705770468004 | -122.435535269571 | (37.7705770468004, -122.435535269571) | 15 | 5 | 11 | 29492 | 9 | ||
54153 | 87313 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 230 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2008 12:00:00 AM | 3x3 | Permit Number 768785 | 6005882 | 2110375 | 37.7750200980063 | -122.423123675956 | (37.7750200980063, -122.423123675956) | 7 | 9 | 11 | 28852 | 10 | ||
98863 | 100365 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 450X Baker St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769344 | 6000745 | 2110655 | 37.7754976778855 | -122.44091371844 | (37.7754976778855, -122.44091371844) | 15 | 5 | 11 | 29492 | 10 | ||||
26226 | 247413 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 963 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | Permit Number 782288 | 6001970.4339 | 2109438.2533 | 37.7722265117572 | -122.436587545425 | (37.7722265117572, -122.436587545425) | 15 | 5 | 11 | 29492 | 9 | ||
145751 | 30311 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 860 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9 | 5983275.48572939 | 2109941.19024403 | 37.7725273211727 | -122.501291162566 | (37.7725273211727, -122.501291162566) | 11 | 6 | 2 | 55 | 26 | ||||
136727 | 53938 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 13 | Permit Number 9652 | 5993071.23757 | 2114298.66075 | 37.7850621436327 | -122.467723926434 | (37.7850621436327, -122.467723926434) | 11 | 6 | 2 | 54 | 11 | ||
27746 | 54159 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 262 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 13 | Permit Number 9894 | 6012942.04708 | 2095291.83842 | 37.7340008934128 | -122.397643138528 | (37.7340008934128, -122.397643138528) | 10 | 3 | 8 | 58 | 1 |
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) );