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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
168469 | 168469 | 125534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010079.0906 | 2116883.16981 | 37.793125940953004 | -122.409064282098 | (37.793125940953, -122.409064282098) | |||
168173 | 168173 | 125468 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1177 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6008726.14199 | 2116272.16952 | 37.7913723996763 | -122.413702344902 | (37.7913723996763, -122.413702344902) | |||
167943 | 167943 | 31087 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 61 Pearl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34823 | 6005643.9795699995 | 2108712.30745 | 37.7704413103375 | -122.42382878848 | (37.7704413103375, -122.42382878848) | |
167745 | 167745 | 220613 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 919 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007605.87187 | 2104275.7103 | 37.7583700063988 | -122.416728224545 | (37.7583700063988, -122.416728224545) | |||
167329 | 167329 | 203458 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5993554.49033 | 2093381.1926 | 37.7276560774418 | -122.464532684353 | (37.7276560774418, -122.464532684353) | |||
167284 | 167284 | 125445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | |||
167219 | 167219 | 203460 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 451 Hearst Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998498.644119999 | 2094367.6439099999 | 37.730648417773104 | -122.44751172680901 | (37.7306484177731, -122.447511726809) | |||
167060 | 167060 | 125489 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1322 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007615.8266900005 | 2115821.7314400002 | 37.7900731949784 | -122.417512084408 | (37.7900731949784, -122.417512084408) | |||
166425 | 166425 | 189184 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6013459.66135 | 2110901.5969 | 37.776890721054 | -122.396947645136 | (37.776890721054, -122.396947645136) | |||
165596 | 165596 | 125497 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1154 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6006282.866880001 | 2120431.59702 | 37.8026556331117 | -122.422451714169 | (37.8026556331117, -122.422451714169) | |||
165566 | 165566 | 203486 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.088169999 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | |||
164866 | 164866 | 125484 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.41756103092699 | (37.796373807471, -122.417561030927) | ||||
164426 | 164426 | 125476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009246.74599 | 2116823.51326 | 37.792915476223705 | -122.41194003791 | (37.7929154762237, -122.41194003791) | |||
164200 | 164200 | 189164 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Pennsylvania Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6014453.294530001 | 2102557.3777799997 | 37.754034584334605 | -122.392926403935 | (37.7540345843346, -122.392926403935) | ||||
164035 | 164035 | 203455 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | |||
163606 | 163606 | 220643 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009355.21688 | 2097375.10372 | 37.739520706418396 | -122.410190999519 | (37.7395207064184, -122.410190999519) | |||
163571 | 163571 | 203488 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 296 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996843.32855 | 2096168.5125900002 | 37.735498433689706 | -122.45336434200199 | (37.7354984336897, -122.453364342002) | |||
163457 | 163457 | 189152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1665 Hudson Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6015368.44602 | 2097645.0372099997 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | |||
163005 | 163005 | 203456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 89 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5993632.52713 | 2093523.8641700002 | 37.7280523169437 | -122.46427326591001 | (37.7280523169437, -122.46427326591) | |||
162716 | 162716 | 125448 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3057 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005070.86935 | 2120497.70862 | 37.8027687129688 | -122.426650549882 | (37.8027687129688, -122.426650549882) | |||
161839 | 161839 | 125503 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6007472.5485 | 2120196.7006200003 | 37.802077707171605 | -122.418318141382 | (37.8020777071716, -122.418318141382) | |||
161762 | 161762 | 220642 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008547.4442300005 | 2096175.62445 | 37.7361818869891 | -122.41289915230101 | (37.7361818869891, -122.412899152301) | |||
161599 | 161599 | 125530 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010077.8438099995 | 2116891.68093 | 37.7931492405824 | -122.40906919691002 | (37.7931492405824, -122.40906919691) | |||
161535 | 161535 | 95678 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 307 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767430 | 6009637.5069 | 2092959.36639 | 37.7274118548521 | -122.40890349142799 | (37.7274118548521, -122.408903491428) |
161472 | 161472 | 203494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 363 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999675.09138 | 2094930.6164 | 37.732261369848 | -122.443485006944 | (37.732261369848, -122.443485006944) | |||
161024 | 161024 | 44822 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 209 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2001 12:00:00 AM | 1 | Permit Number 43915 | 5993346.02796 | 2114050.28592 | 37.784396036829705 | -122.46675518501101 | (37.7843960368297, -122.466755185011) | ||
160711 | 160711 | 175159 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000090.185269999 | 2092307.21266 | 37.7250817743959 | -122.441861717141 | (37.7250817743959, -122.441861717141) | |||
160402 | 160402 | 203463 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 112 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6000775.43585 | 2094454.02267 | 37.731015444602896 | -122.43964672024099 | (37.7310154446029, -122.439646720241) | |||
160138 | 160138 | 125525 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6011203.66326 | 2120729.63027 | 37.8037503211682 | -122.405444189817 | (37.8037503211682, -122.405444189817) | |||
160003 | 160003 | 99402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2200X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | |
159610 | 159610 | 249987 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011587.32256 | 2120104.99043 | 37.802056656736 | -122.404072522227 | (37.802056656736, -122.404072522227) | |||
159436 | 159436 | 51699 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 270 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 4 | Permit Number 47975 | 6009229.913509999 | 2094736.03223 | 37.7322673611424 | -122.410437947053 | (37.7322673611424, -122.410437947053) | ||
159347 | 159347 | 220623 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6000335.70641 | 2101336.8621 | 37.7498890559574 | -122.44166069529699 | (37.7498890559574, -122.441660695297) | |||
159116 | 159116 | 32706 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37107 | 6007669.19829 | 2115867.15124 | 37.790200909505 | -122.417330642617 | (37.790200909505, -122.417330642617) | |
159071 | 159071 | 125499 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007355.47144 | 2119286.0885099997 | 37.799570804701396 | -122.418658671469 | (37.7995708047014, -122.418658671469) | ||||
158252 | 158252 | 221757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Seward St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6001069.49524 | 2104258.14697 | 37.7579519799282 | -122.43933259334699 | (37.7579519799282, -122.439332593347) | |||
157854 | 157854 | 203451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1515 16th Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | |||
157605 | 157605 | 220640 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 821 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007587.8208800005 | 2095563.9191 | 37.7344483655074 | -122.416173662982 | (37.7344483655074, -122.416173662982) | |||
157432 | 157432 | 220650 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6008081.1542 | 2099392.86215 | 37.744989527842996 | -122.41473892687999 | (37.744989527843, -122.41473892688) | |||
157223 | 157223 | 123467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 708 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995387.69315 | 2110690.84094 | 37.775289512367 | -122.45944839629601 | (37.775289512367, -122.459448396296) | |||
157035 | 157035 | 125454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002093.86703 | 2117345.7842200003 | 37.7939455983674 | -122.43672672227 | (37.7939455983674, -122.43672672227) | |||
156515 | 156515 | 220626 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 665 Elizabeth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6002107.5344 | 2102041.80892 | 37.7519254645963 | -122.43558406527599 | (37.7519254645963, -122.435584065276) | |||
156178 | 156178 | 33132 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) |
156172 | 156172 | 249529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | |||
156031 | 156031 | 220594 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008571.39642 | 2107977.23283 | 37.768587792328894 | -122.413650808341 | (37.7685877923289, -122.413650808341) | |||
156002 | 156002 | 220591 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Pearl St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005640.71146 | 2108782.82006 | 37.770634736546896 | -122.42384510757601 | (37.7706347365469, -122.423845107576) | |||
155868 | 155868 | 125451 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2601 Vallejo St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001095.19419 | 2117566.7818299998 | 37.7944955940578 | -122.44019807567499 | (37.7944955940578, -122.440198075675) | |||
155798 | 155798 | 203493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 227 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999314.08769 | 2095746.28692 | 37.7344804146435 | -122.444791684116 | (37.7344804146435, -122.444791684116) | |||
155489 | 155489 | 125460 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | |||
155006 | 155006 | 221772 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 71 Miguel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003850.95701 | 2097297.26656 | 37.7389969178725 | -122.429216785123 | (37.7389969178725, -122.429216785123) | |||
154983 | 154983 | 125471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 655 Powell St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6010076.95545 | 2116019.41648 | 37.7907541634305 | -122.409010696908 | (37.7907541634305, -122.409010696908) | |||
154701 | 154701 | 220611 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009641.7814 | 2098664.7156700003 | 37.743077758937105 | -122.40929116218399 | (37.7430777589371, -122.409291162184) | |||
154615 | 154615 | 249823 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010881.14413 | 2120640.5408 | 37.8034876651725 | -122.406554008974 | (37.8034876651725, -122.406554008974) | |||
154495 | 154495 | 175170 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 364 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004288.38035 | 2091053.9849099999 | 37.7218790151804 | -122.427259769545 | (37.7218790151804, -122.427259769545) | |||
154406 | 154406 | 221753 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 466 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003367.55908 | 2102748.60922 | 37.7539376572014 | -122.431277170628 | (37.7539376572014, -122.431277170628) | |||
153900 | 153900 | 203467 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 480 Hearst Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 5998177.872280001 | 2094421.44457 | 37.730777805043104 | -122.448624552388 | (37.7307778050431, -122.448624552388) | |||
153719 | 153719 | 125456 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2401 Broadway | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002104.20596 | 2117349.59529 | 37.79395665014079 | -122.436691221543 | (37.7939566501408, -122.436691221543) | |||
153546 | 153546 | 221756 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3649 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004058.63602 | 2103618.7990900003 | 37.7563661334022 | -122.42894929977699 | (37.7563661334022, -122.428949299777) | |||
153001 | 153001 | 92753 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999299.39389 | 2120397.7877700003 | 37.802166375831106 | -122.446615526285 | (37.8021663758311, -122.446615526285) | |
152994 | 152994 | 37651 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1707 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 11 | Permit Number 40063 | 5990221.82835 | 2111258.8860400002 | 37.776550828957504 | -122.477359640658 | (37.7765508289575, -122.477359640658) | |
152920 | 152920 | 203479 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 90 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993668.24229 | 2093512.36945 | 37.7280228137991 | -122.464148964325 | (37.7280228137991, -122.464148964325) | |||
152559 | 152559 | 189178 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6012651.667780001 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | |||
152269 | 152269 | 220631 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 901 Elizabeth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6000591.194080001 | 2101959.06133 | 37.751612018500204 | -122.440821836477 | (37.7516120185002, -122.440821836477) | |||
152079 | 152079 | 220653 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008119.35429 | 2096079.0254799998 | 37.7358926083592 | -122.41437240636002 | (37.7358926083592, -122.41437240636) | |||
151503 | 151503 | 248095 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010444.10359 | 2099844.52048 | 37.746362164885 | -122.406600056945 | (37.746362164885, -122.406600056945) | |||
151339 | 151339 | 189154 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.781315772258104 | -122.401025754031 | (37.7813157722581, -122.401025754031) | |||
151252 | 151252 | 125507 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 7 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008925.22265 | 2118571.08085 | 37.7976958234636 | -122.41317615966801 | (37.7976958234636, -122.413176159668) | |||
151194 | 151194 | 220621 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 714 Duncan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001868.87894 | 2099747.43156 | 37.745612090735506 | -122.43624518748999 | (37.7456120907355, -122.43624518749) | |||
150901 | 150901 | 220636 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 628 Chenery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002799.74223 | 2095713.6411400002 | 37.734589079726 | -122.43273830362699 | (37.734589079726, -122.432738303627) | |||
150893 | 150893 | 189163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2324 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6010839.472159999 | 2105097.2568200002 | 37.7608071304715 | -122.405602811334 | (37.7608071304715, -122.405602811334) | |||
150526 | 150526 | 125502 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1001 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6007468.42884 | 2120195.8771599997 | 37.8020752142594 | -122.41833233898701 | (37.8020752142594, -122.418332338987) | |||
150463 | 150463 | 125478 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 150 Sproule Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009235.21214 | 2116893.1375 | 37.79310600030529 | -122.411984868232 | (37.7931060003053, -122.411984868232) | |||
150359 | 150359 | 125533 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010078.6629 | 2116885.41787 | 37.7931320896218 | -122.40906592066901 | (37.7931320896218, -122.409065920669) | |||
150229 | 150229 | 125458 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2371 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6002284.26434 | 2117368.32549 | 37.794018309436396 | -122.436069543591 | (37.7940183094364, -122.436069543591) | |||
149936 | 149936 | 125536 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010079.474780001 | 2116878.80155 | 37.7931139682908 | -122.40906264443899 | (37.7931139682908, -122.409062644439) | |||
149887 | 149887 | 175169 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 728 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009133.75655 | 2092888.51191 | 37.7271890729929 | -122.41063996266001 | (37.7271890729929, -122.41063996266) | |||
149835 | 149835 | 125493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6006021.473809999 | 2120333.6545700002 | 37.8023719590496 | -122.42334930055401 | (37.8023719590496, -122.423349300554) | |||
149721 | 149721 | 125500 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 12 Hastings Ter | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6007269.76384 | 2119273.06582 | 37.7995302219096 | -122.41895432719299 | (37.7995302219096, -122.418954327193) | ||||
149175 | 149175 | 249549 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6005525.061919999 | 2114997.09858 | 37.7876910959164 | -122.424687279516 | (37.7876910959164, -122.424687279516) | |||
149030 | 149030 | 79776 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.0863799998 | 37.75191893911521 | -122.401951552136 | (37.7519189391152, -122.401951552136) | |
149006 | 149006 | 175172 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003774.221480001 | 2091143.66189 | 37.7220961573958 | -122.42904347588998 | (37.7220961573958, -122.42904347589) | |||
148997 | 148997 | 125441 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3517 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6000221.62171 | 2120363.5906700003 | 37.8021251149445 | -122.443421726125 | (37.8021251149445, -122.443421726125) | |||
148949 | 148949 | 189196 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 30 15th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6012020.7847 | 2107509.88543 | 37.767497654832894 | -122.401686734167 | (37.7674976548329, -122.401686734167) | |||
148879 | 148879 | 249535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6006279.61488 | 2114039.5342599996 | 37.7851044469537 | -122.422008617322 | (37.7851044469537, -122.422008617322) | |||
148756 | 148756 | 249948 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011338.9869 | 2120052.71472 | 37.8018992421182 | -122.40492820376998 | (37.8018992421182, -122.40492820377) | |||
148423 | 148423 | 189174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 14 Waterville St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6011435.762019999 | 2096086.73565 | 37.7360995216629 | -122.40290674814301 | (37.7360995216629, -122.402906748143) | |||
148413 | 148413 | 203491 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.733744960750705 | -122.44270283418899 | (37.7337449607507, -122.442702834189) | |||
147992 | 147992 | 189169 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2098 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6011892.76134 | 2104699.04319 | 37.75977256567371 | -122.40193193701401 | (37.7597725656737, -122.401931937014) | |||
147861 | 147861 | 220661 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005456.84136 | 2096363.09768 | 37.7365226796806 | -122.423597969391 | (37.7365226796806, -122.423597969391) | |||
146408 | 146408 | 220630 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 901 Elizabeth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000579.189809999 | 2101957.47614 | 37.7516069822848 | -122.44086323496 | (37.7516069822848, -122.44086323496) | |||
145266 | 145266 | 39223 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 842 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 1 | Permit Number 42693 | 5982336.537280001 | 2109997.98133 | 37.77262806827861 | -122.50454323337 | (37.7726280682786, -122.50454323337) | |
145083 | 145083 | 16402 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | ||
145080 | 145080 | 33365 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 65 Manor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37497 | 5993537.09779252 | 2093371.5770822 | 37.7276286729381 | -122.46459211219299 | (37.7276286729381, -122.464592112193) | ||
144926 | 144926 | 33001 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 255 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | ||
144354 | 144354 | 69515 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 443 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 33643 | 6008794.13528985 | 2096723.61704292 | 37.737700399871294 | -122.412084952925 | (37.7377003998713, -122.412084952925) | ||
144315 | 144315 | 88208 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 607 Central Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51212 | 5999619.0 | 2110591.2 | 37.775258305073 | -122.444804221322 | (37.775258305073, -122.444804221322) | |||
143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
143899 | 143899 | 96060 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 101 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479.0 | 2099916.0 | 37.746560384348705 | -122.406484424587 | (37.7465603843487, -122.406484424587) | |
143853 | 143853 | 32707 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1005 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37107 | 6007675.42771265 | 2115829.29953352 | 37.7900973284958 | -122.41730640574801 | (37.7900973284958, -122.417306405748) | ||
143787 | 143787 | 16405 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 299X Myrtle St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.760559999 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) |
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");