trees
979 rows where qSpecies_id = 13 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5226 | 259803 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 12808 | 254368 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 590X Orizaba Ave | 1 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
| 15038 | 259861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15229 | 259804 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199x Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 15796 | 260912 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99x Belvedere St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
| 19358 | 259860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201x Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 3356 | 74692 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | 3 | 1 | 10 | 308 | 23 | |||
| 3991 | 131008 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013685.84477 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | 4 | 1 | 10 | 28860 | 6 | |||
| 10144 | 97101 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
| 11453 | 130994 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 800 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008432.69085 | 2120383.1883 | 37.8026437557674 | -122.415008787324 | (37.8026437557674, -122.415008787324) | 5 | 1 | 10 | 308 | 32 | |||
| 11942 | 34949 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | Permit Number 38547 | 6007519.49351 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | 13 | 1 | 10 | 28858 | 21 | ||
| 13364 | 70607 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1256 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007485.00571 | 2115457.39575 | 37.7890654569562 | -122.417938877483 | (37.7890654569562, -122.417938877483) | 13 | 1 | 10 | 28858 | 21 | |||
| 14077 | 70606 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6007500.28626 | 2115460.0775 | 37.7890736803541 | -122.417886198793 | (37.7890736803541, -122.417886198793) | 13 | 1 | 10 | 28858 | 21 | |||
| 18076 | 131000 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007889.3393 | 2120258.19812 | 37.8022700164033 | -122.416880201885 | (37.8022700164033, -122.416880201885) | 5 | 1 | 10 | 308 | 32 | ||
| 24814 | 130998 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007580.24685 | 2119942.9983 | 37.8013871663302 | -122.417927457909 | (37.8013871663302, -122.417927457909) | 5 | 1 | 1 | 28858 | 32 | |||
| 27090 | 130990 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1465 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007716.27446 | 2117147.85171 | 37.7937200456874 | -122.417258554752 | (37.7937200456874, -122.417258554752) | 5 | 1 | 10 | 28858 | 32 | |||
| 33704 | 249813 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Chestnut St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6010621.11973 | 2121031.89357 | 37.8045476726861 | -122.407481446514 | (37.8045476726861, -122.407481446514) | 3 | 1 | 10 | 308 | 23 | |||
| 34619 | 131007 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013687.07221 | 2117423.51513 | 37.7948110573238 | -122.396618254944 | (37.7948110573238, -122.396618254944) | 4 | 1 | 10 | 28860 | 6 | |||
| 45229 | 13059 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 583 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:23:00 AM | 3 | 2x2 | 6009557.0524 | 2120495.5376 | 37.8030153566132 | -122.41112585507 | (37.8030153566132, -122.41112585507) | 3 | 1 | 10 | 308 | 23 | ||
| 49090 | 51497 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 741 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50950 | 6009247.81044 | 2119754.33215 | 37.8009628437188 | -122.412143582356 | (37.8009628437188, -122.412143582356) | 3 | 1 | 10 | 308 | 4 | |
| 50069 | 130988 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008672.99088 | 2115994.19666 | 37.7906061691929 | -122.41386657548 | (37.7906061691929, -122.41386657548) | 5 | 1 | 10 | 28857 | 21 | |||
| 54419 | 131003 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011959.67514 | 2119544.33527 | 37.8005380309676 | -122.402744545519 | (37.8005380309676, -122.402744545519) | 3 | 1 | 10 | 308 | 23 | |||
| 64815 | 97108 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1472 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768373 | 6007110.85897 | 2117762.02293 | 37.795372327823 | -122.419396941128 | (37.795372327823, -122.419396941128) | 5 | 1 | 10 | 28858 | 32 |
| 68819 | 131009 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 4 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013684.35472 | 2117443.22893 | 37.7948650355324 | -122.396629040522 | (37.7948650355324, -122.396629040522) | 4 | 1 | 10 | 28860 | 6 | |||
| 71703 | 130995 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 832 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008337.45548 | 2120371.32318 | 37.8026058250595 | -122.41533751024 | (37.8026058250595, -122.41533751024) | 5 | 1 | 10 | 308 | 32 | |||
| 74008 | 249952 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 3 | Side Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 6011371.46837 | 2120040.8031 | 37.8018683513038 | -122.404814962944 | (37.8018683513038, -122.404814962944) | 3 | 1 | 10 | 308 | 23 | |||
| 74030 | 97099 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
| 84305 | 131006 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 25 Joice St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010297.06637 | 2116294.60935 | 37.7915221044126 | -122.408268538566 | (37.7915221044126, -122.408268538566) | 5 | 1 | 10 | 28857 | 21 | |||
| 93475 | 249954 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 1 | Side Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011374.5207 | 2120037.63727 | 37.8018598293151 | -122.404804177386 | (37.8018598293151, -122.404804177386) | 3 | 1 | 10 | 308 | 23 | |||
| 96748 | 249953 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 303 Filbert St | 2 | Side Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011372.65237 | 2120041.55492 | 37.8018704817969 | -122.404810918689 | (37.8018704817969, -122.404810918689) | 3 | 1 | 10 | 308 | 23 | |||
| 97084 | 250221 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 312 Filbert St | 2 | Side Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011282.00764 | 2120080.85256 | 37.8019733165766 | -122.405127362244 | (37.8019733165766, -122.405127362244) | 3 | 1 | 10 | 308 | 23 | |||
| 102454 | 131001 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.8022806446072 | -122.416822257668 | (37.8022806446072, -122.416822257668) | 5 | 1 | 10 | 308 | 32 | |||
| 103481 | 127870 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1863 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782589 | 6007272.90865 | 2118759.36484 | 37.798119905069 | -122.418906991373 | (37.798119905069, -122.418906991373) | 5 | 1 | 10 | 28858 | 32 |
| 104120 | 131002 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/09/2014 12:00:00 AM | 2 | Width 3ft | 6007919.06293 | 2120264.13988 | 37.8022880028424 | -122.416777764577 | (37.8022880028424, -122.416777764577) | 5 | 1 | 10 | 308 | 32 | ||
| 107450 | 4378 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2425X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6006994.61601 | 2120672.53629 | 37.8033573165358 | -122.420005806422 | (37.8033573165358, -122.420005806422) | 5 | 1 | 1 | 28858 | 32 | |||
| 108983 | 131005 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011966.28047 | 2119507.31076 | 37.8004367394276 | -122.40271908303 | (37.8004367394276, -122.40271908303) | 3 | 1 | 10 | 308 | 23 | |||
| 112413 | 131004 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1109 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011962.57681 | 2119524.82057 | 37.8004846103385 | -122.402733131341 | (37.8004846103385, -122.402733131341) | 3 | 1 | 10 | 308 | 23 | |||
| 118197 | 109493 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007532.32765 | 2115464.28758 | 37.789087043374 | -122.417775637962 | (37.789087043374, -122.417775637962) | 13 | 1 | 10 | 28858 | 21 | |||
| 131626 | 84840 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1107 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | 7 | Permit No. 49267 | 6009440.82091 | 2117125.31431 | 37.7937550347318 | -122.411289855968 | (37.7937550347318, -122.411289855968) | 3 | 1 | 10 | 28857 | 21 | ||
| 133316 | 130999 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2009 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008124.35834 | 2119571.24818 | 37.8003970406522 | -122.416018243071 | (37.8003970406522, -122.416018243071) | 5 | 1 | 1 | 308 | 32 | |||
| 135376 | 88424 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1465 Washington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51388 | 6007689 | 2117147 | 37.7937161726159 | -122.417352866644 | (37.7937161726159, -122.417352866644) | 5 | 1 | 10 | 28858 | 32 | |||
| 172181 | 130989 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1000 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008668.89448 | 2116022.78913 | 37.7906844470866 | -122.413882772283 | (37.7906844470866, -122.413882772283) | 5 | 1 | 10 | 28857 | 21 | |||
| 176927 | 130997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Leavenworth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6007578.93915 | 2119952.78886 | 37.8014139751467 | -122.417932677574 | (37.8014139751467, -122.417932677574) | 5 | 1 | 1 | 28858 | 32 | |||
| 185410 | 112790 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Joice St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 11 | 3x3 | 6010307.81813 | 2116296.03331 | 37.7915266163113 | -122.408231437935 | (37.7915266163113, -122.408231437935) | 5 | 1 | 10 | 28857 | 21 | |||
| 2106 | 193374 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008975.96564 | 2110229.86919 | 37.7747957152898 | -122.412410677425 | (37.7747957152898, -122.412410677425) | 8 | 2 | 9 | 28853 | 34 | |||
| 3743 | 193316 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6013300.83104 | 2113672.81478 | 37.7844910077044 | -122.397691511273 | (37.7844910077044, -122.397691511273) | 6 | 2 | 9 | 28856 | 6 | |||
| 5290 | 89193 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
| 5638 | 89169 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 9218 | 106080 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 188 The Embarcadero | 1 | Front Yard : Yard | Tree | Private 2 | 03/20/2014 12:00:00 AM | Permit Number 771259 | 6015087.8131 | 2116516.98611 | 37.7923997963133 | -122.391708043282 | (37.7923997963133, -122.391708043282) | 12 | 2 | 9 | 28855 | 6 | |||
| 19852 | 33783 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013842.92338 | 2116188.62598 | 37.7914290137913 | -122.395992405042 | (37.7914290137913, -122.395992405042) | 12 | 2 | 9 | 28855 | 6 | |
| 21421 | 193318 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 4 | : | Tree | Private 2 | 10 | Width 2ft | 6013332.96782 | 2113640.49809 | 37.7844040630434 | -122.397578060899 | (37.7844040630434, -122.397578060899) | 6 | 2 | 9 | 28856 | 6 | |||
| 24096 | 105848 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | |||
| 27143 | 193373 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013783.27133 | 2116255.65231 | 37.7916097334637 | -122.396203501097 | (37.7916097334637, -122.396203501097) | 12 | 2 | 9 | 28855 | 6 | |||
| 37097 | 193317 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 3 | : | Tree | Private 2 | 9 | Width 2ft | 6013319.34244 | 2113654.62795 | 37.7844421016727 | -122.397626191699 | (37.7844421016727, -122.397626191699) | 6 | 2 | 9 | 28856 | 6 | |||
| 38386 | 89162 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||
| 45307 | 85039 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 740 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49387 | 6008855.33926 | 2110725.28618 | 37.7761492435388 | -122.412862984239 | (37.7761492435388, -122.412862984239) | 8 | 2 | 9 | 28853 | 34 | |
| 55630 | 95830 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 5 Lucerne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767564 | 6011975 | 2109856 | 37.7739369979495 | -122.402010048031 | (37.7739369979495, -122.402010048031) | 14 | 2 | 9 | 28853 | 34 | |
| 58046 | 107963 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 33 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770900 | 6011844.7795 | 2114609.58385 | 37.7869819669901 | -122.402794885102 | (37.7869819669901, -122.402794885102) | 12 | 2 | 9 | 28853 | 6 | |
| 60421 | 112587 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | ||||
| 65644 | 109906 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1415 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3x3 | 6008272.88194 | 2109795.90835 | 37.7735646809973 | -122.414812077722 | (37.7735646809973, -122.414812077722) | 8 | 2 | 9 | 28853 | 34 | |||
| 66699 | 193377 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2018 12:00:00 AM | 3 | Width 3ft | 6008648.26214 | 2109663.47426 | 37.7732221328357 | -122.413504208979 | (37.7732221328357, -122.413504208979) | 8 | 2 | 9 | 28853 | 34 | ||
| 67172 | 193355 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013990.6766 | 2116456.52969 | 37.7921728340575 | -122.395499955167 | (37.7921728340575, -122.395499955167) | 12 | 2 | 9 | 28855 | 6 | |||
| 81471 | 33774 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013834.28126 | 2116198.48682 | 37.7914556085404 | -122.396022998165 | (37.7914556085404, -122.396022998165) | 12 | 2 | 9 | 28855 | 6 | |
| 90120 | 193368 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013947.27528 | 2116186.44855 | 37.7914288402078 | -122.395631194149 | (37.7914288402078, -122.395631194149) | 12 | 2 | 9 | 28855 | 6 | |||
| 90501 | 193371 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 264 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013926.24547 | 2116163.52102 | 37.791364716756 | -122.395702350277 | (37.791364716756, -122.395702350277) | 12 | 2 | 9 | 28855 | 6 | |||
| 91046 | 89190 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 95844 | 193362 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014011.61838 | 2116245.86436 | 37.7915955610366 | -122.395412730824 | (37.7915955610366, -122.395412730824) | 12 | 2 | 9 | 28855 | 6 | |||
| 97909 | 33782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013852.02109 | 2116179.41654 | 37.7914042329729 | -122.395960281264 | (37.7914042329729, -122.395960281264) | 12 | 2 | 9 | 28855 | 6 | |
| 100555 | 89164 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||
| 103563 | 193357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014010.13309 | 2116432.89008 | 37.7921090073852 | -122.395430978058 | (37.7921090073852, -122.395430978058) | 12 | 2 | 9 | 28855 | 6 | |||
| 104923 | 33800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013865.37275 | 2116161.97621 | 37.7913570887062 | -122.395912861799 | (37.7913570887062, -122.395912861799) | 12 | 2 | 9 | 28855 | 6 | |
| 109890 | 89170 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 110549 | 193372 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013792.54079 | 2116244.01793 | 37.7915783039417 | -122.39617061289 | (37.7915783039417, -122.39617061289) | 12 | 2 | 9 | 28855 | 6 | |||
| 115148 | 193365 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6013979.60171 | 2116214.89575 | 37.7915087476865 | -122.395521338359 | (37.7915087476865, -122.395521338359) | 12 | 2 | 9 | 28855 | 6 | |||
| 119007 | 109908 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1401 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/2015 02:04:00 PM | 3 | 3x3 | Permit Number 778313 | 6008340.42119 | 2109862.66125 | 37.7737517633724 | -122.414583173274 | (37.7737517633724, -122.414583173274) | 8 | 2 | 9 | 28853 | 34 | |
| 124343 | 89194 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
| 131765 | 89188 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 131934 | 193363 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.9996 | 2116238.17517 | 37.7915738577077 | -122.395448933038 | (37.7915738577077, -122.395448933038) | 12 | 2 | 9 | 28855 | 6 | |||
| 132863 | 193366 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013970.03568 | 2116205.74836 | 37.7914830990039 | -122.395553795767 | (37.7914830990039, -122.395553795767) | 12 | 2 | 9 | 28855 | 6 | |||
| 134517 | 33792 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013856.54517 | 2116173.60161 | 37.7913885182281 | -122.395944220262 | (37.7913885182281, -122.395944220262) | 12 | 2 | 9 | 28855 | 6 | |
| 134523 | 193361 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 246 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014025.95999 | 2116259.22664 | 37.7916330483898 | -122.395364045136 | (37.7916330483898, -122.395364045136) | 12 | 2 | 9 | 28855 | 6 | |||
| 138815 | 193376 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008940.99117 | 2110196.43665 | 37.7747019546579 | -122.41252929799 | (37.7747019546579, -122.41252929799) | 8 | 2 | 9 | 28853 | 34 | |||
| 139876 | 89172 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 143967 | 89185 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 145435 | 193364 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 260 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013990.63933 | 2116225.45086 | 37.7915383434816 | -122.395483887876 | (37.7915383434816, -122.395483887876) | 12 | 2 | 9 | 28855 | 6 | |||
| 146551 | 193370 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013935.48002 | 2116174.11264 | 37.7913943125596 | -122.39567114113 | (37.7913943125596, -122.39567114113) | 12 | 2 | 9 | 28855 | 6 | |||
| 147236 | 193369 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 262 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6013943.1918 | 2116180.78279 | 37.7914130562087 | -122.395644925876 | (37.7914130562087, -122.395644925876) | 12 | 2 | 9 | 28855 | 6 | |||
| 147690 | 193356 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 60 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014000.33626 | 2116445.25726 | 37.7921424198756 | -122.395465742269 | (37.7921424198756, -122.395465742269) | 12 | 2 | 9 | 28855 | 6 | |||
| 152829 | 89184 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 154921 | 193359 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 208 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014052.91282 | 2116289.57894 | 37.7917178877279 | -122.395272915033 | (37.7917178877279, -122.395272915033) | 12 | 2 | 9 | 28855 | 6 | |||
| 155829 | 89192 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2008 12:00:00 AM | 3x3 | Permit Number 51807 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||
| 165807 | 193375 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008954.62424 | 2110209.13379 | 37.7747375831097 | -122.412483035979 | (37.7747375831097, -122.412483035979) | 8 | 2 | 9 | 28853 | 34 | |||
| 166081 | 89187 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 166371 | 31608 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 5 Lucerne St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1995 12:00:00 AM | 4 | Permit Number 35133 | 6012020.8525 | 2109827.45516 | 37.7738611793697 | -122.401849428724 | (37.7738611793697, -122.401849428724) | 14 | 2 | 9 | 28853 | 34 | ||
| 169387 | 89171 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 169485 | 33779 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013803.37475 | 2116233.23226 | 37.7915492918181 | -122.396132371028 | (37.7915492918181, -122.396132371028) | 12 | 2 | 9 | 28855 | 6 | |
| 170760 | 193358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 62 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6014021.3474 | 2116423.46881 | 37.7920837625026 | -122.395391515812 | (37.7920837625026, -122.395391515812) | 12 | 2 | 9 | 28855 | 6 | |||
| 173449 | 193315 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 136 Hawthorne St | 1 | : | Tree | Private 2 | 9 | Width 2ft | 6013291.13873 | 2113684.88595 | 37.7845236126199 | -122.39772589056 | (37.7845236126199, -122.39772589056) | 6 | 2 | 9 | 28856 | 6 | |||
| 175026 | 33785 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 77 Beale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774395 | 6013812.6799 | 2116223.3583 | 37.7915226979635 | -122.396099482817 | (37.7915226979635, -122.396099482817) | 12 | 2 | 9 | 28855 | 6 | |
| 176468 | 89189 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 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) );