Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 9310 | 9310 | 26227 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9326 | 9326 | 26258 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1530 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005847.527000001 | 2100032.50262 | 37.746620083181796 | -122.42250785943199 | (37.7466200831818, -122.422507859432) | |||
| 9328 | 9328 | 10963 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1431 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
| 9331 | 9331 | 26267 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9333 | 9333 | 26225 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9340 | 9340 | 26223 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2009 12:00:00 AM | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | ||
| 9350 | 9350 | 72948 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 510 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1999 12:00:00 AM | 3 | 6004536.11910305 | 2110188.83574422 | 37.7744328940259 | -122.427766104146 | (37.7744328940259, -122.427766104146) | |||
| 9351 | 9351 | 29078 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2265 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 4 | 3x3 | 6009683.3465759 | 2104161.2014379 | 37.758172218127704 | -122.40953528653 | (37.7581722181277, -122.40953528653) | ||
| 9380 | 9380 | 12155 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016212.874009999 | 2095683.59001 | 37.7352581567374 | -122.38636208157301 | (37.7352581567374, -122.386362081573) | ||
| 9384 | 9384 | 26268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9394 | 9394 | 19116 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 507X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2001 12:00:00 AM | 20 | 3X3 | 6003392.0492998 | 2108320.088346 | 37.769236987964604 | -122.431590213757 | (37.7692369879646, -122.431590213757) | ||
| 9404 | 9404 | 26230 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9416 | 9416 | 2543 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1580 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | |||
| 9439 | 9439 | 995 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6001498.326169999 | 2092340.4216099998 | 37.725253096867206 | -122.436996309494 | (37.7252530968672, -122.436996309494) | ||
| 9462 | 9462 | 26266 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9484 | 9484 | 29081 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2230 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 6 | 3x3 | 6009630.0 | 2104353.0 | 37.7586958643533 | -122.409733320805 | (37.7586958643533, -122.409733320805) | ||
| 9487 | 9487 | 2233 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1217 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1993 12:00:00 AM | 9 | 4X4 | 6000793.5299 | 2112868.6894 | 37.781578670102704 | -122.440904680944 | (37.7815786701027, -122.440904680944) | ||
| 9496 | 9496 | 19512 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6000653.0003 | 2112676.212 | 37.781042171769705 | -122.441377029637 | (37.7810421717697, -122.441377029637) | |||
| 9540 | 9540 | 26551 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000745.8124 | 2112342.7819 | 37.780131944670295 | -122.441032019327 | (37.7801319446703, -122.441032019327) | |||
| 9548 | 9548 | 22798 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 16 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000767.4714 | 2112175.6015 | 37.7796741435255 | -122.440945094511 | (37.7796741435255, -122.440945094511) | |||
| 9560 | 9560 | 19503 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6000748.1814 | 2112325.5224 | 37.78008468941729 | -122.441022585328 | (37.7800846894173, -122.441022585328) | |||
| 9877 | 9877 | 28444 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1995 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5993681.5609 | 2092723.2933 | 37.725856971051 | -122.464045665001 | (37.725856971051, -122.464045665001) | ||
| 10142 | 10142 | 10120 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 851 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005704.55717 | 2103950.70668 | 37.7573705007718 | -122.42328071642599 | (37.7573705007718, -122.423280716426) | ||
| 10296 | 10296 | 15853 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5318 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3x3 | 5999670.30739 | 2088411.8860799999 | 37.7143621622611 | -122.44303356793999 | (37.7143621622611, -122.44303356794) | ||
| 10359 | 10359 | 26782 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6010979.6007 | 2087065.0465 | 37.711302344066 | -122.403849252944 | (37.711302344066, -122.403849252944) | ||||
| 10473 | 10473 | 15795 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4929 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1995 12:00:00 AM | 6 | 3x3 | 6000991.1672 | 2090255.6537 | 37.7194999571484 | -122.438600194662 | (37.7194999571484, -122.438600194662) | ||
| 10523 | 10523 | 15830 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5169 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2007 12:00:00 AM | 3 | 3X3 | 6000193.89224 | 2088987.9069599998 | 37.715973625047205 | -122.44126516177 | (37.7159736250472, -122.44126516177) | ||
| 10589 | 10589 | 15891 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5630 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1995 12:00:00 AM | 3 | 3x3 | 5998430.505059999 | 2087245.52015 | 37.711088819775895 | -122.44723490289499 | (37.7110888197759, -122.447234902895) | ||
| 10683 | 10683 | 15723 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4374 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/1995 12:00:00 AM | 6 | 3X3 | 6002783.0002 | 2093176.1526 | 37.7276207625859 | -122.432614991581 | (37.7276207625859, -122.432614991581) | ||
| 10686 | 10686 | 15870 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5440 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3x3 | 5999309.23485 | 2088003.6513200002 | 37.7132206482771 | -122.44425225454701 | (37.7132206482771, -122.444252254547) | ||
| 10820 | 10820 | 15852 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5312 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1995 12:00:00 AM | 6 | 3x3 | 5999685.48283 | 2088430.99674 | 37.714415501058 | -122.44298248737499 | (37.714415501058, -122.442982487375) |
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");