trees
6,344 rows where qSpecies_id = 19 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76 | 34164 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2500 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38230 | 6001594.91074 | 2117340.13182 | 37.7939017096586 | -122.438452751501 | (37.7939017096586, -122.438452751501) | 13 | 9 | 1 | 57 | 27 | ||
382 | 34903 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
527 | 32100 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 10 | Permit Number 35473 | 6002658.19542 | 2104999.95129 | 37.7600790771166 | -122.433891224619 | (37.7600790771166, -122.433891224619) | 2 | 4 | 5 | 28862 | 3 | |
719 | 80747 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001772.74556 | 2087054.04067 | 37.7107534679609 | -122.435669635744 | (37.7107534679609, -122.435669635744) | 9 | 7 | 6 | 28861 | 5 | |||
745 | 43286 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1200 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 13 | Permit Number 43056 | 6013973.47383 | 2105741.62866 | 37.7627511832352 | -122.394808740727 | (37.7627511832352, -122.394808740727) | 14 | 3 | 8 | 28856 | 29 | |
1025 | 55220 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 151 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1984 12:00:00 AM | 3 | Permit Number 21451 | 5989581.42537 | 2114369.00761 | 37.7850531755237 | -122.479802589294 | (37.7850531755237, -122.479802589294) | 11 | 6 | 2 | 55 | 26 | |
1118 | 36625 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
1509 | 78622 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008370.1442 | 2114331.41346 | 37.7860235585803 | -122.414796682248 | (37.7860235585803, -122.414796682248) | 13 | 10 | 9 | 28858 | 36 | |||
1624 | 70261 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3828 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5996527.35216 | 2114976.82048 | 37.7871231398678 | -122.455815970326 | (37.7871231398678, -122.455815970326) | 11 | 6 | 1 | 54 | 31 | |||
2006 | 50719 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2279 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 5 | Permit Number 47272 | 5988534.5082 | 2099828.4885 | 37.7450680122132 | -122.482358807669 | (37.7450680122132, -122.482358807669) | 1 | 8 | 3 | 29491 | 35 | |
2140 | 46192 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
2253 | 71688 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1930 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5998564.1414 | 2110396.2631 | 37.774662803409 | -122.448439160727 | (37.774662803409, -122.448439160727) | 15 | 5 | 11 | 29492 | 16 | |||
2992 | 187489 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Velasco Ave | 5 | Front Yard : Yard | Tree | Private 2 | 3 | 6006684.44019 | 2086612.84014 | 37.7098197873211 | -122.418662398253 | (37.7098197873211, -122.418662398253) | 9 | 7 | 8 | 309 | 39 | ||||
3137 | 66513 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1411 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/1991 12:00:00 AM | 4 | Permit Number 29678 | 6006713.5616 | 2115771.7123 | 37.7898850457115 | -122.420630301385 | (37.7898850457115, -122.420630301385) | 13 | 9 | 10 | 28858 | 21 | |
3365 | 46090 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 100 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | Permit Number 44465 | 5989930.31260509 | 2114699.05014668 | 37.7859796419382 | -122.478619707642 | (37.7859796419382, -122.478619707642) | 11 | 6 | 2 | 55 | 26 | |||
3497 | 46195 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3531 | 39973 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
3633 | 46628 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1426 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 0 | Permit Number 44749 | 6016155.81653285 | 2095029.68224774 | 37.7334594988152 | -122.386513771605 | (37.7334594988152, -122.386513771605) | 10 | 3 | 8 | 58 | 1 | |
3769 | 39565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 7 | Permit Number 40986 | 6011421.0186 | 2106801.06955 | 37.765517919653 | -122.403711377001 | (37.765517919653, -122.403711377001) | 8 | 3 | 8 | 28853 | 20 | |
3892 | 39976 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
3961 | 79969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009151.65519 | 2110631.00796 | 37.7759070057295 | -122.411831280182 | (37.7759070057295, -122.411831280182) | 8 | 2 | 9 | 28853 | 34 | |||
4030 | 65762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3002 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 13 | Permit Number 28725 | 6003868.45772 | 2119096.10509 | 37.7988522212082 | -122.43071142781 | (37.7988522212082, -122.43071142781) | 13 | 9 | 1 | 57 | 17 | |
4058 | 34900 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
4068 | 38625 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1396 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40563 | 6016053.9414 | 2093366.9092 | 37.7288882156246 | -122.386750071292 | (37.7288882156246, -122.386750071292) | 10 | 3 | 8 | 58 | 1 | |
4127 | 74230 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 1011 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/1996 12:00:00 AM | 10 | 6011143.4423 | 2118449.9882 | 37.7974876128867 | -122.405491940883 | (37.7974876128867, -122.405491940883) | 3 | 1 | 10 | 308 | 23 | ||
4219 | 71431 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010229.3071 | 2121323.3934 | 37.8053261203342 | -122.408857935135 | (37.8053261203342, -122.408857935135) | 3 | 1 | 10 | 308 | 23 | |||
4332 | 30435 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3229 Barker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | Permit Number 88 | |||||||||||||
4390 | 61550 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 933 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 8 | Permit Number 21508 | 6012798.10137 | 2103191.73514 | 37.7556843132942 | -122.398695011666 | (37.7556843132942, -122.398695011666) | 10 | 3 | 8 | 28856 | 29 | |
4423 | 78598 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008370.91308 | 2114317.13439 | 37.785984394913 | -122.414793011197 | (37.785984394913, -122.414793011197) | 13 | 10 | 9 | 28858 | 36 | |||
4505 | 59850 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 4 | Permit Number 19305 | 6016629.87582 | 2093981.66592 | 37.7306080858771 | -122.384801815251 | (37.7306080858771, -122.384801815251) | 10 | 3 | 8 | 58 | 1 | |
4550 | 60389 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1458 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 5 | Permit Number 19969 | 6015669.4777 | 2094699.9194 | 37.7325271015793 | -122.388172191813 | (37.7325271015793, -122.388172191813) | 10 | 3 | 8 | 58 | 1 | |
4673 | 60356 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 4 | Permit Number 19934 | 6016682.1383 | 2093866.4324 | 37.7302945678233 | -122.384613110545 | (37.7302945678233, -122.384613110545) | 10 | 3 | 8 | 58 | 1 | ||
4708 | 65963 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2658 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 9 | Permit Number 28985 | 5989288.4886 | 2097252.0638 | 37.7380376514495 | -122.479563236125 | (37.7380376514495, -122.479563236125) | 1 | 8 | 3 | 29491 | 35 | |
4855 | 76107 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Rausch St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009843.66078 | 2110720.8424 | 37.7761924676323 | -122.409443785198 | (37.7761924676323, -122.409443785198) | 8 | 2 | 9 | 28853 | 34 | |||
4959 | 47411 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45322 | |||||||||||||
4969 | 36620 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
5270 | 80931 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1111 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001747.57084 | 2087049.21095 | 37.710738776642 | -122.435756299834 | (37.710738776642, -122.435756299834) | 9 | 7 | 6 | 28861 | 5 | |||
5437 | 44085 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 363 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | 7 | Permit Number 45154 | 5986819.42477 | 2113508.89753 | 37.7825307151502 | -122.489294848866 | (37.7825307151502, -122.489294848866) | 11 | 6 | 2 | 55 | 26 | |
5932 | 70322 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 212 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997855.1178 | 2109822.7379 | 37.7730474875653 | -122.45085044117 | (37.7730474875653, -122.45085044117) | 15 | 5 | 11 | 29492 | 16 | |||
6063 | 69315 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1518 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1994 12:00:00 AM | 7 | Permit Number 33394 | 5986230.6468 | 2104875.9024 | 37.7587925526495 | -122.490696346344 | (37.7587925526495, -122.490696346344) | 1 | 8 | 3 | 56 | 35 | |
6116 | 38816 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 211 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | 4 | Permit Number 40652 | 5994893.15717 | 2114075.07126 | 37.7845532569028 | -122.461404489499 | (37.7845532569028, -122.461404489499) | 11 | 6 | 2 | 54 | 11 | |
6152 | 68969 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3343 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 9 | Permit Number 32959 | 5999787.27845 | 2120075.09917 | 37.8013082157737 | -122.44490400674 | (37.8013082157737, -122.44490400674) | 13 | 9 | 1 | 57 | 17 | |
6196 | 33080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 221 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37335 | |||||||||||||
6252 | 70020 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 700 Central Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5999648.4798 | 2110952.3759 | 37.7762516842269 | -122.444728210696 | (37.7762516842269, -122.444728210696) | 15 | 5 | 11 | 29492 | 16 | |||
6574 | 65759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3016 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 13 | Permit Number 28722 | 6003857.62455 | 2119183.89761 | 37.7990926630433 | -122.430755182511 | (37.7990926630433, -122.430755182511) | 13 | 9 | 1 | 57 | 17 | |
6588 | 46352 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2002 12:00:00 AM | 13 | Permit Number 44595 | 6000732.4975 | 2116220.35681 | 37.7907780071577 | -122.441356390798 | (37.7907780071577, -122.441356390798) | 13 | 6 | 1 | 29490 | 27 | ||
6719 | 72384 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 592 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010697.2489 | 2118956.7107 | 37.7988539907437 | -122.407071630807 | (37.7988539907437, -122.407071630807) | 3 | 1 | 10 | 308 | 23 | |||
6736 | 53162 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1123@ HAWES Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 1 | Permit Number 49083 | 6014891.3438 | 2089966.2272 | 37.71948618255 | -122.390531758785 | (37.71948618255, -122.390531758785) | 10 | 3 | 8 | 58 | 1 | |
7062 | 60350 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19928 | 6017464.7861 | 2093286.0419 | 37.7287441803863 | -122.381867009636 | (37.7287441803863, -122.381867009636) | 10 | 3 | 8 | 58 | 1 | |
7277 | 71773 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1207 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6007676.74747 | 2115431.38608 | 37.7890048300542 | -122.417273630072 | (37.7890048300542, -122.417273630072) | 13 | 1 | 10 | 28858 | 21 | |||
7409 | 79285 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2722 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994906.63121 | 2110258.22071 | 37.7740739800962 | -122.46108112387 | (37.7740739800962, -122.46108112387) | 11 | 6 | 2 | 54 | 11 | |||
7452 | 60592 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 613 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1982 12:00:00 AM | 10 | Permit Number 20211 | 6000545.2975 | 2111100.6046 | 37.7767098193279 | -122.44163652073 | (37.7767098193279, -122.44163652073) | 15 | 5 | 11 | 29492 | 16 | |
7550 | 71272 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2477 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6000730.11 | 2114120.4408 | 37.785012045879 | -122.441213921365 | (37.785012045879, -122.441213921365) | 15 | 6 | 11 | 29490 | 13 | |||
7649 | 39891 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1550 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41175 | 6005174.09555111 | 2114787.61295618 | 37.7870960726836 | -122.425886638993 | (37.7870960726836, -122.425886638993) | 13 | 9 | 11 | 28858 | 27 | |||
7772 | 74841 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 200 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6011912.74207 | 2119472.92585 | 37.800339337445 | -122.402901928701 | (37.800339337445, -122.402901928701) | 3 | 1 | 10 | 308 | 23 | |||
7798 | 52068 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2005 12:00:00 AM | Permit Number 48263 | 6002387.64911421 | 2104013.98805982 | 37.7573565030376 | -122.434756406645 | (37.7573565030376, -122.434756406645) | 2 | 4 | 5 | 28862 | 3 | |||
7815 | 78721 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 115 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008722.75942 | 2087395.11673 | 37.7120823080297 | -122.411672802567 | (37.7120823080297, -122.411672802567) | 9 | 7 | 8 | 309 | 39 | |||
8073 | 64439 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1988 12:00:00 AM | 15 | Permit Number 25301 | 6009724.66306 | 2110846.10571 | 37.7765297431014 | -122.409864276736 | (37.7765297431014, -122.409864276736) | 8 | 2 | 9 | 28853 | 34 | |
8081 | 39780 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 50 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41452 | 6006177.81610853 | 2102875.29261487 | 37.7544443606741 | -122.421567620452 | (37.7544443606741, -122.421567620452) | 2 | 4 | 5 | 28859 | 19 | ||
8096 | 59801 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1035 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1981 12:00:00 AM | 3 | Permit Number 19252 | 6008957.26664 | 2115956.46154 | 37.7905185185761 | -122.412880324992 | (37.7905185185761, -122.412880324992) | 5 | 1 | 10 | 28858 | 21 | |
8191 | 74104 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 189 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6006471.06973 | 2093054.28635 | 37.7274946077702 | -122.419856624186 | (37.7274946077702, -122.419856624186) | 9 | 7 | 7 | 309 | 5 | |||
8285 | 36624 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8615 | 81216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1490 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5989947.3486 | 2105228.4272 | 37.7599768999261 | -122.477868186468 | (37.7599768999261, -122.477868186468) | 1 | 8 | 3 | 56 | 35 | |||
8704 | 79435 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 606 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004044.7014 | 2110862.9754 | 37.7762561050616 | -122.429514097991 | (37.7762561050616, -122.429514097991) | 7 | 9 | 11 | 28852 | 10 | |||
8769 | 32194 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1995 12:00:00 AM | 2 | Permit Number 35521 | 6000876.834 | 2109176.6725 | 37.7714460698883 | -122.440351630177 | (37.7714460698883, -122.440351630177) | 15 | 5 | 11 | 29492 | 9 | |
8772 | 42026 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 6 | Permit Number 42349 | 6009754.59547 | 2110863.51813 | 37.776579230974 | -122.409761960854 | (37.776579230974, -122.409761960854) | 8 | 2 | 9 | 28853 | 34 | |
8825 | 36621 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8963 | 36618 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
8977 | 61589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 912 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 11 | Permit Number 21556 | 6012739.7847 | 2103229.26142 | 37.7557841029764 | -122.398899324171 | (37.7557841029764, -122.398899324171) | 10 | 3 | 8 | 28856 | 29 | |
8989 | 70675 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009740.45587 | 2110875.89947 | 37.7766124348397 | -122.409811748212 | (37.7766124348397, -122.409811748212) | 8 | 2 | 9 | 28853 | 34 | |||
9373 | 71806 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2567 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988291.4423 | 2097857.1501 | 37.7396410933419 | -122.483054814949 | (37.7396410933419, -122.483054814949) | 1 | 8 | 3 | 29491 | 35 | |||
9409 | 76076 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 60 Rausch St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009855.80512 | 2110709.84536 | 37.7761629527799 | -122.409400998174 | (37.7761629527799, -122.409400998174) | 8 | 2 | 9 | 28853 | 34 | |||
9421 | 50706 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 668 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2004 12:00:00 AM | 3 | Permit Number 47265 | 5990376.16513 | 2110779.50852 | 37.7752435440041 | -122.476790717818 | (37.7752435440041, -122.476790717818) | 11 | 6 | 2 | 55 | 26 | |
9422 | 80211 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008650.63461 | 2108952.54787 | 37.7712702289655 | -122.413445714359 | (37.7712702289655, -122.413445714359) | 8 | 2 | 9 | 28853 | 19 | |||
9484 | 71331 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 315 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011757.84173 | 2112077.6198 | 37.7800249312328 | -122.402917523848 | (37.7800249312328, -122.402917523848) | 6 | 2 | 9 | 28856 | 34 | |||
9503 | 109132 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 124 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6008117 | 2098031 | 37.7412521699945 | -122.414518628477 | (37.7412521699945, -122.414518628477) | 2 | 7 | 7 | 28859 | 2 | ||||
9593 | 70541 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1830 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6000327.1082 | 2111334.4422 | 37.777339444143 | -122.442408091617 | (37.777339444143, -122.442408091617) | 15 | 5 | 11 | 29490 | 16 | |||
9796 | 72145 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 350 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001088.11474 | 2092709.73665 | 37.72624382708 | -122.438440814794 | (37.72624382708, -122.438440814794) | 9 | 7 | 6 | 28861 | 25 | |||
9853 | 46194 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
9918 | 74256 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1126X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6009656.55619 | 2111209.09392 | 37.7775226063216 | -122.410125511783 | (37.7775226063216, -122.410125511783) | 8 | 2 | 9 | 28853 | 34 | |||
9972 | 71995 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5984088.02561 | 2113084.30818 | 37.7812050975324 | -122.498712783587 | (37.7812050975324, -122.498712783587) | 11 | 6 | 2 | 55 | 26 | |||
10003 | 264730 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 748 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2020 12:00:00 AM | 3 | 6002983.4557 | 2109619.25261 | 37.7727810060219 | -122.433096352422 | (37.7727810060219, -122.433096352422) | 15 | 5 | 11 | 29492 | 9 | |||
10046 | 48825 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 550 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 6 | Permit Number 46050 | 5988463.29715 | 2112242.22119 | 37.7791485995736 | -122.483514940107 | (37.7791485995736, -122.483514940107) | 11 | 6 | 2 | 55 | 26 | ||
10149 | 47738 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 765ST Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2002 12:00:00 AM | Permit Number 45522 | 6001007.50472324 | 2111284.16772448 | 37.7772401606319 | -122.440050778725 | (37.7772401606319, -122.440050778725) | 15 | 5 | 11 | 29492 | 41 | |||
10175 | 103130 | Section 806 (d) 5 | Magnolia grandiflora :: Southern Magnolia 19 | 418 28th Ave | 1 | : | Tree | Private 2 | 1 | 5987189.39247 | 2113118.19249 | 37.7814795396885 | -122.487986220863 | (37.7814795396885, -122.487986220863) | 11 | 6 | 2 | 55 | 26 | ||||
10244 | 82748 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434-1436 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008231.53118 | 2109847.29583 | 37.7737034553791 | -122.414958754439 | (37.7737034553791, -122.414958754439) | 8 | 2 | 9 | 28853 | 34 | |||
10262 | 71774 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007619.84868 | 2115422.03298 | 37.7889759474427 | -122.417469829771 | (37.7889759474427, -122.417469829771) | 13 | 1 | 10 | 28858 | 21 | |||
10274 | 39974 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 0 Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41235 | ||||||||||||||
10529 | 46191 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
10670 | 258171 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 100 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6008455.21796 | 2093605.41918 | 37.7291194808141 | -122.413036341511 | (37.7291194808141, -122.413036341511) | 9 | 3 | 7 | 309 | 28 | |||
10686 | 34901 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | Permit Number 38505 | ||||||||||||||
10845 | 30838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 235 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34709 | 6007559.44902 | 2097564.28674 | 37.739939339931 | -122.416413397076 | (37.739939339931, -122.416413397076) | 2 | 7 | 7 | 28859 | 2 | ||
10970 | 60364 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 4 | Permit Number 19942 | 6015971.722 | 2094398.676 | 37.7317166892309 | -122.387106247473 | (37.7317166892309, -122.387106247473) | 10 | 3 | 8 | 58 | 1 | |
10995 | 108012 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 419X Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773433 | 6005343.63147 | 2111122.79579 | 37.7770429674219 | -122.425039228843 | (37.7770429674219, -122.425039228843) | 7 | 9 | 11 | 28852 | 10 | ||
11013 | 60619 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 209 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20243 | 6004834.14454804 | 2097168.79499693 | 37.7386997741774 | -122.425808230058 | (37.7386997741774, -122.425808230058) | 2 | 7 | 5 | 63 | 7 | ||
11033 | 70684 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 90 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6010365.45358 | 2111155.37964 | 37.7774148279639 | -122.407669399445 | (37.7774148279639, -122.407669399445) | 14 | 2 | 9 | 28853 | 34 | |||
11043 | 73644 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1209 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007593.08329 | 2115418.15258 | 37.7889637868037 | -122.417562159565 | (37.7889637868037, -122.417562159565) | 13 | 1 | 10 | 28858 | 21 | |||
11199 | 73361 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 23 Huntington Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984617.03994 | 2094708.01424 | 37.730779908566 | -122.495526924733 | (37.730779908566, -122.495526924733) | 1 | 8 | 4 | 64 | 35 | |||
11218 | 38796 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 667 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | 5 | Permit Number 40643 | 6013179.6599 | 2113608.5314 | 37.7843077521892 | -122.398106213465 | (37.7843077521892, -122.398106213465) | 6 | 2 | 9 | 28856 | 6 | |
11241 | 30330 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2820 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1990 12:00:00 AM | 9 | Permit Number 28881 | 5999458.41568 | 2118085.66723 | 37.795826993587 | -122.445898848463 | (37.795826993587, -122.445898848463) | 13 | 9 | 1 | 57 | 17 |
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) );