trees
6,344 rows where qSpecies_id = 19 sorted by Supervisor Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
337 | 193188 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 401 Harrison St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6014838.37703 | 2114321.79559 | 37.7863584598262 | -122.392417493778 | (37.7863584598262, -122.392417493778) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
1761 | 193283 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1628 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007524.2032 | 2108954.2313 | 37.7712115401103 | -122.417342217788 | (37.7712115401103, -122.417342217788) | 8 | 2 | 9 | 28853 | 19 | |||
2390 | 143239 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 986 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006984.4971 | 2114185.2189 | 37.7855441907656 | -122.41958028036 | (37.7855441907656, -122.41958028036) | 13 | 9 | 9 | 28858 | 36 | |||
2668 | 85700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010976.81813 | 2112473.48761 | 37.7810682491478 | -122.405647340366 | (37.7810682491478, -122.405647340366) | 14 | 2 | 9 | 28853 | 34 | ||
2938 | 193145 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 555 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013012.05406 | 2115204.53124 | 37.7886806595304 | -122.398798121635 | (37.7886806595304, -122.398798121635) | 12 | 2 | 9 | 28855 | 6 | |||
3063 | 192918 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009145.73706 | 2109144.68728 | 37.7718255855015 | -122.411746706156 | (37.7718255855015, -122.411746706156) | 8 | 2 | 9 | 28853 | 34 | |||
3248 | 85701 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010962.65697 | 2112458.52521 | 37.781026374014 | -122.405695276931 | (37.781026374014, -122.405695276931) | 14 | 2 | 9 | 28853 | 34 | ||
3340 | 192835 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 5 | : | Tree | Private 2 | 1 | Width 2ft | 6013082.87743 | 2113319.47205 | 37.7835086710412 | -122.398420759824 | (37.7835086710412, -122.398420759824) | 6 | 2 | 9 | 28856 | 6 | |||
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 | |||
4003 | 193246 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 843 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011569.59394 | 2112947.98567 | 37.7824042397005 | -122.40363001712 | (37.7824042397005, -122.40363001712) | 6 | 2 | 9 | 28853 | 34 | |||
4013 | 264857 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
4277 | 192886 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 7 | : | Tree | Private 2 | 9 | Width 3ft | 6012771.99776 | 2112717.29257 | 37.7818379024256 | -122.399453999917 | (37.7818379024256, -122.399453999917) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
4575 | 29055 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 400X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008920.1536798 | 2108682.7358637 | 37.7705445174102 | -122.412494357701 | (37.7705445174102, -122.412494357701) | 8 | 2 | 9 | 28853 | 19 | ||
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 | |||
4883 | 264808 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
4900 | 263589 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | Private | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | |||
5051 | 192939 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1559 Howard St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6007881.70364 | 2109409.76028 | 37.7724824224706 | -122.416137872687 | (37.7724824224706, -122.416137872687) | 8 | 2 | 9 | 28853 | 19 | |||
6085 | 82927 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1140 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6010031.8585 | 2110690.2274 | 37.7761189490017 | -122.40879059487 | (37.7761189490017, -122.40879059487) | 8 | 2 | 9 | 28853 | 34 | ||
6103 | 192898 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6012445.53716 | 2112672.64368 | 37.7816971054735 | -122.400580271289 | (37.7816971054735, -122.400580271289) | 6 | 2 | 9 | 28856 | 34 | |||
6342 | 264855 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
6531 | 192922 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 10th St | 6 | : | Tree | Private 2 | 2 | Width 3ft | 6009195.26787 | 2109094.7407 | 37.7716912222994 | -122.411571845561 | (37.7716912222994, -122.411571845561) | 8 | 2 | 9 | 28853 | 34 | |||
7141 | 264858 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
7326 | 98693 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 48713 | 6009268 | 2109041 | 37.7715477423488 | -122.411316462549 | (37.7715477423488, -122.411316462549) | 8 | 2 | 9 | 28853 | 34 | ||
7714 | 101793 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 795 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012464.9097 | 2112928.8888 | 37.7824017756076 | -122.400531256447 | (37.7824017756076, -122.400531256447) | 6 | 2 | 9 | 28856 | 34 | |||
7727 | 259597 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | ||||
7871 | 104619 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | MTA | 7 | 4x4 | Permit Number 770959 | 6012190.226 | 2112753.6665 | 37.7819053332353 | -122.401469228728 | (37.7819053332353, -122.401469228728) | 6 | 2 | 9 | 28853 | 34 | |
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 | |
8164 | 192896 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | |||
8419 | 85699 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 918 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010993.40445 | 2112488.15858 | 37.7811094596721 | -122.405590993329 | (37.7811094596721, -122.405590993329) | 14 | 2 | 9 | 28853 | 34 | ||
8654 | 142867 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1020 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006956.6744 | 2114391.9796 | 37.786110337763 | -122.41969121449 | (37.786110337763, -122.41969121449) | 13 | 9 | 9 | 28858 | 36 | |||
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 | |
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 | |||
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 | |||
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 | |||
9497 | 193189 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 401 Harrison St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014845.7191 | 2114331.63578 | 37.7863858864432 | -122.392392780401 | (37.7863858864432, -122.392392780401) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
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 | |||
10254 | 201218 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 687 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6013091.2306 | 2113527.2998 | 37.7840797833092 | -122.398406448239 | (37.7840797833092, -122.398406448239) | 6 | 2 | 9 | 28856 | 6 | |||
10748 | 92022 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 230 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2009 12:00:00 AM | 3x3 | Permit Number 770960 | 6011866.1 | 2113060.9 | 37.7827308344341 | -122.402612173234 | (37.7827308344341, -122.402612173234) | 6 | 2 | 9 | 28853 | 34 | ||
10931 | 193216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Brannan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6013216.14313 | 2111018.43297 | 37.7771979681544 | -122.397798251806 | (37.7771979681544, -122.397798251806) | 6 | 2 | 9 | 28856 | 34 | |||
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 | |||
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 | |
11447 | 49551 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2020 01:56:00 PM | 3 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.409068185146 | (37.7783593364429, -122.409068185146) | 14 | 2 | 9 | 28853 | 34 | ||
11883 | 259596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 345 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6012481.99467 | 2112636.57875 | 37.7816001127017 | -122.400451610675 | (37.7816001127017, -122.400451610675) | 6 | 2 | 9 | 28856 | 34 | ||||
12021 | 31607 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 5 Lucerne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1995 12:00:00 AM | 9 | Permit Number 35133 | 6012055.45942 | 2109792.65137 | 37.7737675473795 | -122.40172727021 | (37.7737675473795, -122.40172727021) | 14 | 2 | 9 | 28853 | 34 | ||
12170 | 70672 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 30 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6009676.94569 | 2110892.33688 | 37.7766540087164 | -122.410032610029 | (37.7766540087164, -122.410032610029) | 8 | 2 | 9 | 28853 | 34 | |||
12277 | 192906 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 347 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012463.27805 | 2112672.85325 | 37.7816986703036 | -122.400518910525 | (37.7816986703036, -122.400518910525) | 6 | 2 | 9 | 28856 | 34 | |||
12426 | 85702 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 926 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2020 12:00:00 AM | 3 | 3x3 | 6010947.05257 | 2112444.31834 | 37.7809864926601 | -122.405748259582 | (37.7809864926601, -122.405748259582) | 14 | 2 | 9 | 28853 | 34 | ||
12660 | 255643 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1122 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6010085.7211 | 2110745.2484 | 37.7762730405804 | -122.408608151117 | (37.7762730405804, -122.408608151117) | 8 | 2 | 9 | 28853 | 34 | ||||
12681 | 42027 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 49 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 11 | 3x3 | Permit Number 42349 | 6009766.86792 | 2110848.40858 | 37.7765384314298 | -122.409718439962 | (37.7765384314298, -122.409718439962) | 8 | 2 | 9 | 28853 | 34 |
12922 | 262080 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 320 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 4x4 | 6012356.2542 | 2112686.81 | 37.7817310231605 | -122.4008901457 | (37.7817310231605, -122.4008901457) | 6 | 2 | 9 | 28856 | 34 | |||
13201 | 67714 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 599 02ND ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1996 12:00:00 AM | Permit Number 31327 | 6014887 | 2112829 | 37.7822622831747 | -122.392144832206 | (37.7822622831747, -122.392144832206) | 6 | 2 | 9 | 28856 | 6 | ||
13283 | 192880 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Rizal St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012900.3156 | 2112837.75427 | 37.7821758137123 | -122.399018534684 | (37.7821758137123, -122.399018534684) | 6 | 2 | 9 | 28856 | 34 | |||
13440 | 264856 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007181 | 2113695 | 37.7842092359088 | -122.41886565636 | (37.7842092359088, -122.41886565636) | 7 | 9 | 9 | 28858 | 36 | ||||
13626 | 82968 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 75X Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 775675 | 6010000.91561265 | 2110652.98797709 | 37.7760149650505 | -122.408895007094 | (37.7760149650505, -122.408895007094) | 8 | 2 | 9 | 28853 | 34 | |
13766 | 52739 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 475@ STILLMAN 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | 3 | Permit Number 48788 | 6013048.0931 | 2112046.23235 | 37.7800107102631 | -122.398451730656 | (37.7800107102631, -122.398451730656) | 6 | 2 | 9 | 28856 | 34 | ||
14160 | 192815 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 666 Harrison St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6013604.81597 | 2113227.29521 | 37.7832846364215 | -122.396608578241 | (37.7832846364215, -122.396608578241) | 6 | 2 | 9 | 28856 | 6 | |||
14584 | 43091 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 146 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 2 | Permit Number 42926 | 6008599.48377 | 2113045.82808 | 37.7825065339989 | -122.413912252043 | (37.7825065339989, -122.413912252043) | 7 | 10 | 9 | 28852 | 36 | |
14816 | 45836 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 680 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2001 12:00:00 AM | Permit Number 44447 | 6012169.50994414 | 2114476.97613275 | 37.7866359833773 | -122.401662060279 | (37.7866359833773, -122.401662060279) | 12 | 2 | 9 | 28855 | 6 | |||
14834 | 263588 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 800 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012532 | 2112188 | 37.7803712075622 | -122.400247099708 | (37.7803712075622, -122.400247099708) | 6 | 2 | 9 | 28856 | 34 | ||||
15553 | 73555 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 315 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011765.85635 | 2112068.38095 | 37.7800000110193 | -122.402889147539 | (37.7800000110193, -122.402889147539) | 6 | 2 | 9 | 28856 | 34 | |||
16194 | 193176 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 284 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6014987.08887 | 2112807.40388 | 37.7822085418315 | -122.391797055984 | (37.7822085418315, -122.391797055984) | 6 | 2 | 9 | 28856 | 6 | |||
17083 | 66960 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1049 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 5 | Permit Number 30297 | 6010166.58935 | 2111603.96693 | 37.7786354094288 | -122.408388988373 | (37.7786354094288, -122.408388988373) | 14 | 2 | 9 | 28853 | 34 | |
17140 | 82928 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1140 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 775675 | 6010008.1126 | 2110668.219 | 37.776057189012 | -122.408871185552 | (37.776057189012, -122.408871185552) | 8 | 2 | 9 | 28853 | 34 | |
17317 | 264807 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
17654 | 192866 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Bonifacio St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012577.4953 | 2112746.88061 | 37.7819083013788 | -122.400128970773 | (37.7819083013788, -122.400128970773) | 6 | 2 | 9 | 28856 | 34 | |||
17737 | 192824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 362 03rd St | 2 | : | Tree | Private 2 | 8 | Width 4ft | 6013311.51298 | 2113082.94966 | 37.7828719690123 | -122.397613169532 | (37.7828719690123, -122.397613169532) | 6 | 2 | 9 | 28856 | 6 | |||
18436 | 201176 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 600 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6013524.1229 | 2114027.0282 | 37.7854760275445 | -122.396943835605 | (37.7854760275445, -122.396943835605) | 6 | 2 | 9 | 28855 | 6 | |||
18489 | 70673 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 32-34 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6009696.99241 | 2110873.64198 | 37.7766038004599 | -122.409961942206 | (37.7766038004599, -122.409961942206) | 8 | 2 | 9 | 28853 | 34 | |||
18534 | 88746 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 986 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51679 | 6006977.45504 | 2114231.90086 | 37.7856719713322 | -122.419607957142 | (37.7856719713322, -122.419607957142) | 13 | 9 | 9 | 28858 | 36 | |
18634 | 65446 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 563 02nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 7 | Permit Number 31326 | 6014757.61987 | 2112880.29542 | 37.7823959443489 | -122.392596022687 | (37.7823959443489, -122.392596022687) | 6 | 2 | 9 | 28856 | 6 | |
19622 | 264806 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 801x Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012291 | 2112706 | 37.7817800743931 | -122.401117244746 | (37.7817800743931, -122.401117244746) | 6 | 2 | 9 | 28856 | 34 | ||||
20419 | 85704 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 938 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010866.4915 | 2112368.00991 | 37.7807724621315 | -122.406021584247 | (37.7807724621315, -122.406021584247) | 14 | 2 | 9 | 28853 | 34 | ||
20528 | 192852 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 712 Harrison St | 3 | : | Tree | Private 2 | 11 | Width 4ft | 6013259.76509 | 2112901.11062 | 37.7823697992588 | -122.397779437985 | (37.7823697992588, -122.397779437985) | 6 | 2 | 9 | 28856 | 34 | |||
20772 | 29051 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 298 11th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6008408.15314 | 2109193.10509 | 37.7719171248036 | -122.414301493932 | (37.7719171248036, -122.414301493932) | 8 | 2 | 9 | 28853 | 19 | ||
21050 | 108053 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773596 | 6013147.88136 | 2115333.7249 | 37.789042962211 | -122.398337244289 | (37.789042962211, -122.398337244289) | 12 | 2 | 9 | 28855 | 6 | |
21151 | 192843 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 360 03rd St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6013195.7856 | 2113103.52845 | 37.782922028866 | -122.398014984804 | (37.782922028866, -122.398014984804) | 6 | 2 | 9 | 28856 | 34 | |||
21323 | 85705 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 938 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010851.34827 | 2112352.58315 | 37.780729256891 | -122.406072885158 | (37.780729256891, -122.406072885158) | 14 | 2 | 9 | 28853 | 34 | ||
21330 | 33784 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/1996 12:00:00 AM | Permit Number 37821 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |||
21434 | 192883 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2 Rizal St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6012844.29072 | 2112783.62554 | 37.7820240665994 | -122.399208556033 | (37.7820240665994, -122.399208556033) | 6 | 2 | 9 | 28856 | 34 | |||
21540 | 33778 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 77 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013804.30364325 | 2116217.11127164 | 37.7915050790356 | -122.396128026757 | (37.7915050790356, -122.396128026757) | 12 | 2 | 9 | 28855 | 6 | |
22029 | 201221 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 683 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6013138.53 | 2113570.4862 | 37.7842009979454 | -122.398245839288 | (37.7842009979454, -122.398245839288) | 6 | 2 | 9 | 28856 | 6 | |||
22174 | 33799 | Property Tree 8 | Magnolia grandiflora :: Southern Magnolia 19 | 200x Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138 | 2116340 | 37.7918610639158 | -122.394982044679 | (37.7918610639158, -122.394982044679) | 12 | 2 | 9 | 28855 | 6 | |
22423 | 193187 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 401 Harrison St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6014814.4343 | 2114294.15254 | 37.786281228753 | -122.392498395892 | (37.786281228753, -122.392498395892) | 6 | 2 | 9 | 28855 | 6 | |||
23026 | 98687 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 360 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 48713 | 6009130 | 2109185 | 37.7719353919897 | -122.411803990978 | (37.7719353919897, -122.411803990978) | 8 | 2 | 9 | 28853 | 34 | ||
23649 | 85851 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1630X Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6007563.871097 | 2108998.262092 | 37.771334669982 | -122.417208125188 | (37.771334669982, -122.417208125188) | 8 | 2 | 9 | 28853 | 19 | ||
23756 | 192946 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 251 11th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008468.79915 | 2109228.50432 | 37.7720177292585 | -122.414094219087 | (37.7720177292585, -122.414094219087) | 8 | 2 | 9 | 28853 | 34 | |||
24061 | 193245 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 857 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011458.89887 | 2112842.39585 | 37.7821081307177 | -122.404005542516 | (37.7821081307177, -122.404005542516) | 6 | 2 | 9 | 28853 | 34 | |||
24358 | 192926 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 355 11th St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6008735.42255 | 2108959.44166 | 37.7712939180009 | -122.4131529158 | (37.7712939180009, -122.4131529158) | 8 | 2 | 9 | 28853 | 34 | |||
24496 | 28890 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 425 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6012725.8387007 | 2112364.652974 | 37.7808670625803 | -122.399588923331 | (37.7808670625803, -122.399588923331) | 6 | 2 | 9 | 28856 | 34 | ||
24784 | 111136 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6011714.08738 | 2112122.07313 | 37.7801445464617 | -122.403072018382 | (37.7801445464617, -122.403072018382) | 6 | 2 | 9 | 28856 | 34 | |||
24994 | 142774 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 900 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6007004.1366 | 2114052.4702 | 37.7851808015429 | -122.419502911936 | (37.7851808015429, -122.419502911936) | 13 | 9 | 9 | 28858 | 36 | |||
25323 | 192925 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1418 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009207.52245 | 2109027.05906 | 37.7715060716816 | -122.411524673438 | (37.7715060716816, -122.411524673438) | 8 | 2 | 9 | 28853 | 34 | |||
25449 | 193268 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1328 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008686.02741 | 2110280.79098 | 37.7749192596395 | -122.413417239129 | (37.7749192596395, -122.413417239129) | 8 | 2 | 9 | 28853 | 34 | |||
25725 | 192834 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 4 | : | Tree | Private 2 | 10 | Width 2ft | 6013085.07263 | 2113314.8696 | 37.7834961560649 | -122.398412842187 | (37.7834961560649, -122.398412842187) | 6 | 2 | 9 | 28856 | 6 | |||
26060 | 192839 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 333 03rd St | 9 | : | Tree | Private 2 | 13 | Width 2ft | 6013010.639 | 2113396.71282 | 37.7837167318802 | -122.398676100719 | (37.7837167318802, -122.398676100719) | 6 | 2 | 9 | 28856 | 6 | |||
26237 | 85710 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1076 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6010030.29241 | 2111566.1673 | 37.7785239870252 | -122.408857826542 | (37.7785239870252, -122.408857826542) | 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) );