trees
835 rows where qSpecies_id = 122 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120775 | 142261 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 575 LINDEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004683.1776 | 2110693.6136 | 37.7758272084051 | -122.427293365492 | (37.7758272084051, -122.427293365492) | 7 | 9 | 11 | 28852 | 10 | |||
| 116433 | 142264 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 575 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004642.0376 | 2110688.0426 | 37.7758095850789 | -122.427435282317 | (37.7758095850789, -122.427435282317) | 7 | 9 | 11 | 28852 | 10 | |||
| 172487 | 142298 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501 GROVE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6000546.8174 | 2110627.5355 | 37.775410978082 | -122.441597306223 | (37.775410978082, -122.441597306223) | 15 | 5 | 11 | 29492 | 16 | |||
| 113016 | 142346 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 505 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999691.4094 | 2110243.208 | 37.7743069396367 | -122.444528725577 | (37.7743069396367, -122.444528725577) | 15 | 5 | 11 | 29492 | 16 | |||
| 130218 | 17224 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1880X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6001029.5778 | 2091188.70927 | 37.7220641019562 | -122.438534240876 | (37.7220641019562, -122.438534240876) | 9 | 7 | 6 | 28861 | 25 | |||
| 165658 | 17229 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1880X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6000980.93913 | 2091103.33988 | 37.7218269300432 | -122.438696258244 | (37.7218269300432, -122.438696258244) | 9 | 7 | 6 | 28861 | 25 | |||
| 161026 | 174958 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | 9 | 7 | 6 | 28861 | 25 | |||
| 118536 | 174959 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 De Long St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.7096014661041 | -122.461142043293 | (37.7096014661041, -122.461142043293) | 9 | 8 | 6 | 28861 | 25 | |||
| 185826 | 174960 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 103 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 5994409.59914 | 2086788.11813 | 37.7096023276577 | -122.461098897396 | (37.7096023276577, -122.461098897396) | 9 | 8 | 6 | 28861 | 25 | |||
| 171199 | 174961 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 54 Santa Ynez Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6000769.59798 | 2092028.99302 | 37.7243565377 | -122.439493130409 | (37.7243565377, -122.439493130409) | 9 | 7 | 6 | 28861 | 25 | ||||
| 133936 | 174962 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 114 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000450.3974 | 2092235.26707 | 37.7249047473371 | -122.440611347459 | (37.7249047473371, -122.440611347459) | 9 | 7 | 6 | 28861 | 25 | |||
| 50530 | 174963 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 27 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005106.80972 | 2093312.66064 | 37.7281270946664 | -122.424591254394 | (37.7281270946664, -122.424591254394) | 9 | 7 | 6 | 28861 | 5 | |||
| 15606 | 174964 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1645 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006075.21093 | 2092385.59149 | 37.7256362082245 | -122.421177650028 | (37.7256362082245, -122.421177650028) | 9 | 7 | 7 | 309 | 5 | |||
| 134400 | 174965 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1645 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006090.3331 | 2092391.29935 | 37.7256527332703 | -122.421125778931 | (37.7256527332703, -122.421125778931) | 9 | 7 | 7 | 309 | 5 | |||
| 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 | |||
| 95811 | 182146 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5989681.6149 | 2103872.2722 | 37.756237834999 | -122.478688039412 | (37.756237834999, -122.478688039412) | 1 | 8 | 3 | 56 | 35 | |||
| 78215 | 182147 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1690 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989680.1915 | 2103890.3009 | 37.756287254354 | -122.478694280415 | (37.756287254354, -122.478694280415) | 1 | 8 | 3 | 56 | 35 | |||
| 157313 | 183506 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2542 27th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5988021.6131 | 2097993.9577 | 37.7400010259161 | -122.483997786352 | (37.7400010259161, -122.483997786352) | 1 | 8 | 3 | 29491 | 35 | |||
| 177297 | 184961 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1990 41st Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5983548.8239 | 2101628.263 | 37.7497184185455 | -122.4997311455 | (37.7497184185455, -122.4997311455) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 102025 | 19281 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
| 59125 | 19282 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
| 108665 | 19283 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | |||
| 162982 | 19284 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 9 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
| 11039 | 19285 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/1998 12:00:00 AM | 11 | 3X3 | 6001619.01622 | 2114490.46983 | 37.786078645055 | -122.438165110876 | (37.786078645055, -122.438165110876) | 13 | 6 | 1 | 29490 | 27 | ||
| 5787 | 19577 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY3 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15ST | |||||||||||||
| 16044 | 19729 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY14 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 40ST | |||||||||||||
| 1577 | 19793 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY19 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
| 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 | ||||
| 3232 | 20054 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 1 | 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 | |||||||||||||
| 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 | |||||||||||||
| 3129 | 20059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 14981 | 20060 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 5215 | 20061 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15ST | |||||||||||||
| 3626 | 20062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 2826 | 20064 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST | |||||||||||||
| 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 | |||
| 142712 | 203221 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2398 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5992664.0139 | 2099193.92326 | 37.7435650062179 | -122.468033683007 | (37.7435650062179, -122.468033683007) | 1 | 8 | 4 | 29491 | 40 | |||
| 143216 | 203222 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993081.79545 | 2099194.67138 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | 1 | 8 | 4 | 29491 | 40 | |||
| 32638 | 203223 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994463.96401 | 2093754.28831 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | 9 | 8 | 4 | 59 | 40 | |||
| 120520 | 203224 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 30 Northgate Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5994449.32754 | 2093942.03458 | 37.7292475573046 | -122.461479885289 | (37.7292475573046, -122.461479885289) | 9 | 8 | 4 | 59 | 40 | |||
| 62285 | 203225 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993973.71625 | 2104850.02282 | 37.759170760037 | -122.463915566851 | (37.759170760037, -122.463915566851) | 1 | 5 | 4 | 56 | 12 | |||
| 93718 | 203226 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5993976.59011 | 2104728.66377 | 37.7588377051234 | -122.463896818678 | (37.7588377051234, -122.463896818678) | 1 | 5 | 4 | 56 | 12 | |||
| 151023 | 203227 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1575 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5993976.11047 | 2104705.81134 | 37.7587749306244 | -122.463896818706 | (37.7587749306244, -122.463896818706) | 1 | 5 | 4 | 56 | 12 | |||
| 74041 | 203620 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.462844042611 | (37.7492932209146, -122.462844042611) | 1 | 8 | 4 | 29491 | 40 | |||
| 169357 | 203621 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 21 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997303.38212 | 2099336.74248 | 37.7442239835511 | -122.452002277389 | (37.7442239835511, -122.452002277389) | 9 | 7 | 4 | 59 | 40 | |||
| 119123 | 203622 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997339.99838 | 2099579.33016 | 37.7448921672303 | -122.45189316446 | (37.7448921672303, -122.45189316446) | 9 | 7 | 4 | 59 | 40 | |||
| 93770 | 203623 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997330.81089 | 2099592.07349 | 37.744926631064 | -122.45192585212 | (37.744926631064, -122.45192585212) | 9 | 7 | 4 | 59 | 40 | |||
| 67158 | 203624 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5997319.6106 | 2099609.0427 | 37.7449725828299 | -122.451965804492 | (37.7449725828299, -122.451965804492) | 9 | 7 | 4 | 59 | 40 | |||
| 16364 | 203625 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.451994860675 | (37.7450070466421, -122.451994860675) | 9 | 7 | 4 | 59 | 40 | |||
| 94584 | 203626 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 12 Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5997325.36011 | 2099393.71244 | 37.7443816679834 | -122.451930391889 | (37.7443816679834, -122.451930391889) | 9 | 7 | 4 | 59 | 40 | |||
| 44577 | 203627 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 133 Maywood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5994260.23727 | 2095673.9858 | 37.7339921852793 | -122.462259143365 | (37.7339921852793, -122.462259143365) | 9 | 8 | 4 | 59 | 40 | |||
| 90906 | 203628 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 133 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5994258.53071 | 2095683.80268 | 37.734019041749 | -122.462265755167 | (37.734019041749, -122.462265755167) | 9 | 8 | 4 | 59 | 40 | |||
| 63154 | 203629 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 138 Encline Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998295.84832 | 2098462.32087 | 37.7418798313816 | -122.448507597342 | (37.7418798313816, -122.448507597342) | 9 | 7 | 4 | 59 | 40 | |||
| 98362 | 203630 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1400 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 5993843.17005 | 2094826.47883 | 37.7316411164345 | -122.46363957301 | (37.7316411164345, -122.46363957301) | 9 | 8 | 4 | 59 | 40 | |||
| 36745 | 203631 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1400 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 5993837.01835 | 2094842.09298 | 37.7316836345786 | -122.463661973318 | (37.7316836345786, -122.463661973318) | 9 | 8 | 4 | 59 | 40 | |||
| 172691 | 203632 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1400 Monterey Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5993831.29855 | 2094857.6984 | 37.7317261536347 | -122.463682879865 | (37.7317261536347, -122.463682879865) | 9 | 8 | 4 | 59 | 40 | |||
| 9936 | 203633 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997727.84983 | 2094119.15999 | 37.7299220605503 | -122.450158563772 | (37.7299220605503, -122.450158563772) | 9 | 7 | 4 | 28861 | 40 | |||
| 70641 | 203634 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.03229 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | 9 | 7 | 4 | 28861 | 40 | |
| 30081 | 203635 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 418 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997950.41926 | 2094116.13567 | 37.7299264906077 | -122.449388900582 | (37.7299264906077, -122.449388900582) | 9 | 7 | 4 | 28861 | 40 | |||
| 173566 | 203636 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | 9 | 7 | 4 | 28861 | 40 | |||
| 107495 | 203637 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 270 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998290.1238 | 2093810.02027 | 37.7291053960882 | -122.448192473116 | (37.7291053960882, -122.448192473116) | 9 | 7 | 4 | 28861 | 40 | |||
| 100046 | 203638 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994537.11563 | 2090599.09131 | 37.7200736945131 | -122.460934206371 | (37.7200736945131, -122.460934206371) | 9 | 8 | 6 | 28861 | 24 | |||
| 7171 | 203639 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5992221.12373 | 2089294.63928 | 37.7163584485498 | -122.468844858017 | (37.7163584485498, -122.468844858017) | 9 | 8 | 6 | 64 | 24 | |||
| 171790 | 203640 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 216 Ralston St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 5ft | 5992221.60329 | 2089317.43063 | 37.7164210557753 | -122.468844858002 | (37.7164210557753, -122.468844858002) | 9 | 8 | 6 | 64 | 24 | |||
| 106618 | 203641 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 608 Garfield St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992400.09934 | 2090515.70507 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | 9 | 8 | 6 | 64 | 24 | |||
| 1353 | 203642 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 349x Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 5993150.97673 | 2103877.75625 | 37.7564537210662 | -122.466690296437 | (37.7564537210662, -122.466690296437) | 1 | 8 | 4 | 56 | 12 | |||
| 47911 | 203643 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.472459222532 | (37.7417056300124, -122.472459222532) | 1 | 8 | 4 | 29491 | 40 | |||
| 166425 | 203644 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2450 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991098.76282 | 2098712.81343 | 37.7421534852088 | -122.473410796988 | (37.7421534852088, -122.473410796988) | 1 | 8 | 4 | 29491 | 40 | |||
| 93567 | 203645 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991098.28096 | 2098726.3101 | 37.7421905156936 | -122.473413447294 | (37.7421905156936, -122.473413447294) | 1 | 8 | 4 | 29491 | 40 | |||
| 69322 | 203646 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | 1 | 8 | 4 | 29491 | 40 | |||
| 16365 | 203647 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993596.72892 | 2093377.09996 | 37.7276472749004 | -122.464386369131 | (37.7276472749004, -122.464386369131) | 9 | 8 | 4 | 59 | 40 | |||
| 185889 | 203648 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1907 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993437.25696 | 2102479.71785 | 37.7526315852957 | -122.46559868313 | (37.7526315852957, -122.46559868313) | 1 | 8 | 4 | 29491 | 12 | |||
| 169134 | 203649 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993852.26622 | 2094804.86637 | 37.7315822980634 | -122.463606558022 | (37.7315822980634, -122.463606558022) | 9 | 8 | 4 | 59 | 40 | |||
| 8463 | 203650 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5993848.38247 | 2094813.02416 | 37.7316044735649 | -122.463620576647 | (37.7316044735649, -122.463620576647) | 9 | 8 | 4 | 59 | 40 | |||
| 43553 | 203651 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1390 Monterey Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993846.97887 | 2094818.60593 | 37.7316197188557 | -122.463625834087 | (37.7316197188557, -122.463625834087) | 9 | 8 | 4 | 59 | 40 | |||
| 142879 | 203652 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 400x Marietta Dr | 38 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 5999131.48243 | 2096996.51385 | 37.7379028188638 | -122.445512879233 | (37.7379028188638, -122.445512879233) | 9 | 7 | 4 | 59 | 40 |
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) );