trees
1,121 rows where qSpecies_id = 6 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51537 | 100491 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3978 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770312 | 5995766.62837 | 2114872.73446 | 37.7867936596919 | -122.458440353598 | (37.7867936596919, -122.458440353598) | 11 | 6 | 1 | 54 | 31 | |
| 54999 | 101252 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992716.9 | 2106688.9 | 37.7641473244126 | -122.468395985577 | (37.7641473244126, -122.468395985577) | 11 | 8 | 11 | 56 | 12 | ||||
| 425 | 10157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x7 | 6005745.76106 | 2103227.37374 | 37.7553867222415 | -122.423086804612 | (37.7553867222415, -122.423086804612) | 2 | 4 | 5 | 28859 | 19 | |||
| 13551 | 10193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6005736.25987 | 2102154.58599 | 37.7524405594089 | -122.423043415947 | (37.7524405594089, -122.423043415947) | 2 | 4 | 5 | 28859 | 19 | |||
| 19897 | 102064 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52559 | 6007929.8 | 2098099.2 | 37.7414289135067 | -122.415170728099 | (37.7414289135067, -122.415170728099) | 2 | 7 | 7 | 28859 | 2 | |
| 104233 | 102092 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 167721 | 102093 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 19 Stoneman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769735 | 6008292.3 | 2099391 | 37.7449962759915 | -122.414008688761 | (37.7449962759915, -122.414008688761) | 2 | 7 | 7 | 28859 | 2 | |
| 145480 | 102180 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769770 | 6001747.5 | 2103909.1 | 37.7570321415971 | -122.436962782195 | (37.7570321415971, -122.436962782195) | 2 | 4 | 5 | 28862 | 3 |
| 181931 | 102200 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769774 | 6002583.2 | 2103808 | 37.7568020093443 | -122.434065390673 | (37.7568020093443, -122.434065390673) | 2 | 4 | 5 | 28862 | 3 |
| 114382 | 102384 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
| 77162 | 102385 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 33 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 774895 | 6001524.4 | 2108057.6 | 37.7684102241102 | -122.438031497558 | (37.7684102241102, -122.438031497558) | 15 | 5 | 5 | 29492 | 3 | ||
| 177211 | 102935 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 801X Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | |||
| 91359 | 103118 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 443 Vernon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2013 12:00:00 AM | Permit Number 769638 | 5992399.1 | 2090786.9 | 37.72046611452 | -122.468338191478 | (37.72046611452, -122.468338191478) | 9 | 8 | 6 | 64 | 24 | |||
| 192443 | 104730 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 440X Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.54792 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | 1 | 8 | 4 | 29491 | 40 | |
| 179141 | 104731 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 440X Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.54792 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | 1 | 8 | 4 | 29491 | 40 | |
| 101005 | 104736 | Significant Tree 6 | Lagunaria patersonii :: Primrose Tree 6 | 1499X 44th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770763 | 5982473.05016 | 2105245.16297 | 37.7595862228156 | -122.503718978789 | (37.7595862228156, -122.503718978789) | 1 | 8 | 3 | 56 | 35 | ||||
| 92191 | 105012 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | 6 | 2 | 9 | 28856 | 34 | ||||
| 80264 | 105013 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | 6 | 2 | 9 | 28856 | 34 | ||||
| 136349 | 105014 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 330 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6013709.8 | 2110877.9 | 37.7768395752266 | -122.396080672132 | (37.7768395752266, -122.396080672132) | 6 | 2 | 9 | 28856 | 34 | ||||
| 111372 | 105757 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | 15 | 5 | 5 | 28862 | 3 | |
| 20319 | 106193 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638004 | -122.499011481047 | (37.742177638004, -122.499011481047) | 1 | 8 | 3 | 29491 | 35 | ||||
| 92547 | 106331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1651 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2015 05:38:00 PM | 3 | 3x3 | 5988118.12003 | 2098953.52216 | 37.7426413556222 | -122.483734446336 | (37.7426413556222, -122.483734446336) | 1 | 8 | 3 | 29491 | 35 | ||
| 149522 | 106431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | 8 | 2 | 9 | 28853 | 34 | |||
| 35535 | 106607 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 68252 | 106608 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1392 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/2014 12:00:00 AM | Permit Number 770777 | 5989327.7 | 2105878.6 | 37.7617261163081 | -122.480058809907 | (37.7617261163081, -122.480058809907) | 1 | 8 | 3 | 56 | 35 | ||
| 45123 | 107987 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 233 Laidley St | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | Permit Number 771182 | 6004231.95883 | 2097050.3446 | 37.7383404878499 | -122.427881865747 | (37.7383404878499, -122.427881865747) | 2 | 7 | 5 | 63 | 7 | |||
| 163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
| 2654 | 108556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) | 9 | 7 | 6 | 28861 | 25 |
| 108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 54619 | 108768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 134524 | 108772 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 37255 | 108775 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 174505 | 108825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
| 192015 | 108829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.74701 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | 10 | 3 | 8 | 309 | 1 | ||
| 91948 | 109136 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 635 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773405 | 5984096.47436 | 2111505.41074 | 37.7768703987748 | -122.498566890903 | (37.7768703987748, -122.498566890903) | 11 | 6 | 2 | 55 | 26 |
| 148517 | 109183 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 3013 | 109184 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 169615 | 109265 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1970 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773567 | 5983260 | 2101732.7 | 37.7499882212347 | -122.500737615767 | (37.7499882212347, -122.500737615767) | 1 | 8 | 3 | 29491 | 35 |
| 50370 | 109275 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1437 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773660 | 5984291.9 | 2105367.5 | 37.7600289003771 | -122.4974376175 | (37.7600289003771, -122.4974376175) | 1 | 8 | 3 | 56 | 35 |
| 186425 | 109577 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002290.3134 | 2092582.02308 | 37.72596146424 | -122.434275755847 | (37.72596146424, -122.434275755847) | 9 | 7 | 6 | 28861 | 25 |
| 93865 | 109578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.7260084870829 | -122.434372977031 | (37.7260084870829, -122.434372977031) | 9 | 7 | 6 | 28861 | 25 |
| 68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
| 61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
| 152525 | 109744 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4307 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772150 | 5981459.9 | 2104819.9 | 37.7583589503944 | -122.507191346523 | (37.7583589503944, -122.507191346523) | 1 | 8 | 3 | 56 | 35 |
| 145329 | 110718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 201x OGDEN AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007843 | 2096159 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | 2 | 7 | 7 | 28859 | 2 | ||||
| 113032 | 111713 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
| 193198 | 111714 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3038 CLEMENT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | 1 | 3x3 | Permit Number 777015 | 5986051 | 2113265 | 37.7818161572934 | -122.491935266217 | (37.7818161572934, -122.491935266217) | 11 | 6 | 2 | 55 | 26 | |
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 187598 | 112025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 127080 | 112029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 46414 | 112583 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 1 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | |||
| 132551 | 112584 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
| 41654 | 112585 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
| 147556 | 112586 | Section 143 10 | Lagunaria patersonii :: Primrose Tree 6 | 3400x WAWONA ST | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 4x4 | 5982411 | 2096792 | 37.7363725426512 | -122.503307672629 | (37.7363725426512, -122.503307672629) | 1 | 8 | 3 | 29491 | 35 | ||||
| 184192 | 113139 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 31538 | 113355 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 5982766.03998 | 2112575.4615 | 37.7797303315274 | -122.503248436763 | (37.7797303315274, -122.503248436763) | 11 | 6 | 2 | 55 | 26 | |||
| 129314 | 113356 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 Point Lobos Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 5982735.90689 | 2112577.00884 | 37.7797328087219 | -122.503352793138 | (37.7797328087219, -122.503352793138) | 11 | 6 | 2 | 55 | 26 | |||
| 153523 | 113357 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2 POINT LOBOS AVE | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 5982777 | 2112621 | 37.7798560111402 | -122.503213894495 | (37.7798560111402, -122.503213894495) | 11 | 6 | 2 | 55 | 26 | ||||
| 148332 | 113418 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 598X BENTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6007207 | 2095355 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | 2 | 7 | 7 | 28859 | 2 | |||
| 53099 | 113489 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 40 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x10 | 5995526.6518 | 2115672.85646 | 37.7889767847188 | -122.45932857543 | (37.7889767847188, -122.45932857543) | 11 | 6 | 1 | 54 | 31 | |||
| 159810 | 114206 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1030 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2016 01:19:00 PM | 3 | 3x3 | 5989968.0933 | 2099069.2019 | 37.7430664963024 | -122.477346296714 | (37.7430664963024, -122.477346296714) | 1 | 8 | 3 | 29491 | 35 | ||
| 50859 | 114691 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | |||
| 138944 | 114692 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 391 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 12/01/2015 12:00:00 AM | Permit Number 774511 | 6010909.5 | 2092975 | 37.7275259502006 | -122.404507285761 | (37.7275259502006, -122.404507285761) | 10 | 3 | 7 | 309 | 28 | ||
| 43518 | 114818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 825 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2018 12:00:00 AM | 3 | Permit Number 774480 | 5986555.6 | 2110296.1 | 37.773693882861 | -122.489971179067 | (37.773693882861, -122.489971179067) | 11 | 6 | 2 | 55 | 26 | ||
| 69435 | 114895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 820 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | Permit Number 775427 | 5986664.4 | 2110325.3 | 37.7737804103986 | -122.489596975753 | (37.7737804103986, -122.489596975753) | 11 | 6 | 2 | 55 | 26 | |||
| 59213 | 115174 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1234 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777353 | 5981842.5 | 2106688 | 37.7635107458641 | -122.506006674694 | (37.7635107458641, -122.506006674694) | 1 | 8 | 3 | 56 | 35 | |||
| 174553 | 115183 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3610 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2016 12:00:00 AM | Permit Number 774488 | 5982230.3 | 2100857.8 | 37.7475254834273 | -122.50423350924 | (37.7475254834273, -122.50423350924) | 1 | 8 | 3 | 29491 | 35 | |||
| 192805 | 115237 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 867 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775536 | 5982900.6 | 2109891.1 | 37.7723677654738 | -122.502584200594 | (37.7723677654738, -122.502584200594) | 11 | 6 | 2 | 55 | 26 | |||
| 63206 | 115239 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775147 | 5981970.6 | 2109880.3 | 37.7722834181785 | -122.505800301349 | (37.7722834181785, -122.505800301349) | 11 | 6 | 2 | 55 | 26 | |||
| 116677 | 115268 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2275 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775658 | 5987276.1 | 2099806.2 | 37.7449335319328 | -122.486708467871 | (37.7449335319328, -122.486708467871) | 1 | 8 | 3 | 29491 | 35 | |||
| 175025 | 115381 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1657X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.21326 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | 2 | 7 | 7 | 28859 | 2 | ||
| 70295 | 11573 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3906 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2015 07:56:00 AM | 3 | 3X3 | 5982438 | 2105598 | 37.7605529521075 | -122.503866330302 | (37.7605529521075, -122.503866330302) | 1 | 8 | 3 | 56 | 35 | ||
| 139943 | 115757 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.21291 | 37.7151093927473 | -122.448405831859 | (37.7151093927473, -122.448405831859) | 9 | 7 | 6 | 28861 | 25 | ||
| 169433 | 115802 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1218 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774518 | 5981226.5 | 2106751.9 | 37.7636499175412 | -122.50814192749 | (37.7636499175412, -122.50814192749) | 1 | 8 | 3 | 56 | 35 | |
| 115054 | 11582 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4000 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 11:49:00 AM | 3 | 3X3 | 5982109.291 | 2105604.0369 | 37.7605501938414 | -122.505003612665 | (37.7605501938414, -122.505003612665) | 1 | 8 | 3 | 56 | 35 | ||
| 58640 | 11589 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4050X Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/19/2016 11:29:00 AM | 3 | 3X3 | 5981992.3567285 | 2105594.1635633 | 37.7605162040396 | -122.505407296146 | (37.7605162040396, -122.505407296146) | 1 | 8 | 3 | 56 | 35 | ||
| 113377 | 115939 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 607 34TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777685 | 5985316 | 2111712 | 37.7775090776113 | -122.494363475489 | (37.7775090776113, -122.494363475489) | 11 | 6 | 2 | 55 | 26 | |
| 59994 | 11598 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4134 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 11:51:00 AM | 3 | 3X3 | 5981663.7126 | 2105589.2786 | 37.7604834464148 | -122.506543543521 | (37.7604834464148, -122.506543543521) | 1 | 8 | 3 | 56 | 35 | ||
| 93431 | 11602 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4150 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/2011 12:00:00 AM | 3 | 3X3 | 5981591.6344 | 2105586.8054 | 37.7604724115264 | -122.506792641078 | (37.7604724115264, -122.506792641078) | 1 | 8 | 3 | 56 | 35 | ||
| 145389 | 11603 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4245 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2015 05:31:00 PM | 3 | 3X3 | 5981392.2965206 | 2105523.6051476 | 37.7602871413722 | -122.507477357537 | (37.7602871413722, -122.507477357537) | 1 | 8 | 3 | 56 | 35 | ||
| 55470 | 11606 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4200x Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2017 11:54:00 AM | 3 | 3X3 | 5981492.2847 | 2105581.1189 | 37.7604509471428 | -122.507135818078 | (37.7604509471428, -122.507135818078) | 1 | 8 | 3 | 56 | 35 | ||
| 65853 | 116538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 1 | Median : Yard | Tree | DPW 1 | 1 | 3x3 | 6001578.10158 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | 9 | 7 | 6 | 28861 | 5 | |||
| 138570 | 116539 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001567.48738 | 2088213.72569 | 37.7139260459311 | -122.436462001442 | (37.7139260459311, -122.436462001442) | 9 | 7 | 6 | 28861 | 5 | |||
| 44017 | 116540 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 3 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001555.50616 | 2088195.95431 | 37.7138765688354 | -122.436502141754 | (37.7138765688354, -122.436502141754) | 9 | 7 | 6 | 28861 | 5 | |||
| 69235 | 116543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001574.84931 | 2088164.89401 | 37.7137923832878 | -122.43643306305 | (37.7137923832878, -122.43643306305) | 9 | 7 | 6 | 28861 | 5 | |||
| 7686 | 116544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 7 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.7138425996209 | -122.436395723209 | (37.7138425996209, -122.436395723209) | 9 | 7 | 6 | 28861 | 5 | |||
| 144424 | 116545 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 1 | Median : Yard | Tree | DPW 1 | 2 | 3x3 | 6001537.05763 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | 9 | 7 | 6 | 28861 | 5 | |||
| 116664 | 116546 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 2 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001545.43478 | 2088113.86518 | 37.7136505979649 | -122.436531080144 | (37.7136505979649, -122.436531080144) | 9 | 7 | 6 | 28861 | 5 | |||
| 95040 | 116547 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 3 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | 9 | 7 | 6 | 28861 | 5 | |||
| 138388 | 116548 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 4 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001544.87474 | 2088178.15499 | 37.7138270917124 | -122.436537614614 | (37.7138270917124, -122.436537614614) | 9 | 7 | 6 | 28861 | 5 | |||
| 139455 | 116549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 5 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001562.82912 | 2088145.24079 | 37.7137377368707 | -122.436473203396 | (37.7137377368707, -122.436473203396) | 9 | 7 | 6 | 28861 | 5 | |||
| 123255 | 116550 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001534.78323 | 2088160.34451 | 37.7137776146169 | -122.436571220504 | (37.7137776146169, -122.436571220504) | 9 | 7 | 6 | 28861 | 5 | |||
| 58866 | 116551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 7 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.436608560332 | (37.713721490625, -122.436608560332) | 9 | 7 | 6 | 28861 | 5 | |||
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 119754 | 116735 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 78293 | 116736 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1799x 25TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5988397 | 2103119 | 37.7540948807956 | -122.483075414994 | (37.7540948807956, -122.483075414994) | 1 | 8 | 3 | 56 | 35 | ||||
| 144492 | 116789 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 530 CRESCENT AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007719 | 2095661 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | 2 | 7 | 7 | 28859 | 2 | ||||
| 35644 | 117055 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 762 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2016 12:00:00 AM | 3 | Permit Number 778404 | 5985439.6 | 2110687.7 | 37.7747038750392 | -122.493860404631 | (37.7747038750392, -122.493860404631) | 11 | 6 | 2 | 55 | 26 |
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) );