Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | 100 | 106679 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2014 12:00:00 AM | 10 | 3x3 | Permit Number 773028 | 5999374.7893199995 | 2116379.94206 | 37.7911387486163 | -122.44606546047702 | (37.7911387486163, -122.446065460477) | |
| 326 | 326 | 251270 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | ||
| 677 | 677 | 107511 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2141 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001625.68296 | 2119729.38155 | 37.8004637136911 | -122.43851754404601 | (37.8004637136911, -122.438517544046) | ||
| 1024 | 1024 | 97943 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3003 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768278 | 5999754.4115699995 | 2116356.69568 | 37.791096591089 | -122.44475031260099 | (37.791096591089, -122.444750312601) | |
| 1082 | 1082 | 22639 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6004184.7636 | 2112567.9201 | 37.780945391127 | -122.429151179613 | (37.780945391127, -122.429151179613) | ||
| 1118 | 1118 | 26811 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1850 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001133.0786 | 2112143.4834 | 37.7796067716282 | -122.43967800032301 | (37.7796067716282, -122.439678000323) | |||
| 1129 | 1129 | 251457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001327.0 | 2092594.0 | 37.7259396258956 | -122.437606717792 | (37.7259396258956, -122.437606717792) | ||||
| 1240 | 1240 | 241867 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 633 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1987 12:00:00 AM | 8 | Width 2ft | Permit Number 24800 | 6008703.52023 | 2095884.2711099999 | 37.735390653541295 | -122.412338944781 | (37.7353906535413, -122.412338944781) | |
| 1447 | 1447 | 139887 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1575 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | Width 0ft | 6002626.7608 | 2112299.1255 | 37.7801190291536 | -122.434521848172 | (37.7801190291536, -122.434521848172) | ||
| 1460 | 1460 | 139886 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1575 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 7 | Width 0ft | 6002599.6871 | 2112295.0644 | 37.78010634148521 | -122.434615217822 | (37.7801063414852, -122.434615217822) | ||
| 1649 | 1649 | 251584 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2679 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1997 12:00:00 AM | 3x3 | 5997280.0 | 2088608.0 | 37.714764069005604 | -122.45130950851002 | (37.7147640690056, -122.45130950851) | |||
| 1725 | 1725 | 24940 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2733 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 6 | 3X3 | 5998612.3168 | 2113129.3587 | 37.782169931054604 | -122.44846938258301 | (37.7821699310546, -122.448469382583) | ||
| 2072 | 2072 | 136839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1911 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | Width 4ft | Permit Number 52344 | 6003883.81928 | 2118306.5649 | 37.7966852175075 | -122.43060190297199 | (37.7966852175075, -122.430601902972) | |
| 2084 | 2084 | 200756 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1698 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | 07/23/2010 12:00:00 AM | 2 | Width 0ft | Permit Number 53643 | 6014807.3749 | 2094642.3361 | 37.732321185493 | -122.39114868869899 | (37.732321185493, -122.391148688699) | |
| 2152 | 2152 | 242277 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 117 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 46994 | 6001802.4938199995 | 2096648.3509099998 | 37.7370989679366 | -122.43625299088801 | (37.7370989679366, -122.436252990888) | |
| 2244 | 2244 | 34670 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2001X Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 38339 | 6003296.78192 | 2118922.23396 | 37.798342411735604 | -122.432677184799 | (37.7983424117356, -122.432677184799) | |
| 2245 | 2245 | 5919 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2007 12:00:00 AM | 12 | 3x3 | Permit Number 52201 | 6004140.9874 | 2112910.1496 | 37.7818825900403 | -122.42932703435 | (37.7818825900403, -122.42932703435) | |
| 2301 | 2301 | 22734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1990 12:00:00 AM | 18 | 3X3 | 6002510.1745 | 2112337.5363 | 37.780217876703794 | -122.434927920426 | (37.7802178767038, -122.434927920426) | ||
| 2698 | 2698 | 21631 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1615 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1994 12:00:00 AM | 12 | 4X4 | 6004720.5557 | 2114675.0873 | 37.7867614641574 | -122.427447768121 | (37.7867614641574, -122.427447768121) | ||
| 3101 | 3101 | 102774 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 31200 | 6005947.91695 | 2119337.23456 | 37.7996318920616 | -122.42353296190201 | (37.7996318920616, -122.423532961902) | ||
| 3186 | 3186 | 218743 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/06/1988 12:00:00 AM | 8 | Width 3ft | Permit Number 25334 | 5995930.5324099995 | 2096235.39856 | 37.7356297230374 | -122.456525038998 | (37.7356297230374, -122.456525038998) | |
| 3298 | 3298 | 28315 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 739 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780585 | 6008002.89443 | 2097198.9906200003 | 37.7389612444527 | -122.414854295516 | (37.7389612444527, -122.414854295516) | |
| 3325 | 3325 | 140465 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2001 12:00:00 AM | 4 | Width 0ft | 6002943.0868 | 2112390.4269 | 37.780387671465505 | -122.433434060142 | (37.7803876714655, -122.433434060142) | ||
| 3327 | 3327 | 140458 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | Width 0ft | 6003273.7425 | 2112436.298 | 37.7805323760013 | -122.432293445455 | (37.7805323760013, -122.432293445455) | ||
| 3332 | 3332 | 140463 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 3 | Width 0ft | 6003009.4486 | 2112400.1289 | 37.7804180754921 | -122.43320517732201 | (37.7804180754921, -122.433205177322) | ||
| 3352 | 3352 | 140464 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 4 | Width 0ft | 6002964.8193 | 2112393.1435 | 37.780396363522 | -122.433359071525 | (37.780396363522, -122.433359071525) | ||
| 3512 | 3512 | 241416 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 126 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1985 12:00:00 AM | 12 | Width 2ft | Permit Number 22471 | 6004614.54132 | 2095950.25242 | 37.7353415190975 | -122.42648077318 | (37.7353415190975, -122.42648077318) | |
| 3863 | 3863 | 6898 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 330 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6005831.3408 | 2110713.462 | 37.775946573797995 | -122.423322982857 | (37.775946573798, -122.423322982857) | ||
| 3986 | 3986 | 65721 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 275 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2017 04:32:00 PM | 3 | Permit Number 28655 | 6000475.14424 | 2087458.3820900002 | 37.711789909637794 | -122.44018340596399 | (37.7117899096378, -122.440183405964) | |
| 4496 | 4496 | 30326 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 946 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:13:00 AM | 3 | Permit Number 17 | 5995052.87017 | 2090222.4724 | 37.7190692525106 | -122.459124173264 | (37.7190692525106, -122.459124173264) | ||
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 4638 | 4638 | 180016 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2901 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 7 | Width 3ft | 5997041.774780001 | 2087538.2490700001 | 37.711813136431 | -122.452055773566 | (37.711813136431, -122.452055773566) | ||
| 4699 | 4699 | 253658 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4700 | 4700 | 253660 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4702 | 4702 | 253657 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4703 | 4703 | 253659 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4709 | 4709 | 253656 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4848 | 4848 | 31890 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 5307 | 5307 | 8160 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1100 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2007 12:00:00 AM | 3 | 3X3 | 6002453.143999999 | 2111285.6659999997 | 37.777326466446 | -122.435049962975 | (37.777326466446, -122.435049962975) | ||
| 5473 | 5473 | 52359 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007837.48852 | 2114654.59381 | 37.786880990198 | -122.41666243464199 | (37.786880990198, -122.416662434642) |
| 5644 | 5644 | 81955 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 611 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769820 | 6007855.44707 | 2114525.76185 | 37.7865282590267 | -122.416591172348 | (37.7865282590267, -122.416591172348) |
| 5663 | 5663 | 24487 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 618 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004392.5811 | 2110517.0483 | 37.7753259646513 | -122.428286026192 | (37.7753259646513, -122.428286026192) | ||
| 5767 | 5767 | 14527 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 644 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999201.3001 | 2110597.4992 | 37.7752517549466 | -122.44624958831801 | (37.7752517549466, -122.446249588318) | |||
| 5805 | 5805 | 22726 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1525 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1997 12:00:00 AM | 12 | 3X3 | 6002762.8064 | 2112322.4766 | 37.780190867266796 | -122.43405287482 | (37.7801908672668, -122.43405287482) | ||
| 5829 | 5829 | 7833 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006176.68475 | 2113023.80022 | 37.7823096849858 | -122.42229253146999 | (37.7823096849858, -122.42229253147) | |||
| 6259 | 6259 | 110082 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3028 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773127 | 6003845.53754 | 2119275.91303 | 37.799344628804796 | -122.43080357774299 | (37.7993446288048, -122.430803577743) | |
| 6404 | 6404 | 7830 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006192.27553 | 2112919.76373 | 37.7820249056667 | -122.422231200417 | (37.7820249056667, -122.422231200417) | |||
| 6480 | 6480 | 6980 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 802 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003550.3934 | 2110396.3103 | 37.7749467581504 | -122.431190726971 | (37.7749467581504, -122.431190726971) | ||
| 6526 | 6526 | 7834 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006174.13895 | 2113043.71306 | 37.7823642171667 | -122.422302754063 | (37.7823642171667, -122.422302754063) | |||
| 6540 | 6540 | 7831 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006187.42417 | 2112935.31044 | 37.7820673194837 | -122.42224908883001 | (37.7820673194837, -122.42224908883) | |||
| 6659 | 6659 | 10663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.77563176944871 | -122.432267067771 | (37.7756317694487, -122.432267067771) | ||
| 6672 | 6672 | 22644 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1244 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2000 12:00:00 AM | 3 | 3X3 | 6004038.676 | 2112547.7701 | 37.7808817933373 | -122.429655131034 | (37.7808817933373, -122.429655131034) | ||
| 6675 | 6675 | 6064 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1913 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001176.3696 | 2112440.1627 | 37.78042384150729 | -122.43954951236799 | (37.7804238415073, -122.439549512368) | |||
| 6708 | 6708 | 26658 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 522 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1999 12:00:00 AM | 3 | 2X2 | 6004907.91771 | 2110588.9523400003 | 37.7755525415589 | -122.42650847769501 | (37.7755525415589, -122.426508477695) | ||
| 6836 | 6836 | 102772 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | Permit Number 31199 | 6006025.32539 | 2119349.8465400003 | 37.79967089025929 | -122.42326599722799 | (37.7996708902593, -122.423265997228) | ||
| 6899 | 6899 | 52360 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 645 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007841.58942 | 2114643.58565 | 37.78685099511571 | -122.416647466318 | (37.7868509951157, -122.416647466318) |
| 7019 | 7019 | 22735 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 3 | 3X3 | 6002477.0092 | 2112332.46 | 37.7802020553421 | -122.43504229111299 | (37.7802020553421, -122.435042291113) | ||
| 7130 | 7130 | 22744 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1575 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3x3 | 6002647.0661 | 2112304.2018 | 37.780134120032294 | -122.43445196604401 | (37.7801341200323, -122.434451966044) | ||
| 7190 | 7190 | 59699 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3188 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | Permit Number 773904 | 5999466.917230001 | 2116043.86882 | 37.7902212404654 | -122.44572252287901 | (37.7902212404654, -122.445722522879) | |
| 7210 | 7210 | 7829 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006196.28269 | 2112899.08523 | 37.7819683535895 | -122.422215867866 | (37.7819683535895, -122.422215867866) | |||
| 7239 | 7239 | 28357 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3060 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2003 12:00:00 AM | 3 | 3X3 | 6000153.01588 | 2115483.23318 | 37.7887210301107 | -122.44330839538601 | (37.7887210301107, -122.443308395386) | ||
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 7307 | 7307 | 7835 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1994 12:00:00 AM | 6 | 4x4 | 6006172.94925 | 2113057.71328 | 37.782402591234295 | -122.42230786493099 | (37.7824025912343, -122.422307864931) | ||
| 7363 | 7363 | 26659 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 522 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004893.91605 | 2110587.9747 | 37.7755490656586 | -122.42655684321998 | (37.7755490656586, -122.42655684322) | ||
| 7390 | 7390 | 24488 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 730 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003912.5381 | 2110447.8419 | 37.7751087667975 | -122.42994166795 | (37.7751087667975, -122.42994166795) | ||
| 7391 | 7391 | 58164 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1992 12:00:00 AM | 8 | Permit Number 31200 | 6005960.50321 | 2119339.77329 | 37.7996395731743 | -122.423489589398 | (37.7996395731743, -122.423489589398) | |
| 7415 | 7415 | 18997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3006 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2007 12:00:00 AM | 3 | 3X3PL | 6000330.42565 | 2115511.74748 | 37.7888094379519 | -122.44269663335301 | (37.7888094379519, -122.442696633353) | ||
| 7435 | 7435 | 14489 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5998982.1627 | 2111728.505 | 37.7783446886067 | -122.447089042698 | (37.7783446886067, -122.447089042698) | |||
| 7462 | 7462 | 6063 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1913 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001160.8022 | 2112439.8243 | 37.780422026336495 | -122.43960334291 | (37.7804220263365, -122.43960334291) | |||
| 7561 | 7561 | 2191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1059 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1998 12:00:00 AM | 6 | 4X4 | 6000860.0298 | 2112380.5159 | 37.780242057456704 | -122.440639597689 | (37.7802420574567, -122.440639597689) | ||
| 7575 | 7575 | 14521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 610 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999188.9854 | 2110718.1832 | 37.7755824190107 | -122.446300870977 | (37.7755824190107, -122.446300870977) | |||
| 7695 | 7695 | 6060 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1909 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001215.6265 | 2112445.5775 | 37.780440943348395 | -122.439414092915 | (37.7804409433484, -122.439414092915) | |||
| 7708 | 7708 | 7838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6006162.87093 | 2113106.46808 | 37.7825358914721 | -122.422346196719 | (37.7825358914721, -122.422346196719) | |||
| 7711 | 7711 | 67618 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31199 | 6006039.45477 | 2119353.8599099996 | 37.7996827073455 | -122.42321738978701 | (37.7996827073455, -122.423217389787) | |
| 7799 | 7799 | 36854 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7808 | 7808 | 6061 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1909 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001229.8402 | 2112447.2696 | 37.7804463983122 | -122.43936504248998 | (37.7804463983122, -122.43936504249) | |||
| 7906 | 7906 | 42669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1374 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 6 | 3x5 | Permit Number 46576 | 6007041.18345 | 2118110.17737 | 37.7963243483505 | -122.419662744764 | (37.7963243483505, -122.419662744764) |
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 7974 | 7974 | 14529 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999204.1149 | 2110576.3883 | 37.775193950570795 | -122.446238332395 | (37.7751939505708, -122.446238332395) | |||
| 8018 | 8018 | 18995 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3004 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2006 12:00:00 AM | 3 | 3X3PL | 6000360.72117 | 2115511.4863299998 | 37.7888104478801 | -122.44259179667101 | (37.7888104478801, -122.442591796671) | ||
| 8074 | 8074 | 8671 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2900 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1996 12:00:00 AM | 7 | 3X3 | 5998027.8623 | 2113153.3867 | 37.7822024719051 | -122.450493055338 | (37.7822024719051, -122.450493055338) | ||
| 8179 | 8179 | 7828 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006198.01452 | 2112875.51126 | 37.7819037229178 | -122.422208201166 | (37.7819037229178, -122.422208201166) | |||
| 8202 | 8202 | 22736 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6002447.5665 | 2112328.3989 | 37.7801892327397 | -122.435143856223 | (37.7801892327397, -122.435143856223) | ||
| 8291 | 8291 | 7837 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006168.41514 | 2113088.70054 | 37.78248741890079 | -122.42232575333401 | (37.7824874189008, -122.422325753334) | |||
| 8334 | 8334 | 103272 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 989 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770109 | 6007882.34676 | 2115110.89774 | 37.7881364123041 | -122.416539570166 | (37.7881364123041, -122.416539570166) | |
| 8505 | 8505 | 7836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006170.38861 | 2113076.8908 | 37.7824551035672 | -122.422318086628 | (37.7824551035672, -122.422318086628) | |||
| 8523 | 8523 | 107510 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2141 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001605.27547 | 2119726.96625 | 37.8004559210497 | -122.438587988867 | (37.8004559210497, -122.438587988867) | ||
| 8615 | 8615 | 29734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 644 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009872.4617 | 2119193.0537 | 37.7994567403911 | -122.40994236951299 | (37.7994567403911, -122.409942369513) | ||
| 8662 | 8662 | 52583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1047 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2006 12:00:00 AM | 4 | 3x3 | Permit Number 48677 | 6009673.58749 | 2117095.63602 | 37.7936865972027 | -122.41048236278499 | (37.7936865972027, -122.410482362785) | |
| 8684 | 8684 | 68184 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1993 12:00:00 AM | 7 | 3x3 | Permit Number 31957 | 5998180.4906 | 2112978.761 | 37.7817317298509 | -122.44995244286899 | (37.7817317298509, -122.449952442869) | |
| 8770 | 8770 | 48424 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3034 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/03/2014 12:00:00 AM | 3 | Permit Number 772479 | 6001994.11068 | 2118598.66634 | 37.7973800166165 | -122.437161635315 | (37.7973800166165, -122.437161635315) | |
| 9000 | 9000 | 29738 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 656 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009848.563999999 | 2119190.8307 | 37.7994492972084 | -122.410024907374 | (37.7994492972084, -122.410024907374) | ||
| 9099 | 9099 | 36836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9136 | 9136 | 29088 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2240 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009623.3077784 | 2104292.1140535 | 37.7585283102663 | -122.40975216800501 | (37.7585283102663, -122.409752168005) | ||
| 9142 | 9142 | 4534 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6004810.0812 | 2113642.485 | 37.783931258626396 | -122.42706445579901 | (37.7839312586264, -122.427064455799) | |||
| 9165 | 9165 | 26222 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9189 | 9189 | 29087 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2240 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009623.3077784 | 2104292.1140535 | 37.7585283102663 | -122.40975216800501 | (37.7585283102663, -122.409752168005) | ||
| 9270 | 9270 | 26229 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9282 | 9282 | 14446 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2012 12:00:00 AM | 3 | 3x3 | 5998938.7246 | 2112487.711 | 37.780426790070706 | -122.44729396725201 | (37.7804267900707, -122.447293967252) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");