trees
835 rows where qSpecies_id = 122 sorted by Neighborhoods (old)
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 | |||||||||||||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||||
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 | ||
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 | ||
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 | ||
1329 | 124750 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.7758081630602 | -122.42740756863 | (37.7758081630602, -122.42740756863) | 7 | 9 | 11 | 28852 | 10 | |||
1889 | 259158 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
4487 | 259159 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x | 6004817 | 2110376 | 37.7749626863145 | -122.426807815207 | (37.7749626863145, -122.426807815207) | 7 | 9 | 11 | 28852 | 10 | ||||
5685 | 245867 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.7751980841556 | -122.426098447818 | (37.7751980841556, -122.426098447818) | 7 | 9 | 11 | 28852 | 10 | |||
15560 | 261375 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | 7 | 9 | 11 | 28852 | 10 | ||||
20868 | 10688 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1221 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1991 12:00:00 AM | 6 | 3X3 | 6002001.6656 | 2110480.73 | 37.7750906677438 | -122.43655414222 | (37.7750906677438, -122.43655414222) | 15 | 5 | 11 | 29492 | 10 | ||
24848 | 63851 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724184 | (37.775063328726, -122.43667724184) | 15 | 5 | 11 | 29492 | 10 | ||
25315 | 33658 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 575 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37746 | 6004659.15076187 | 2110673.58419475 | 37.7757708537128 | -122.427375053318 | (37.7757708537128, -122.427375053318) | 7 | 9 | 11 | 28852 | 10 | |||
27101 | 52597 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 421@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2006 12:00:00 AM | Permit Number 48691 | 6005029.01915461 | 2110416.12997637 | 37.7750848587198 | -122.426077252438 | (37.7750848587198, -122.426077252438) | 7 | 9 | 11 | 28852 | 10 | ||
33995 | 245838 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 423 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005012.6195 | 2110528.7961 | 37.7753932855436 | -122.426142005084 | (37.7753932855436, -122.426142005084) | 7 | 9 | 11 | 28852 | 10 | |||
34029 | 10690 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6001959.267 | 2110474.8139 | 37.7750720141838 | -122.436700384498 | (37.7750720141838, -122.436700384498) | 15 | 5 | 11 | 29492 | 10 | |||
40042 | 220092 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 24 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006394.36568 | 2110096.52086 | 37.774284361671 | -122.421331508756 | (37.774284361671, -122.421331508756) | 7 | 9 | 11 | 28852 | 10 | |||
41217 | 67483 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 556 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 7 | Permit Number 31006 | 6002164.8912 | 2110413.7271 | 37.7749159685838 | -122.435984714323 | (37.7749159685838, -122.435984714323) | 15 | 5 | 11 | 29492 | 10 | |
46210 | 63850 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | 15 | 5 | 11 | 29492 | 10 | ||
55154 | 220686 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004903.16789 | 2110400.70337 | 37.7750353872943 | -122.426511501216 | (37.7750353872943, -122.426511501216) | 7 | 9 | 11 | 28852 | 10 | |||
60882 | 61342 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21247 | 6004909.43277367 | 2110408.16939621 | 37.7750562413416 | -122.426490361334 | (37.7750562413416, -122.426490361334) | 7 | 9 | 11 | 28852 | 10 | ||
62359 | 61344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21249 | 6004697.33191231 | 2110333.09347915 | 37.7748381087345 | -122.427218716009 | (37.7748381087345, -122.427218716009) | 7 | 9 | 11 | 28852 | 10 | ||
64962 | 66113 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | 7 | 9 | 11 | 29492 | 10 | ||
68287 | 245868 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 415 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005026.3603 | 2110433.2652 | 37.7751317575952 | -122.426087670118 | (37.7751317575952, -122.426087670118) | 7 | 9 | 11 | 28852 | 10 | |||
75189 | 245839 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 423 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005015.8911 | 2110507.8578 | 37.7753359789868 | -122.4261291969 | (37.7753359789868, -122.4261291969) | 7 | 9 | 11 | 28852 | 10 | |||
76417 | 66117 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.7760279254083 | -122.430248650411 | (37.7760279254083, -122.430248650411) | 7 | 9 | 11 | 29492 | 10 | ||
78673 | 51542 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50569 | 6005029.52693365 | 2110412.24682315 | 37.7750742252257 | -122.42607521942 | (37.7750742252257, -122.42607521942) | 7 | 9 | 11 | 28852 | 10 | ||
81881 | 33643 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 473 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37737 | 6005146.14820368 | 2110741.54826683 | 37.7759849973486 | -122.425695243602 | (37.7759849973486, -122.425695243602) | 7 | 9 | 11 | 28852 | 10 | |||
88289 | 220687 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 430 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004894.47532 | 2110399.44382 | 37.7750314374717 | -122.426541481018 | (37.7750314374717, -122.426541481018) | 7 | 9 | 11 | 28852 | 10 | |||
92759 | 52598 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 423@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2006 12:00:00 AM | Permit Number 48692 | 6005028.51137557 | 2110420.01312959 | 37.7750954922138 | -122.426079285457 | (37.7750954922138, -122.426079285457) | 7 | 9 | 11 | 28852 | 10 | |||
99912 | 220688 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | 7 | 9 | 11 | 28852 | 10 | |||
103337 | 69125 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 447 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | Permit Number 33148 | 6005264.64007943 | 2110758.08466494 | 37.7760370972093 | -122.425286525812 | (37.7760370972093, -122.425286525812) | 7 | 9 | 11 | 28852 | 10 | ||
111336 | 140717 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 556 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002162.097 | 2110427.6982 | 37.774954171002 | -122.435995379962 | (37.774954171002, -122.435995379962) | 15 | 5 | 11 | 29492 | 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 | |||
117664 | 66114 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29169 | 6003892.81016511 | 2110740.45474073 | 37.7759110923795 | -122.430030789321 | (37.7759110923795, -122.430030789321) | 7 | 9 | 11 | 29492 | 10 | ||
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 | |||
121595 | 140718 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 556 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002160.0013 | 2110449.3533 | 37.7750135114472 | -122.436004179308 | (37.7750135114472, -122.436004179308) | 15 | 5 | 11 | 29492 | 10 | |||
126725 | 61125 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 476 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 20976 | 6004690.15549132 | 2110384.59589639 | 37.7749791159526 | -122.427247210171 | (37.7749791159526, -122.427247210171) | 7 | 9 | 11 | 28852 | 10 | ||
128227 | 33633 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 282 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | Permit Number 37729 | 6006046.09364695 | 2110919.64612747 | 37.7765248233176 | -122.422594750669 | (37.7765248233176, -122.422594750669) | 7 | 9 | 11 | 28852 | 10 | ||
134394 | 140719 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 556 SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002157.9056 | 2110466.8172 | 37.7750613439019 | -122.436012678697 | (37.7750613439019, -122.436012678697) | 15 | 5 | 11 | 29492 | 10 | |||
151287 | 51453 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 427 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | Permit Number 47771 | 6004926.82550892 | 2110358.25622266 | 37.7749201751389 | -122.426426641342 | (37.7749201751389, -122.426426641342) | 7 | 9 | 11 | 28852 | 10 | |||
155053 | 220683 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 364 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004832.89357 | 2109879.94078 | 37.7736015271323 | -122.426717502624 | (37.7736015271323, -122.426717502624) | 7 | 9 | 11 | 28852 | 10 | |||
155174 | 245840 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 421 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005021.78 | 2110481.0306 | 37.775262650872 | -122.426106915566 | (37.775262650872, -122.426106915566) | 7 | 9 | 11 | 28852 | 10 | |||
157378 | 66111 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29166 | 6003876.46719342 | 2110790.67622638 | 37.776048062614 | -122.430090907355 | (37.776048062614, -122.430090907355) | 7 | 9 | 11 | 29492 | 10 | ||
158170 | 220685 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 452 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004772.24556 | 2110355.93232 | 37.7749050548484 | -122.426961200922 | (37.7749050548484, -122.426961200922) | 7 | 9 | 11 | 28852 | 10 | |||
160201 | 124751 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 566 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004689.62752 | 2110692.77739 | 37.7758252771447 | -122.427270993988 | (37.7758252771447, -122.427270993988) | 7 | 9 | 11 | 28852 | 10 | |||
173155 | 10631 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1990 12:00:00 AM | 18 | 3X3 | 6003873.4823 | 2110738.4269 | 37.7759044297862 | -122.430097504694 | (37.7759044297862, -122.430097504694) | 7 | 9 | 11 | 29492 | 10 | ||
175721 | 220684 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 452 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004755.35153 | 2110353.8827 | 37.7748984718146 | -122.427019494961 | (37.7748984718146, -122.427019494961) | 7 | 9 | 11 | 28852 | 10 | |||
176498 | 220665 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 215 Webster St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004174.50762 | 2109590.46036 | 37.7727694393 | -122.428974316228 | (37.7727694393, -122.428974316228) | 7 | 9 | 11 | 29492 | 10 | |||
185574 | 10632 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003878.786 | 2110787.057 | 37.7760382564385 | -122.430082627746 | (37.7760382564385, -122.430082627746) | 7 | 9 | 11 | 29492 | 10 | ||
187603 | 61341 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1985 12:00:00 AM | Permit Number 22558 | 6004883.03697194 | 2110411.47227967 | 37.7750638180483 | -122.426581905478 | (37.7750638180483, -122.426581905478) | 7 | 9 | 11 | 28852 | 10 | ||
189601 | 61340 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 441 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1984 12:00:00 AM | Permit Number 21245 | 6004862.65889815 | 2110356.13037945 | 37.7749107106258 | -122.426648455983 | (37.7749107106258, -122.426648455983) | 7 | 9 | 11 | 28852 | 10 | ||
193919 | 10634 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 830 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003840.507 | 2110782.2115 | 37.7760227838468 | -122.430214699132 | (37.7760227838468, -122.430214699132) | 7 | 9 | 11 | 29492 | 10 | ||
6622 | 124083 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3434 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5992631.55645 | 2110040.63137 | 37.7733453553708 | -122.468935093468 | (37.7733453553708, -122.468935093468) | 11 | 6 | 2 | 54 | 11 | |||
14481 | 123124 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 798 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2019 12:00:00 AM | 3 | Width 4ft | 5992601.67217 | 2110090.43708 | 37.773480381816 | -122.469042091828 | (37.773480381816, -122.469042091828) | 11 | 6 | 2 | 54 | 11 | ||
17237 | 123125 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 798 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2019 12:00:00 AM | 3 | Width 4ft | 5992603.0812 | 2110069.8115 | 37.7734238309341 | -122.469035716481 | (37.7734238309341, -122.469035716481) | 11 | 6 | 2 | 54 | 11 | ||
50159 | 98340 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
96296 | 67367 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 622 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30860 | 5991947.66141854 | 2111184.68459598 | 37.7764470789457 | -122.471384134831 | (37.7764470789457, -122.471384134831) | 11 | 6 | 2 | 54 | 11 | ||
107205 | 98339 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 3434 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992637 | 2110058.2 | 37.7733939086093 | -122.468917542393 | (37.7733939086093, -122.468917542393) | 11 | 6 | 2 | 54 | 11 | ||||
129086 | 43661 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 370 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43304 | 5992506.56767844 | 2112958.60482073 | 37.781350097045 | -122.46957990283 | (37.781350097045, -122.46957990283) | 11 | 6 | 2 | 54 | 11 | ||
182428 | 98341 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 790X 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | 11 | 6 | 2 | 54 | 11 | |||
942 | 67185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.7608734252807 | -122.449765371246 | (37.7608734252807, -122.449765371246) | 15 | 5 | 11 | 29492 | 12 | |
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 | |||
2542 | 32891 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.7603305839468 | -122.462923499947 | (37.7603305839468, -122.462923499947) | 1 | 5 | 4 | 56 | 12 | ||
18718 | 262041 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1550 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5993090.57371 | 2104919.01452 | 37.7593092592319 | -122.466974886903 | (37.7593092592319, -122.466974886903) | 1 | 8 | 4 | 56 | 12 | ||||
35036 | 215287 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.467353630083 | (37.7545548052666, -122.467353630083) | 1 | 8 | 4 | 56 | 12 |
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) );