trees
835 rows where qSpecies_id = 122 sorted by qSpecies_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
19365 | 75331 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5994458.53323 | 2086786.74836 | 37.7096013824613 | -122.460929674682 | (37.7096013824613, -122.460929674682) | 9 | 8 | 6 | 28861 | 25 | |||
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 | ||||
19723 | 103888 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999371.6507 | 2110859.3099 | 37.7759803474835 | -122.445679140757 | (37.7759803474835, -122.445679140757) | 15 | 5 | 11 | 29492 | 16 | |||
20170 | 137728 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999638.3271 | 2111189.948 | 37.7769034171043 | -122.444780412241 | (37.7769034171043, -122.444780412241) | 15 | 5 | 11 | 29492 | 16 | |||
20408 | 39701 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | 9 | 7 | 4 | 59 | 40 | ||
20429 | 220024 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4273 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002125.33793 | 2101175.24323 | 37.749547092337 | -122.435460513693 | (37.749547092337, -122.435460513693) | 2 | 4 | 5 | 28862 | 22 | |||
20553 | 68132 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1526 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1993 12:00:00 AM | 0 | Permit Number 31884 | 6000696.86081651 | 2113890.04393367 | 37.7843775414062 | -122.44131241544 | (37.7843775414062, -122.44131241544) | 15 | 6 | 11 | 29490 | 13 | |
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 | ||
20938 | 33356 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 200 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | Permit Number 37493 | 5994058.57591139 | 2093537.34847989 | 37.7281138896418 | -122.462801390817 | (37.7281138896418, -122.462801390817) | 9 | 8 | 4 | 59 | 40 | ||
20947 | 42897 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2016 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 7 | Permit Number 42813 | 5986657.8903 | 2096958.6583 | 37.737078880033 | -122.488636837876 | (37.737078880033, -122.488636837876) | 1 | 8 | 3 | 29491 | 35 | |
21427 | 49185 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 220 Palo Alto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46291 | 5997532.34805472 | 2103898.27952644 | 37.7567619489163 | -122.451539524782 | (37.7567619489163, -122.451539524782) | 15 | 5 | 4 | 63 | 38 | |||
21787 | 32344 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37068 | 5985179.95256355 | 2107022.76154853 | 37.7646257968319 | -122.494488338591 | (37.7646257968319, -122.494488338591) | 1 | 8 | 3 | 56 | 35 | ||
22337 | 43381 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 706 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43129 | 6001854.12345529 | 2102032.01903245 | 37.7518841875031 | -122.436459694241 | (37.7518841875031, -122.436459694241) | 2 | 4 | 5 | 28862 | 22 | ||
22663 | 50046 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46777 | 6002595.036724 | 2102416.46621438 | 37.7529818614653 | -122.433924992434 | (37.7529818614653, -122.433924992434) | 2 | 4 | 5 | 28862 | 22 |
22711 | 81348 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 561 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774387 | 6002774.12023878 | 2102081.98215915 | 37.7520736087499 | -122.433281789286 | (37.7520736087499, -122.433281789286) | 2 | 4 | 5 | 28862 | 22 | |
22960 | 54500 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.397179019096 | (37.760298732933, -122.397179019096) | 10 | 3 | 8 | 28856 | 29 | |
23139 | 188511 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 101 Pennsylvania Ave | 33 | Front Yard : Yard | Tree | Private 2 | 2 | 6014272.76615 | 2106665.73514 | 37.7653052137955 | -122.393838275126 | (37.7653052137955, -122.393838275126) | 14 | 3 | 8 | 310 | 29 | ||||
23190 | 188515 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1401 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6014455.23285 | 2101981.54762 | 37.7524535851846 | -122.392879417078 | (37.7524535851846, -122.392879417078) | 10 | 3 | 8 | 28856 | 1 | ||||
23452 | 85510 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Nebraska St | 4 | 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 | ||||
23876 | 60312 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 545 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | 10 | Permit Number 19882 | 5999669.64 | 2110412.2941 | 37.774769964844 | -122.444616185093 | (37.774769964844, -122.444616185093) | 15 | 5 | 11 | 29492 | 16 | ||
24178 | 50663 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1 Santa Ynez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.7237605529163 | -122.43875382021 | (37.7237605529163, -122.43875382021) | 9 | 7 | 6 | 28861 | 25 | ||||
24211 | 35786 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 580 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/1998 12:00:00 AM | Permit Number 39038 | 6002648.18507624 | 2102127.11023082 | 37.7521903746122 | -122.433720516444 | (37.7521903746122, -122.433720516444) | 2 | 4 | 5 | 28862 | 22 | |||
24313 | 36920 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 699 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39565 | 6001900 | 2102596 | 37.7534353511669 | -122.436341406283 | (37.7534353511669, -122.436341406283) | 2 | 4 | 5 | 28862 | 22 | ||
24531 | 43380 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 700 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43128 | 6001853.17321705 | 2102048.95584272 | 37.751930637944 | -122.436464192392 | (37.751930637944, -122.436464192392) | 2 | 4 | 5 | 28862 | 22 | ||
24541 | 43172 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 370 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 2 | Permit Number 42981 | 6005806.0739 | 2092004.68571 | 37.7245751476096 | -122.422080988441 | (37.7245751476096, -122.422080988441) | 9 | 7 | 7 | 309 | 5 | |
24732 | 219998 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005981.24616 | 2097649.70039 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
25189 | 251472 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589 | 2096875 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | 2 | 7 | 5 | 63 | 7 | |
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 | |||
25439 | 98708 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | 15 | 5 | 5 | 28862 | 3 | |||||
25580 | 117035 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
25803 | 35250 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.8006015626823 | -122.42238315977 | (37.8006015626823, -122.42238315977) | 13 | 9 | 1 | 28858 | 32 | |
26074 | 220045 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 160 Marview Way | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5998323.68704 | 2103258.27383 | 37.755049936933 | -122.448756699664 | (37.755049936933, -122.448756699664) | 1 | 5 | 4 | 63 | 38 | |||
26523 | 40816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1770 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | 8 | Permit Number 41760 | 6001593.7276 | 2114497.5525 | 37.7860966539785 | -122.438253110129 | (37.7860966539785, -122.438253110129) | 13 | 6 | 1 | 29490 | 27 | ||
26802 | 37051 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 364 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39656 | 6003583.41460965 | 2098669.49042288 | 37.7427495797017 | -122.430239695512 | (37.7427495797017, -122.430239695512) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
27399 | 39221 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1143 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41443 | 6005801.05573922 | 2102320.92573379 | 37.7529009461356 | -122.422831161336 | (37.7529009461356, -122.422831161336) | 2 | 4 | 5 | 28859 | 19 | ||
27735 | 38526 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199241 | -122.437330933595 | (37.797420199241, -122.437330933595) | 13 | 9 | 1 | 57 | 17 | ||
27905 | 220056 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6009277.43373 | 2100868.30065 | 37.7491078976199 | -122.410706569176 | (37.7491078976199, -122.410706569176) | 2 | 4 | 7 | 28859 | 19 | |||
27992 | 49579 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 400REVISED Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2003 12:00:00 AM | Permit Number 46462 | 6008204.64175087 | 2095122.01632245 | 37.7332696598424 | -122.414009852171 | (37.7332696598424, -122.414009852171) | 2 | 7 | 7 | 28859 | 2 | |||
28414 | 36508 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 584 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.7361990307601 | -122.415517981354 | (37.7361990307601, -122.415517981354) | 2 | 7 | 7 | 28859 | 2 | ||
28426 | 33399 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 300 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37517 | 5992600.35501271 | 2094892.48894855 | 37.7317506732587 | -122.467940993296 | (37.7317506732587, -122.467940993296) | 9 | 8 | 4 | 59 | 40 | ||
28491 | 220050 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006755.51813 | 2098027.45978 | 37.741165867704 | -122.419225908968 | (37.741165867704, -122.419225908968) | 2 | 7 | 7 | 28859 | 2 | |||
28674 | 220021 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001964.61353 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | 2 | 7 | 5 | 63 | 22 | |||
28804 | 44452 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 81 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2003 12:00:00 AM | 3 | Permit Number 43778 | 6002608.32736 | 2086901.11124 | 37.7103809831624 | -122.432770760164 | (37.7103809831624, -122.432770760164) | 9 | 7 | 6 | 28861 | 5 | ||
28963 | 203665 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 123 Detroit St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999403.44951 | 2093584.38933 | 37.7285494495997 | -122.444327421686 | (37.7285494495997, -122.444327421686) | 9 | 7 | 4 | 28861 | 40 | |||
29891 | 138357 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2499 Bush St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001830.9567 | 2114618.7351 | 37.7864428800724 | -122.437441043234 | (37.7864428800724, -122.437441043234) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
30127 | 68814 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 125 Brompton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32757 | 6002131.57604717 | 2095277.55167817 | 37.7333537609923 | -122.435017196532 | (37.7333537609923, -122.435017196532) | 9 | 7 | 5 | 63 | 40 | ||
30410 | 220059 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 3505 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006111.03304 | 2101975.99077 | 37.7519713192249 | -122.421734701821 | (37.7519713192249, -122.421734701821) | 2 | 4 | 5 | 28859 | 19 | |||
30776 | 67143 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 303 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30573 | 6006940.4062177 | 2097313.36453869 | 37.7392155318486 | -122.418536006241 | (37.7392155318486, -122.418536006241) | 2 | 7 | 7 | 28859 | 2 | ||
30880 | 220070 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 410 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003569.73703 | 2105814.1279 | 37.762366296796 | -122.43079674288 | (37.762366296796, -122.43079674288) | 15 | 4 | 5 | 28862 | 3 | |||
31049 | 66174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 70 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29247 | 6009314.15806324 | 2097044.09702117 | 37.7386095323365 | -122.410309598587 | (37.7386095323365, -122.410309598587) | 10 | 7 | 7 | 28859 | 2 | ||
32201 | 117042 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 2220x SUTTER ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001781 | 2114465 | 37.7860179225956 | -122.437602866759 | (37.7860179225956, -122.437602866759) | 13 | 6 | 1 | 29490 | 27 | ||||
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 | |
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 | |||
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 | ||
32895 | 109672 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994496 | 2090624 | 37.7201397218642 | -122.461078132621 | (37.7201397218642, -122.461078132621) | 9 | 8 | 6 | 28861 | 24 | ||||
32905 | 220062 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 430 College Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6005376.5701 | 2095055.52961 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | 2 | 7 | 7 | 28861 | 2 | |||
33013 | 51076 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 232 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 47538 | 6006664.07662334 | 2104758.9078781 | 37.7596437391075 | -122.420019665049 | (37.7596437391075, -122.420019665049) | 2 | 4 | 7 | 28859 | 19 | ||
33276 | 219990 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 151 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999384.54447 | 2107324.60583 | 37.766275682101 | -122.445380326357 | (37.766275682101, -122.445380326357) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |||
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 | |||
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 | |||
34736 | 35252 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.422525509838 | (37.8005900423666, -122.422525509838) | 13 | 9 | 1 | 28858 | 32 | |
35015 | 50381 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1330 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 6 | 3x3 | Permit Number 47040 | 6006481.85746 | 2119759.67415 | 37.8008219271496 | -122.421715351995 | (37.8008219271496, -122.421715351995) | 13 | 9 | 1 | 28858 | 32 | |
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 | ||
35567 | 23660 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 305 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006899.0385805 | 2098362.9679323 | 37.7420951798748 | -122.418753453583 | (37.7420951798748, -122.418753453583) | 2 | 7 | 7 | 28859 | 2 | |||
35601 | 39507 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 216 Jersey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 40959 | 6003716.05884842 | 2101601.85489178 | 37.7508086831914 | -122.429990180024 | (37.7508086831914, -122.429990180024) | 2 | 4 | 5 | 28862 | 22 | ||
36159 | 37832 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 19 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48867 | 6003860.1558 | 2090386.44981 | 37.7200218836872 | -122.42869247048 | (37.7200218836872, -122.42869247048) | 9 | 7 | 6 | 28861 | 5 |
36194 | 140102 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1720 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999455.5793 | 2110868.7857 | 37.7760111570338 | -122.445389492297 | (37.7760111570338, -122.445389492297) | 15 | 5 | 11 | 29492 | 16 | |||
36595 | 220077 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4160 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002637.75275 | 2104169.99099 | 37.7577990456928 | -122.433902601035 | (37.7577990456928, -122.433902601035) | 2 | 4 | 5 | 28862 | 3 | |||
36597 | 138344 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001758.896 | 2114311.2519 | 37.7855945128702 | -122.437668325433 | (37.7855945128702, -122.437668325433) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
36970 | 103889 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1750 Fulton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5999356.4217 | 2110857.6178 | 37.7759748319201 | -122.445731699945 | (37.7759748319201, -122.445731699945) | 15 | 5 | 11 | 29492 | 16 | |||
37100 | 105235 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 182X LOWER TER | 27 | Median : Cutout | Tree | Private 2 | 24 | 200x30 | 6000081 | 2106216 | 37.7632714588287 | -122.442891809215 | (37.7632714588287, -122.442891809215) | 15 | 5 | 5 | 28862 | 3 | |||
37421 | 37816 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003955.66683 | 2090537.19552 | 37.720441203374 | -122.428373060073 | (37.720441203374, -122.428373060073) | 9 | 7 | 6 | 28861 | 5 |
37455 | 220026 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | 2 | 4 | 5 | 28862 | 22 | |||
37537 | 32890 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 1515 06th Ave | 2 | 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 | ||
37768 | 43179 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 2299 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42985 | 6001635.1083 | 2114240.3384 | 37.7853927633961 | -122.438091512505 | (37.7853927633961, -122.438091512505) | 13 | 6 | 11 | 29490 | 13 |
37897 | 23663 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 311 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 12 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453897 | (37.7419584813283, -122.41861453897) | 2 | 7 | 7 | 28859 | 2 | |||
38389 | 220690 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 330 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003721.78604 | 2099258.64688 | 37.7443751038286 | -122.42980326002 | (37.7443751038286, -122.42980326002) | 2 | 7 | 5 | 63 | 22 | |||
38603 | 32274 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 623 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39911 | 6007825.97257693 | 2096019.31993336 | 37.7357121847697 | -122.415382520688 | (37.7357121847697, -122.415382520688) | 2 | 7 | 7 | 28859 | 2 | ||
39232 | 1377 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 65 Amethyst Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1998 12:00:00 AM | 3 | 1X1 | 5998937.99517 | 2100006.33795 | 37.7461560249957 | -122.44639832203 | (37.7461560249957, -122.44639832203) | 2 | 7 | 5 | 63 | 22 | ||
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 | |||
40096 | 32740 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 139 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37123 | 5995564.95354615 | 2088674.66529796 | 37.7148487646576 | -122.457242200681 | (37.7148487646576, -122.457242200681) | 9 | 8 | 6 | 28861 | 24 | ||
40817 | 120111 | Undocumented 4 | Acacia baileyana :: Bailey's Acacia 122 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6004952 | 2108176 | 37.7689296510264 | -122.426184162815 | (37.7689296510264, -122.426184162815) | 8 | 4 | 5 | 28853 | 19 | |||
41100 | 68174 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 449 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/1995 12:00:00 AM | Permit Number 31945 | 5997091.52876923 | 2111801.84543591 | 37.778437859612 | -122.45363471008 | (37.778437859612, -122.45363471008) | 15 | 6 | 2 | 54 | 16 | ||
41116 | 220668 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 680 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007462.21417 | 2105696.0479 | 37.7622618441433 | -122.417325709834 | (37.7622618441433, -122.417325709834) | 8 | 4 | 7 | 28859 | 19 | |||
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 | ||||
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 | |
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 | |||
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 | ||
41632 | 220030 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002251.88877 | 2102392.9278 | 37.7528977513337 | -122.435109978657 | (37.7528977513337, -122.435109978657) | 2 | 4 | 5 | 28862 | 22 | |||
41719 | 32347 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1201 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 10 | Permit Number 37068 | 5985187.3443 | 2106976.3651 | 37.7644988378034 | -122.494459352499 | (37.7644988378034, -122.494459352499) | 1 | 8 | 3 | 56 | 35 | |
41811 | 37853 | Permitted Site 7 | Acacia baileyana :: Bailey's Acacia 122 | 639 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40143 | 6003947.74961722 | 2091786.98448726 | 37.7238724004315 | -122.428489463759 | (37.7238724004315, -122.428489463759) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
42005 | 220095 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 5 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.434075672856 | (37.7364715774983, -122.434075672856) | 2 | 7 | 5 | 63 | 7 |
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) );