trees
891 rows where qSpecies_id = 75
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43508 | 84892 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1699X Valencia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643 | 2099756 | 37.7459057132351 | -122.419737575743 | (37.7459057132351, -122.419737575743) | 2 | 7 | 7 | 28859 | 2 | |
43780 | 187954 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6014772.69279 | 2114599.27503 | 37.7871167070277 | -122.392664164317 | (37.7871167070277, -122.392664164317) | 6 | 2 | 9 | 28855 | 6 | |||
44124 | 187938 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 235 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6014012.10729 | 2114977.49045 | 37.7881129283138 | -122.395322147516 | (37.7881129283138, -122.395322147516) | 6 | 2 | 9 | 28855 | 6 | |||
44296 | 138174 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 900x DIVISADERO ST | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001486.0255 | 2111568.0498 | 37.7780468590079 | -122.438415769146 | (37.7780468590079, -122.438415769146) | 15 | 5 | 11 | 29490 | 41 | |||
44340 | 4154 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3718 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 6 | 3X3 | 6005698.24114 | 2100539.02617 | 37.748002458148 | -122.423060071381 | (37.748002458148, -122.423060071381) | 2 | 4 | 5 | 28859 | 19 | ||
44427 | 140559 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1165 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6003635.7523 | 2111746.192 | 37.7786580361961 | -122.430991815 | (37.7786580361961, -122.430991815) | 15 | 9 | 11 | 29492 | 41 | |||
44631 | 122582 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 2500X Lyon St | 2 | Median : Cutout | Tree | Private 2 | 6 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
44716 | 247508 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001724.0539 | 2109895.2534 | 37.7734673159842 | -122.437472525354 | (37.7734673159842, -122.437472525354) | 15 | 5 | 11 | 29492 | 10 | |||
46040 | 82635 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1363 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52502 | 6016495.7737 | 2093658.9613 | 37.7297145851124 | -122.385242953388 | (37.7297145851124, -122.385242953388) | 10 | 3 | 8 | 58 | 1 | |
46522 | 141324 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 600x DIVISADERO ST | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001611.1632 | 2110665.9521 | 37.7755770427913 | -122.437918243135 | (37.7755770427913, -122.437918243135) | 15 | 5 | 11 | 29492 | 10 | |||
46552 | 187907 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 167 Jessie St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012037.39416 | 2114599.46395 | 37.7869649329299 | -122.402127766205 | (37.7869649329299, -122.402127766205) | 12 | 2 | 9 | 28855 | 6 | |||
46554 | 244892 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001783.197 | 2109529.1582 | 37.7724654721109 | -122.437241723075 | (37.7724654721109, -122.437241723075) | 15 | 5 | 11 | 29492 | 9 | |||
46657 | 121543 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
47001 | 14652 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 655X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2008 12:00:00 AM | 3 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | ||
47087 | 220487 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 416 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6000636.08004 | 2101486.04738 | 37.7503157923525 | -122.440632691055 | (37.7503157923525, -122.440632691055) | 2 | 4 | 5 | 28862 | 22 | |||
47304 | 256005 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 302 Main St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6015252.9594 | 2115128.97629 | 37.7885978067978 | -122.391039570534 | (37.7885978067978, -122.391039570534) | 6 | 2 | 9 | 28855 | 6 | |||||
47342 | 203409 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993779.2225 | 2102246.74831 | 37.7520116286371 | -122.464399202454 | (37.7520116286371, -122.464399202454) | 1 | 8 | 4 | 29491 | 12 | |||
47347 | 138175 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 900x DIVISADERO ST | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001483.6566 | 2111580.5714 | 37.7780811054154 | -122.438424861346 | (37.7780811054154, -122.438424861346) | 15 | 5 | 11 | 29490 | 41 | |||
47368 | 256212 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 837 Broadway | 6 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009431 | 2118388 | 37.7972215096833 | -122.411413084134 | (37.7972215096833, -122.411413084134) | 3 | 1 | 10 | 308 | 4 | ||||
47438 | 107155 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 275 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015276.38031 | 2115978.63581 | 37.7909320761837 | -122.391017946268 | (37.7909320761837, -122.391017946268) | 6 | 2 | 9 | 28855 | 6 | ||||
47573 | 854 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 374 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008336.69687 | 2095197.29776 | 37.7334837823442 | -122.413558622435 | (37.7334837823442, -122.413558622435) | 10 | 7 | 7 | 28859 | 2 | ||
47592 | 48549 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 630(REVISED) 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45867 | 6011089.0530694 | 2108751.21155661 | 37.7708540159333 | -122.404996898488 | (37.7708540159333, -122.404996898488) | 14 | 2 | 9 | 28853 | 34 | |||
47707 | 254263 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 66 Lansing St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6014289.84402 | 2114150.25322 | 37.7858569681792 | -122.394303277683 | (37.7858569681792, -122.394303277683) | 6 | 2 | 9 | 28855 | 6 | ||||
48226 | 121547 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 318 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8x15 | 6015095 | 2115307 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | 6 | 2 | 9 | 28855 | 6 | ||||
48410 | 255900 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 660 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2007 12:00:00 AM | 3x3 | 6012744.76196 | 2111515.06694 | 37.7785353494244 | -122.399463794931 | (37.7785353494244, -122.399463794931) | 6 | 2 | 9 | 28856 | 34 | |||
49283 | 49391 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 522Walbridge Carter St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005169.44863 | 2086179.03953 | 37.7085432500485 | -122.423867667086 | (37.7085432500485, -122.423867667086) | 9 | 7 | 8 | 309 | 5 | |||
49339 | 187900 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Indiana St | 3 | : | Tree | Private 2 | 3 | Width 6ft | 6015174.13391 | 2101026.33165 | 37.7498706683925 | -122.390326583523 | (37.7498706683925, -122.390326583523) | 10 | 3 | 8 | 58 | 1 | |||
49706 | 125406 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2650 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001656.15712 | 2117548.20785 | 37.7944765158415 | -122.438255746918 | (37.7944765158415, -122.438255746918) | 13 | 9 | 1 | 57 | 27 | |||
49904 | 1124 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2463 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999036.51586 | 2088791.07267 | 37.715367165446 | -122.445251440001 | (37.715367165446, -122.445251440001) | 9 | 7 | 6 | 28861 | 25 | ||
49928 | 16382 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999194.33201 | 2088944.07211 | 37.7157962742582 | -122.444716950429 | (37.7157962742582, -122.444716950429) | 9 | 7 | 6 | 28861 | 25 | ||
50165 | 203399 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1898 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993788.70878 | 2102627.32377 | 37.7530571381766 | -122.464394026856 | (37.7530571381766, -122.464394026856) | 1 | 8 | 4 | 56 | 12 | |||
50503 | 50676 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 320 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 53102 | 6011983.41914 | 2112836.30852 | 37.7821207077455 | -122.402190501114 | (37.7821207077455, -122.402190501114) | 6 | 2 | 9 | 28853 | 34 | |
50737 | 220459 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1801 Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009533.63521 | 2106182.62398 | 37.7637141952672 | -122.410195770427 | (37.7637141952672, -122.410195770427) | 8 | 4 | 8 | 28859 | 19 | |||
50976 | 256196 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800 Broadway | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 6009530 | 2118420 | 37.797314926041 | -122.411072779375 | (37.797314926041, -122.411072779375) | 3 | 1 | 10 | 308 | 4 | ||||
51014 | 28663 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2826 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011313.9934641 | 2092464.2100287 | 37.7261460240505 | -122.40307302798 | (37.7261460240505, -122.40307302798) | 10 | 3 | 7 | 309 | 28 | |||
51018 | 671 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3300X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 4X4 | 6007057.4653098 | 2102078.7676165 | 37.7523068461089 | -122.418469082047 | (37.7523068461089, -122.418469082047) | 2 | 4 | 7 | 28859 | 19 | ||
51075 | 28683 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2961 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/2012 12:00:00 AM | 3 | 3X3 | 6011553.9607 | 2091855.0708 | 37.7244868510493 | -122.402200662543 | (37.7244868510493, -122.402200662543) | 10 | 3 | 7 | 309 | 28 | ||
51309 | 51960 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3953 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2005 12:00:00 AM | Permit Number 48181 | 6003479.49286747 | 2101832.63497006 | 37.7514289506507 | -122.43082471383 | (37.7514289506507, -122.43082471383) | 2 | 4 | 5 | 28862 | 22 | |||
52186 | 185222 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2507 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985796.7937 | 2098135.752 | 37.740260579141 | -122.491700620712 | (37.740260579141, -122.491700620712) | 1 | 8 | 3 | 29491 | 35 | |||
52317 | 88582 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 572 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51525 | 5988469.85698 | 2112085.5473 | 37.7787187988439 | -122.483480758311 | (37.7787187988439, -122.483480758311) | 11 | 6 | 2 | 55 | 26 | ||
52360 | 189059 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 925 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011015.17329 | 2109787.29138 | 37.7736947229667 | -122.405325426246 | (37.7736947229667, -122.405325426246) | 14 | 2 | 9 | 28853 | 34 | |||
52742 | 220464 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1900 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009491.00718 | 2105849.84781 | 37.7627980784028 | -122.410319710493 | (37.7627980784028, -122.410319710493) | 8 | 4 | 7 | 28859 | 19 | |||
52833 | 141981 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 961 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004347.2458 | 2111841.6916 | 37.7789605439257 | -122.428537292711 | (37.7789605439257, -122.428537292711) | 7 | 9 | 11 | 29490 | 41 | |||
53211 | 49231 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 500 Howard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.396155198 | (37.7885414925604, -122.396155198) | 12 | 2 | 9 | 28855 | 6 | |||
53217 | 100773 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
53294 | 220434 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2x Coso Ave | 8 | Median : Yard | Tree | DPW 1 | 6 | 6007135.32414 | 2099827.64271 | 37.746130149684 | -122.418040260776 | (37.746130149684, -122.418040260776) | 2 | 7 | 7 | 28859 | 2 | ||||
53359 | 247516 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 250x Divisadero St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001823.2223 | 2109176.3929 | 37.7714991415406 | -122.437078010881 | (37.7714991415406, -122.437078010881) | 15 | 5 | 11 | 29492 | 9 | |||
53511 | 87549 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2895 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 9x3 | 6011453.695353 | 2092165.767783 | 37.7253343637789 | -122.40256910651 | (37.7253343637789, -122.40256910651) | 10 | 3 | 7 | 309 | 28 | |||
53535 | 8240 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
54377 | 187896 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1701 Indiana St | 7 | : | Tree | Private 2 | 8 | Width 6ft | 6015200.42778 | 2100533.54912 | 37.7485190494227 | -122.390201234205 | (37.7485190494227, -122.390201234205) | 10 | 3 | 8 | 58 | 1 | |||
54484 | 220432 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1650 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006509.92654 | 2099814.31154 | 37.7460583262406 | -122.420201864026 | (37.7460583262406, -122.420201864026) | 2 | 7 | 7 | 28859 | 2 | |||
54520 | 203411 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993801.54167 | 2102222.78745 | 37.7519471247661 | -122.464320280662 | (37.7519471247661, -122.464320280662) | 1 | 8 | 4 | 29491 | 12 | |||
54765 | 203417 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993769.49059 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | 1 | 8 | 4 | 59 | 40 | |||
54975 | 189092 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1442 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016181.26551 | 2097468.21329 | 37.7401566215255 | -122.386595766675 | (37.7401566215255, -122.386595766675) | 10 | 3 | 8 | 58 | 1 | |||
55001 | 220414 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009485.69193 | 2106956.65454 | 37.7658368183492 | -122.410416250032 | (37.7658368183492, -122.410416250032) | 8 | 4 | 8 | 28853 | 19 | |||
55265 | 141617 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 700x DIVISADERO ST | 2 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6001580.3173 | 2110897.2965 | 37.7762105022711 | -122.43804152155 | (37.7762105022711, -122.43804152155) | 15 | 5 | 11 | 29492 | 10 | |||
55314 | 87432 | - 12 | Acer rubrum :: Red Maple 75 | 598X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||
55664 | 25478 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2451X Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2002 12:00:00 AM | 6 | 3X3 | 6009740.95146 | 2103104.50441 | 37.7552739931277 | -122.409261495344 | (37.7552739931277, -122.409261495344) | 2 | 4 | 7 | 28859 | 19 | ||
55989 | 137723 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800x DIVISADERO ST | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001529.3435 | 2111250.6101 | 37.7771777134961 | -122.438243170212 | (37.7771777134961, -122.438243170212) | 15 | 5 | 11 | 29492 | 41 | |||
56780 | 189071 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1157 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009822.97122 | 2108648.63961 | 37.7705015217488 | -122.40936908392 | (37.7705015217488, -122.40936908392) | 8 | 2 | 9 | 28853 | 34 | |||
57096 | 187870 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6015123.31698 | 2100924.59748 | 37.7495885088097 | -122.390495204594 | (37.7495885088097, -122.390495204594) | 10 | 3 | 8 | 58 | 1 | |||
57246 | 125407 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003635.60452 | 2117293.35447 | 37.7938891371273 | -122.431388416755 | (37.7938891371273, -122.431388416755) | 13 | 9 | 1 | 29490 | 27 | |||
57551 | 27452 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1635 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6X6 | 6015192.76909 | 2100696.51451 | 37.7489660934285 | -122.390239101956 | (37.7489660934285, -122.390239101956) | 10 | 3 | 8 | 58 | 1 | |||
57733 | 29065 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1001X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004375.703483 | 2111849.9138357 | 37.7789847305516 | -122.42843943238 | (37.7789847305516, -122.42843943238) | 7 | 9 | 11 | 29490 | 41 | ||
58024 | 87433 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 598X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||
58346 | 28686 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2955 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011473.964837 | 2092116.8636217 | 37.725201214644 | -122.402495599163 | (37.725201214644, -122.402495599163) | 10 | 3 | 7 | 309 | 28 | |||
58649 | 88170 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 360 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011731.58168 | 2112591.71808 | 37.781435059217 | -122.403044540485 | (37.781435059217, -122.403044540485) | 6 | 2 | 9 | 28853 | 34 | |
59081 | 28705 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3028 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2009 12:00:00 AM | 3 | 3X3 | 6011599.0463446 | 2091533.093888 | 37.7236052850781 | -122.402022182135 | (37.7236052850781, -122.402022182135) | 10 | 3 | 7 | 309 | 28 | ||
59653 | 220438 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2814 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6009797.76242 | 2100932.26628 | 37.749312693037 | -122.40891177146 | (37.749312693037, -122.40891177146) | 2 | 4 | 7 | 28859 | 19 | |||
59709 | 187893 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1701 Indiana St | 4 | : | Tree | Private 2 | 7 | Width 6ft | 6015205.08828 | 2100461.68616 | 37.7483219872815 | -122.390180098326 | (37.7483219872815, -122.390180098326) | 10 | 3 | 8 | 58 | 1 | |||
59756 | 24849 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2354 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2011 12:00:00 AM | 3 | 2x2 | 6010506.72758 | 2094990.75244 | 37.7330382644924 | -122.40604162653 | (37.7330382644924, -122.40604162653) | 10 | 3 | 7 | 309 | 28 | ||
59866 | 49372 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 522Walbridge Carter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 46344 | 6005157.82583 | 2086153.99564 | 37.7084738286642 | -122.42390605734 | (37.7084738286642, -122.42390605734) | 9 | 7 | 8 | 309 | 5 | |||
60056 | 247512 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001707.9488 | 2109975.7789 | 37.7736875032606 | -122.437534002868 | (37.7736875032606, -122.437534002868) | 15 | 5 | 11 | 29492 | 10 | |||
60082 | 29064 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1000X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 03/02/2006 12:00:00 AM | 3 | 3x3 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | ||
60187 | 115352 | Planning Code 138.1 required 2 | Acer rubrum :: Red Maple 75 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | 6 | 2 | 9 | 28855 | 6 | |
60353 | 187962 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | 14 | 2 | 9 | 28856 | 34 | |||
60408 | 220502 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 203 States St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001052.74554 | 2106320.20374 | 37.7636129298281 | -122.439538340217 | (37.7636129298281, -122.439538340217) | 15 | 5 | 5 | 28862 | 3 | |||
60610 | 189095 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1444 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016045.1574 | 2097570.04683 | 37.7404286997288 | -122.387073478453 | (37.7404286997288, -122.387073478453) | 10 | 3 | 8 | 58 | 1 | |||
60651 | 68389 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 122 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1993 12:00:00 AM | 1 | Permit Number 32216 | 6002009.36321 | 2093483.54875 | 37.7284208987036 | -122.43531143848 | (37.7284208987036, -122.43531143848) | 9 | 7 | 6 | 28861 | 25 | |
60826 | 25477 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2451X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009744.38857 | 2103075.41158 | 37.7551943032962 | -122.40924755585 | (37.7551943032962, -122.40924755585) | 2 | 4 | 7 | 28859 | 19 | ||
60979 | 2426 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2855 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3X3 | 6009874.24623 | 2100776.83629 | 37.748890200541 | -122.408636324408 | (37.748890200541, -122.408636324408) | 2 | 4 | 7 | 28859 | 19 | |||
61065 | 189076 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1047 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010179.59918 | 2108995.88933 | 37.7714749641405 | -122.408159994002 | (37.7714749641405, -122.408159994002) | 14 | 2 | 9 | 28853 | 34 | |||
61140 | 187881 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 17 | : | Tree | Private 2 | 3 | Width 3ft | 6015141.96127 | 2100582.57644 | 37.748650425082 | -122.390406837226 | (37.748650425082, -122.390406837226) | 10 | 3 | 8 | 58 | 1 | |||
61223 | 220430 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1401 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009429.13636 | 2107984.68576 | 37.7686563845084 | -122.410684471035 | (37.7686563845084, -122.410684471035) | 8 | 4 | 8 | 28853 | 19 | |||
61357 | 220445 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2501 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6009766.24645 | 2102672.6598 | 37.7540896615292 | -122.409143546541 | (37.7540896615292, -122.409143546541) | 2 | 4 | 7 | 28859 | 19 | |||
61532 | 8222 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1500X Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | ||
61751 | 116466 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
61965 | 187880 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 16 | : | Tree | Private 2 | 3 | Width 3ft | 6015140.70101 | 2100612.12131 | 37.7487314791912 | -122.390413259271 | (37.7487314791912, -122.390413259271) | 10 | 3 | 8 | 58 | 1 | |||
62005 | 100775 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
62038 | 138253 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1400x DIVISADERO ST | 4 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001241.1774 | 2113349.5021 | 37.7829243439965 | -122.439390513477 | (37.7829243439965, -122.439390513477) | 15 | 5 | 11 | 29490 | 41 | |||
62215 | 141319 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1300x DIVISADERO ST | 4 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001291.9406 | 2112967.0855 | 37.781877214323 | -122.439187476292 | (37.781877214323, -122.439187476292) | 15 | 5 | 11 | 29490 | 41 | |||
62245 | 220472 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 100 Alemany Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009413.9185 | 2095926.46105 | 37.7355463369948 | -122.409885800206 | (37.7355463369948, -122.409885800206) | 10 | 7 | 7 | 28859 | 2 | |||
62526 | 24880 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2473 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6010833.7586 | 2094203.8757 | 37.7308959524537 | -122.404855607729 | (37.7308959524537, -122.404855607729) | 10 | 3 | 7 | 309 | 28 | ||
62648 | 137714 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 800x DIVISADERO ST | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001518.8525 | 2111334.8771 | 37.777408492754 | -122.438285500218 | (37.777408492754, -122.438285500218) | 15 | 5 | 11 | 29492 | 41 | |||
63045 | 220415 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1601 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009485.58878 | 2106996.65951 | 37.7659466570249 | -122.410419431833 | (37.7659466570249, -122.410419431833) | 8 | 4 | 8 | 28853 | 19 | |||
63047 | 220408 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1340 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009370.35107 | 2108002.56697 | 37.7687021860891 | -122.410889068579 | (37.7687021860891, -122.410889068579) | 8 | 4 | 7 | 28853 | 19 | |||
63101 | 175144 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 199 Hamilton St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009113.082 | 2093674.90836 | 37.7293471914122 | -122.41076694875 | (37.7293471914122, -122.41076694875) | 9 | 3 | 7 | 309 | 28 | |||
63417 | 220476 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 849 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998017.46753 | 2107292.9322 | 37.7661105800595 | -122.450106480435 | (37.7661105800595, -122.450106480435) | 15 | 5 | 11 | 29492 | 9 | |||
63463 | 189060 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 670 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011065.32352 | 2108759.62205 | 37.7708757827119 | -122.405079572281 | (37.7708757827119, -122.405079572281) | 14 | 2 | 9 | 28853 | 34 |
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) );