trees
835 rows where qSpecies_id = 122 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | ||||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
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 | ||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||
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 | |||
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 | ||
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 | |||
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 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |
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 | |
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 | ||||
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 | ||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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 | ||||
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 | |
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 | ||
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 | ||
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 | |
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 | ||
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 | |
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |
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 | |||
150795 | 62618 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1988 12:00:00 AM | Permit Number 25075 | 6010492.04482679 | 2099848.37661279 | 37.7463754350507 | -122.406434552602 | (37.7463754350507, -122.406434552602) | 2 | 7 | 7 | 28859 | 2 | ||
80692 | 248081 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1624 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010444.64523 | 2100169.33268 | 37.7472540585408 | -122.406621069628 | (37.7472540585408, -122.406621069628) | 2 | 7 | 7 | 28859 | 2 | |||
8595 | 66640 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.7562136300125 | -122.407049963033 | (37.7562136300125, -122.407049963033) | 10 | 4 | 7 | 28859 | 19 | ||
79363 | 67088 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30490 | 6010217.49465897 | 2100245.63061 | 37.7474508447186 | -122.407411920985 | (37.7474508447186, -122.407411920985) | 2 | 7 | 7 | 28859 | 2 | ||
85548 | 67164 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1550 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30604 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | 2 | 7 | 7 | 28859 | 2 | ||
99442 | 111844 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1550 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | 2 | 7 | 7 | 28859 | 2 | ||||
124853 | 220670 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 948 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | 2 | 4 | 7 | 28859 | 19 | |||
191328 | 39196 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 948 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40848 | 6009924.75641086 | 2103679.40260243 | 37.7568628308131 | -122.408666394738 | (37.7568628308131, -122.408666394738) | 2 | 4 | 7 | 28859 | 19 | ||
157374 | 220671 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009657.24605 | 2096276.17296 | 37.7365202047272 | -122.409069188799 | (37.7365202047272, -122.409069188799) | 10 | 7 | 7 | 28859 | 2 | |||
32668 | 36576 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2959 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39438 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | ||
182634 | 36580 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39441 | 6009675.57743886 | 2101054.36494821 | 37.7496411039984 | -122.409342906887 | (37.7496411039984, -122.409342906887) | 2 | 4 | 7 | 28859 | 19 | ||
54736 | 220682 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1624 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009643.10137 | 2100250.00573 | 37.7474306916674 | -122.40939845218 | (37.7474306916674, -122.40939845218) | 2 | 7 | 7 | 28859 | 2 | |||
83014 | 34299 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 2460 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38087 | 6009686.14840404 | 2103014.07472331 | 37.7550226229561 | -122.409444639751 | (37.7550226229561, -122.409444639751) | 2 | 4 | 7 | 28859 | 19 | ||
97588 | 67124 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1616 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1992 12:00:00 AM | 3x3 | Permit Number 50077 | 6009627.64848121 | 2100263.06396072 | 37.7474656808625 | -122.409452808897 | (37.7474656808625, -122.409452808897) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
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 | |||
49822 | 24833 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 200X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 01/12/1996 12:00:00 AM | 25 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.7354904326241 | -122.409874802768 | (37.7354904326241, -122.409874802768) | 10 | 7 | 7 | 28859 | 2 |
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) );