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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
3094 | 3094 | 253300 | Undocumented 2 | Tristania conferta :: 79 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5985769.0 | 2110141.0 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | ||||
3372 | 3372 | 101650 | Undocumented 2 | Tristania conferta :: 79 | 3X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5998828.7375 | 2112398.5369 | 37.780175655731796 | -122.447668041416 | (37.7801756557318, -122.447668041416) | |||
4388 | 4388 | 251703 | Undocumented 2 | Tristania conferta :: 79 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:45:00 AM | 3 | 3x3 | 6004216.0 | 2094352.0 | 37.7309305395323 | -122.42774483827299 | (37.7309305395323, -122.427744838273) | ||
7899 | 7899 | 101329 | Undocumented 2 | Tristania conferta :: 79 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.45081116588301 | (37.7780463265361, -122.450811165883) | |||
7966 | 7966 | 100969 | Undocumented 2 | Tristania conferta :: 79 | 418 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007656.9693 | 2112859.914 | 37.7819430807706 | -122.417159773401 | (37.7819430807706, -122.417159773401) | |||
9586 | 9586 | 115011 | Undocumented 2 | Tristania conferta :: 79 | 1600 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001663.1427 | 2114000.6718 | 37.784736294492795 | -122.437977348952 | (37.7847362944928, -122.437977348952) | |||
22810 | 22810 | 141129 | Undocumented 2 | Tristania conferta :: 79 | 1740 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002454.9272 | 2113020.8946 | 37.782091069378296 | -122.43516793707701 | (37.7820910693783, -122.435167937077) | |||
22844 | 22844 | 141842 | Undocumented 2 | Tristania conferta :: 79 | 1268 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004263.4746 | 2112800.275 | 37.7815878353953 | -122.42889544965401 | (37.7815878353953, -122.428895449654) | |||
23419 | 23419 | 141308 | Undocumented 2 | Tristania conferta :: 79 | 217 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998909.1127 | 2112249.8005 | 37.7797718573521 | -122.44737927944401 | (37.7797718573521, -122.447379279444) | |||
23565 | 23565 | 140557 | Undocumented 2 | Tristania conferta :: 79 | 1175 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003583.5208 | 2111740.6921 | 37.7786399751241 | -122.43117211119 | (37.7786399751241, -122.43117211119) | |||
23573 | 23573 | 143104 | Undocumented 2 | Tristania conferta :: 79 | 1736 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010039.5193 | 2120117.0378 | 37.8020031344426 | -122.40942953292802 | (37.8020031344426, -122.409429532928) | |||
23809 | 23809 | 139263 | Undocumented 2 | Tristania conferta :: 79 | 760 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004028.8382 | 2111306.0158 | 37.7774716865894 | -122.42960057778 | (37.7774716865894, -122.42960057778) | |||
24026 | 24026 | 140096 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005837.0353 | 2111584.8045 | 37.7783393900211 | -122.42336524088002 | (37.7783393900211, -122.42336524088) | |||
24280 | 24280 | 143114 | Undocumented 2 | Tristania conferta :: 79 | 1463 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005363.4287 | 2119869.54 | 37.801060458669795 | -122.42559341080499 | (37.8010604586698, -122.425593410805) | |||
25095 | 25095 | 139803 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005645.0945 | 2112991.4978 | 37.7821909905379 | -122.42412930203699 | (37.7821909905379, -122.424129302037) | |||
25138 | 25138 | 138681 | Undocumented 2 | Tristania conferta :: 79 | 3050 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999237.6946 | 2114657.8109999998 | 37.786402399412 | -122.44641585719 | (37.786402399412, -122.44641585719) | |||
25260 | 25260 | 137791 | Undocumented 2 | Tristania conferta :: 79 | 1711 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005267.8978 | 2115649.4507 | 37.789467764436395 | -122.425623465766 | (37.7894677644364, -122.425623465766) | |||
25264 | 25264 | 142786 | Undocumented 2 | Tristania conferta :: 79 | 730 POLK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007071.7839 | 2113562.2092 | 37.7838384745362 | -122.419234083256 | (37.7838384745362, -122.419234083256) | |||
25828 | 25828 | 122838 | Undocumented 2 | Tristania conferta :: 79 | 945 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2x3 | 6001931.7611 | 2111776.6298 | 37.7786449107474 | -122.436888748547 | (37.7786449107474, -122.436888748547) | |||
25880 | 25880 | 121013 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015189.8844 | 2115534.4395 | 37.78970761539271 | -122.39128615684099 | (37.7897076153927, -122.391286156841) | |||
26024 | 26024 | 245425 | Undocumented 2 | Tristania conferta :: 79 | 2500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009073.1901 | 2106875.611 | 37.7655911583595 | -122.411837285128 | (37.7655911583595, -122.411837285128) | |||
26424 | 26424 | 143385 | Undocumented 2 | Tristania conferta :: 79 | 1658 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004429.3589 | 2119821.4466 | 37.800875583620794 | -122.428822263738 | (37.8008755836208, -122.428822263738) | |||
26560 | 26560 | 245957 | Undocumented 2 | Tristania conferta :: 79 | 850 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997681.1316 | 2107596.9911 | 37.7669261962578 | -122.451291725243 | (37.7669261962578, -122.451291725243) | |||
26582 | 26582 | 244213 | Undocumented 2 | Tristania conferta :: 79 | 322 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004508.1464 | 2109493.0779 | 37.7725209302455 | -122.427813281818 | (37.7725209302455, -122.427813281818) | |||
26584 | 26584 | 137902 | Undocumented 2 | Tristania conferta :: 79 | 404 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005251.6199 | 2115313.5756 | 37.788544615646 | -122.425655870363 | (37.788544615646, -122.425655870363) | |||
26798 | 26798 | 199951 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016408.6882 | 2092795.6787 | 37.7273393636102 | -122.38548388280701 | (37.7273393636102, -122.385483882807) | |||
27173 | 27173 | 247332 | Undocumented 2 | Tristania conferta :: 79 | 755 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003759.8807 | 2110373.3337 | 37.7748955391679 | -122.430464426106 | (37.7748955391679, -122.430464426106) | |||
27596 | 27596 | 139676 | Undocumented 2 | Tristania conferta :: 79 | 2130 O'Farrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000922.1046 | 2113153.0063 | 37.782366653551605 | -122.44048027276199 | (37.7823666535516, -122.440480272762) | |||
27680 | 27680 | 142315 | Undocumented 2 | Tristania conferta :: 79 | 1679 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999782.049 | 2110521.1531 | 37.7750752776396 | -122.444235164846 | (37.7750752776396, -122.444235164846) | |||
27736 | 27736 | 140098 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005841.2329 | 2111549.6492 | 37.7782430990341 | -122.42334822002701 | (37.7782430990341, -122.423348220027) | |||
27756 | 27756 | 199895 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016530.9767 | 2093031.4421 | 37.7279934886935 | -122.38507754718599 | (37.7279934886935, -122.385077547186) | |||
27762 | 27762 | 141282 | Undocumented 2 | Tristania conferta :: 79 | 311 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998168.815 | 2112585.6841 | 37.780651775237395 | -122.44996449635201 | (37.7806517752374, -122.449964496352) | |||
27820 | 27820 | 95598 | Undocumented 2 | Tristania conferta :: 79 | 1625 Carroll Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013982.6065 | 2092044.9941 | 37.725143606345206 | -122.393818384028 | (37.7251436063452, -122.393818384028) | |||
27993 | 27993 | 138916 | Undocumented 2 | Tristania conferta :: 79 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | |||
28165 | 28165 | 244387 | Undocumented 2 | Tristania conferta :: 79 | 877 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003242.3169 | 2110300.201 | 37.774665402715705 | -122.432249563339 | (37.7746654027157, -122.432249563339) | |||
28177 | 28177 | 244436 | Undocumented 2 | Tristania conferta :: 79 | 404 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004598.6589 | 2109671.3511 | 37.7730155449031 | -122.42751289271999 | (37.7730155449031, -122.42751289272) | |||
28226 | 28226 | 141974 | Undocumented 2 | Tristania conferta :: 79 | 620 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004711.5378 | 2111604.9174 | 37.778331029000505 | -122.42726018965 | (37.7783310290005, -122.42726018965) | |||
28676 | 28676 | 83783 | Undocumented 2 | Tristania conferta :: 79 | 606 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2006 12:00:00 AM | 4 | 6004048.7127 | 2110839.5763 | 37.7761920840099 | -122.42949855269899 | (37.7761920840099, -122.429498552699) | ||
28713 | 28713 | 199660 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014919.1748 | 2090797.1689 | 37.7217693287026 | -122.390493586774 | (37.7217693287026, -122.390493586774) | |||
28789 | 28789 | 141775 | Undocumented 2 | Tristania conferta :: 79 | 1330 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003753.6876 | 2113301.7561 | 37.7829359095028 | -122.430694865244 | (37.7829359095028, -122.430694865244) | |||
28829 | 28829 | 200962 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013974.3728 | 2092581.6444 | 37.726616682460204 | -122.393884395326 | (37.7266166824602, -122.393884395326) | |||
29166 | 29166 | 137923 | Undocumented 2 | Tristania conferta :: 79 | 1901 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003379.2097 | 2115283.9028 | 37.788357161353105 | -122.432131998946 | (37.7883571613531, -122.432131998946) | |||
29369 | 29369 | 199905 | Undocumented 2 | Tristania conferta :: 79 | 1298 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6016747.5421 | 2093255.8132 | 37.7286215447387 | -122.38434448732599 | (37.7286215447387, -122.384344487326) | |||
29400 | 29400 | 141784 | Undocumented 2 | Tristania conferta :: 79 | 1380 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003871.6154 | 2112872.0612 | 37.7817627549494 | -122.43025621822599 | (37.7817627549494, -122.430256218226) | |||
29635 | 29635 | 200799 | Undocumented 2 | Tristania conferta :: 79 | 5307 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014333.8188 | 2093306.6984 | 37.7286275041699 | -122.39269249263599 | (37.7286275041699, -122.392692492636) | |||
29984 | 29984 | 140324 | Undocumented 2 | Tristania conferta :: 79 | 1465 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004553.8078 | 2113880.8448 | 37.784571240321604 | -122.42796805864799 | (37.7845712403216, -122.427968058648) | |||
30044 | 30044 | 140524 | Undocumented 2 | Tristania conferta :: 79 | 1140 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003674.0233 | 2111802.6448 | 37.778815210032 | -122.430863450741 | (37.778815210032, -122.430863450741) | |||
30128 | 30128 | 141814 | Undocumented 2 | Tristania conferta :: 79 | 621 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004559.3867 | 2113103.2378 | 37.782436440597294 | -122.42789332920499 | (37.7824364405973, -122.427893329205) | |||
30173 | 30173 | 199711 | Undocumented 2 | Tristania conferta :: 79 | 1510 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015245.4888 | 2092572.1176 | 37.7266610833371 | -122.389489489481 | (37.7266610833371, -122.389489489481) | |||
30368 | 30368 | 138199 | Undocumented 2 | Tristania conferta :: 79 | 180 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998946.8467 | 2112434.5788 | 37.7802813669123 | -122.44726204408501 | (37.7802813669123, -122.447262044085) | |||
30584 | 30584 | 142354 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005306.3187 | 2113367.185 | 37.7832034013247 | -122.42532805791599 | (37.7832034013247, -122.425328057916) | |||
30658 | 30658 | 140638 | Undocumented 2 | Tristania conferta :: 79 | 472 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996864.7991 | 2109972.3061 | 37.7734014220919 | -122.45428686398199 | (37.7734014220919, -122.454286863982) | |||
30730 | 30730 | 142336 | Undocumented 2 | Tristania conferta :: 79 | 1696 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999780.0519 | 2110221.7447 | 37.7742530643991 | -122.444220553239 | (37.7742530643991, -122.444220553239) | |||
30896 | 30896 | 138911 | Undocumented 2 | Tristania conferta :: 79 | 723 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004266.8521 | 2110794.1209 | 37.776079623036 | -122.428740708053 | (37.776079623036, -122.428740708053) | |||
30915 | 30915 | 142286 | Undocumented 2 | Tristania conferta :: 79 | 1670 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999804.9802 | 2110571.1381 | 37.7752138319513 | -122.444159433615 | (37.7752138319513, -122.444159433615) | |||
30969 | 30969 | 140095 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005831.7882 | 2111608.4162 | 37.77840392585679 | -122.423385071553 | (37.7784039258568, -122.423385071553) | |||
30970 | 30970 | 141807 | Undocumented 2 | Tristania conferta :: 79 | 1398 WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004301.1437 | 2113069.4068 | 37.7823289364611 | -122.42878432451201 | (37.7823289364611, -122.428784324512) | |||
31370 | 31370 | 201231 | Undocumented 2 | Tristania conferta :: 79 | 405 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014377.5686 | 2114753.9994 | 37.787519592158496 | -122.39404205332899 | (37.7875195921585, -122.394042053329) | |||
31503 | 31503 | 142082 | Undocumented 2 | Tristania conferta :: 79 | 1593 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000216.454 | 2110924.9728 | 37.776208837743894 | -122.442761469865 | (37.7762088377439, -122.442761469865) | |||
31547 | 31547 | 187235 | Undocumented 2 | Tristania conferta :: 79 | 2401 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984966.2222 | 2098610.2885 | 37.7415149514197 | -122.494607336605 | (37.7415149514197, -122.494607336605) | |||
31611 | 31611 | 137788 | Undocumented 2 | Tristania conferta :: 79 | 1711 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005258.2038 | 2115760.6088 | 37.789772428971 | -122.425664920751 | (37.789772428971, -122.425664920751) | |||
31667 | 31667 | 199657 | Undocumented 2 | Tristania conferta :: 79 | 1395 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015062.4933 | 2090889.5822 | 37.7220310269415 | -122.39000462027599 | (37.7220310269415, -122.390004620276) | |||
31989 | 31989 | 140231 | Undocumented 2 | Tristania conferta :: 79 | 2227 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997121.9683 | 2110490.0939 | 37.774837877214104 | -122.45343467561199 | (37.7748378772141, -122.453434675612) | |||
32015 | 32015 | 184222 | Undocumented 2 | Tristania conferta :: 79 | 3521 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983907.1382 | 2104926.4256 | 37.7587952746185 | -122.49873571831999 | (37.7587952746185, -122.49873571832) | |||
32255 | 32255 | 247284 | Undocumented 2 | Tristania conferta :: 79 | 1432 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999197.6689 | 2108750.6497 | 37.7701805691053 | -122.44612927641501 | (37.7701805691053, -122.446129276415) | |||
32291 | 32291 | 140132 | Undocumented 2 | Tristania conferta :: 79 | 501 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005852.7764 | 2111465.1717 | 37.778011795869006 | -122.42330228001002 | (37.778011795869, -122.42330228001) | |||
32382 | 32382 | 200015 | Undocumented 2 | Tristania conferta :: 79 | 1021 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6018293.9123 | 2092319.9509 | 37.7261372321338 | -122.37893357191099 | (37.7261372321338, -122.378933571911) | |||
32392 | 32392 | 137777 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001052.3759 | 2111729.7512 | 37.7784661743304 | -122.439927511873 | (37.7784661743304, -122.439927511873) | |||
32620 | 32620 | 199933 | Undocumented 2 | Tristania conferta :: 79 | 1898 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016396.5695 | 2092856.2721 | 37.7275050706356 | -122.385529998516 | (37.7275050706356, -122.385529998516) | |||
32804 | 32804 | 137881 | Undocumented 2 | Tristania conferta :: 79 | 1859 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005045.9205 | 2115408.4016 | 37.7887933587006 | -122.42637431353201 | (37.7887933587006, -122.426374313532) | |||
32931 | 32931 | 142689 | Undocumented 2 | Tristania conferta :: 79 | 554 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008629.0451 | 2121101.0906 | 37.8046259673251 | -122.414380126753 | (37.8046259673251, -122.414380126753) | |||
32990 | 32990 | 141276 | Undocumented 2 | Tristania conferta :: 79 | 351 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998048.3369 | 2112566.7325 | 37.780592844686204 | -122.45037991931999 | (37.7805928446862, -122.45037991932) | |||
33025 | 33025 | 140323 | Undocumented 2 | Tristania conferta :: 79 | 1465 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004546.9673 | 2113926.2686 | 37.78469557575121 | -122.42799496248001 | (37.7846955757512, -122.42799496248) | |||
33091 | 33091 | 200934 | Undocumented 2 | Tristania conferta :: 79 | 4220 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015398.3252 | 2097166.7998 | 37.73928562681979 | -122.38928183799801 | (37.7392856268198, -122.389281837998) | |||
33237 | 33237 | 200504 | Undocumented 2 | Tristania conferta :: 79 | 5835 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6013821.0176 | 2091948.8219 | 37.7248705556165 | -122.394370253635 | (37.7248705556165, -122.394370253635) | |||
33384 | 33384 | 141091 | Undocumented 2 | Tristania conferta :: 79 | 194 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996268.2382 | 2112980.2839 | 37.78162630877429 | -122.456568006554 | (37.7816263087743, -122.456568006554) | |||
33862 | 33862 | 142046 | Undocumented 2 | Tristania conferta :: 79 | 365 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005924.2473 | 2110971.3816 | 37.7766600015096 | -122.42301993075 | (37.7766600015096, -122.42301993075) | |||
34095 | 34095 | 137898 | Undocumented 2 | Tristania conferta :: 79 | 1826 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003442.8192 | 2115139.0382 | 37.787963006088 | -122.43190157246599 | (37.787963006088, -122.431901572466) | |||
34259 | 34259 | 199768 | Undocumented 2 | Tristania conferta :: 79 | 2029 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016150.937999999 | 2092445.1351 | 37.7263625758948 | -122.386350503257 | (37.7263625758948, -122.386350503257) | |||
34345 | 34345 | 200150 | Undocumented 2 | Tristania conferta :: 79 | 6199 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013507.0577 | 2091126.6395 | 37.7225955506276 | -122.39539801261499 | (37.7225955506276, -122.395398012615) | |||
34727 | 34727 | 200931 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015563.8928 | 2097421.6465 | 37.7399945612986 | -122.388727159879 | (37.7399945612986, -122.388727159879) | |||
34740 | 34740 | 199817 | Undocumented 2 | Tristania conferta :: 79 | 2224 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015723.8893 | 2091960.1023 | 37.7250071238567 | -122.38779297577899 | (37.7250071238567, -122.387792975779) | |||
34767 | 34767 | 143135 | Undocumented 2 | Tristania conferta :: 79 | 2684 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999523.0401 | 2119140.8402 | 37.79872790718311 | -122.445751158267 | (37.7987279071831, -122.445751158267) | |||
34825 | 34825 | 141281 | Undocumented 2 | Tristania conferta :: 79 | 313 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998146.1408 | 2112582.9767 | 37.7806430439961 | -122.45004274172301 | (37.7806430439961, -122.450042741723) | |||
35023 | 35023 | 142363 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005513.0496 | 2113400.4215 | 37.783306337940104 | -122.424615216414 | (37.7833063379401, -122.424615216414) | |||
35592 | 35592 | 140677 | Undocumented 2 | Tristania conferta :: 79 | 1307 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004183.5277 | 2113015.8026 | 37.7821750951609 | -122.429187400422 | (37.7821750951609, -122.429187400422) | |||
35787 | 35787 | 245464 | Undocumented 2 | Tristania conferta :: 79 | 2601 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008830.1741 | 2106813.5651 | 37.76540715826 | -122.41267343991501 | (37.76540715826, -122.412673439915) | |||
35829 | 35829 | 139042 | Undocumented 2 | Tristania conferta :: 79 | 1434 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6000193.0745 | 2113977.6097 | 37.7845892631082 | -122.443061626662 | (37.7845892631082, -122.443061626662) | |||
35868 | 35868 | 200953 | Undocumented 2 | Tristania conferta :: 79 | 5500 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014062.5698 | 2092818.2823 | 37.7272713435214 | -122.393596053817 | (37.7272713435214, -122.393596053817) | |||
35924 | 35924 | 245151 | Undocumented 2 | Tristania conferta :: 79 | 1284 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000426.3463 | 2109267.6081 | 37.7716700963199 | -122.441916413459 | (37.7716700963199, -122.441916413459) | |||
36884 | 36884 | 200917 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6015704.1884 | 2097889.2984 | 37.741286412301505 | -122.38827470136299 | (37.7412864123015, -122.388274701363) | |||
37109 | 37109 | 201883 | Undocumented 2 | Tristania conferta :: 79 | 199 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015205.3081 | 2115545.7503 | 37.789739528214504 | -122.391233582889 | (37.7897395282145, -122.391233582889) | |||
37194 | 37194 | 140157 | Undocumented 2 | Tristania conferta :: 79 | 1812 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998760.1707 | 2109729.1176 | 37.7728421986481 | -122.447713021916 | (37.7728421986481, -122.447713021916) | |||
37347 | 37347 | 141355 | Undocumented 2 | Tristania conferta :: 79 | 501 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002140.2005 | 2110240.1427 | 37.7744379464273 | -122.436057700577 | (37.7744379464273, -122.436057700577) | |||
37454 | 37454 | 137840 | Undocumented 2 | Tristania conferta :: 79 | 1800X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
37768 | 37768 | 142368 | Undocumented 2 | Tristania conferta :: 79 | 1061 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005592.1525 | 2113362.5319 | 37.783206769497596 | -122.424338855729 | (37.7832067694976, -122.424338855729) | |||
37804 | 37804 | 140034 | Undocumented 2 | Tristania conferta :: 79 | 950 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001975.5646 | 2111780.2801 | 37.7786574230551 | -122.436737476963 | (37.7786574230551, -122.436737476963) | |||
37899 | 37899 | 138525 | Undocumented 2 | Tristania conferta :: 79 | 1608 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001648.301 | 2114083.6756 | 37.78496335768929 | -122.438034643925 | (37.7849633576893, -122.438034643925) | |||
38276 | 38276 | 141234 | Undocumented 2 | Tristania conferta :: 79 | 22 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996538.8064 | 2114429.9137 | 37.7856221373365 | -122.455736793232 | (37.7856221373365, -122.455736793232) |
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");