Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 280 | 280 | 194427 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 1103 | 1103 | 211013 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.47222310103399 | (37.727880584217, -122.472223101034) | |||
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
| 4769 | 4769 | 194422 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 52 | Width 5ft | 6007901.53326 | 2109054.5781799997 | 37.771508291196 | -122.41604412194401 | (37.771508291196, -122.416044121944) | |||
| 9646 | 9646 | 114139 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9654 | 9654 | 114138 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/16/2016 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9658 | 9658 | 114124 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9665 | 9665 | 114123 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9672 | 9672 | 114137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1200X JUNIPERO SERRA BLVD | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9686 | 9686 | 173637 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1155 Market St | 99 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008672.0 | 2111900.0 | 37.779364436223 | -122.4135803097 | (37.779364436223, -122.4135803097) | ||||
| 9930 | 9930 | 173744 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
| 12961 | 12961 | 87019 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 10 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 18734 | 18734 | 94234 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 25615 | 25615 | 178137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992316.61451 | 2087859.0919400002 | 37.712422298533895 | -122.46841041712901 | (37.7124222985339, -122.468410417129) | |||
| 25884 | 25884 | 186251 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1701 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984830.2927 | 2103110.5403 | 37.7538634572036 | -122.495409148018 | (37.7538634572036, -122.495409148018) | |||
| 26747 | 26747 | 178177 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 167 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6004561.94872 | 2092421.1241099997 | 37.7256483463685 | -122.426411406667 | (37.7256483463685, -122.426411406667) | ||||
| 28596 | 28596 | 186468 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984781.1405 | 2103769.7876 | 37.755670689824704 | -122.495627747424 | (37.7556706898247, -122.495627747424) | |||
| 28677 | 28677 | 187129 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 0ft | 5985149.8207 | 2097410.2322 | 37.738230663406604 | -122.493884107972 | (37.7382306634066, -122.493884107972) | |||
| 29067 | 29067 | 211025 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 95 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991234.71561 | 2092082.53367 | 37.723956281843705 | -122.472457461651 | (37.7239562818437, -122.472457461651) | |||
| 29859 | 29859 | 178135 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992385.6999699995 | 2087851.7958799999 | 37.7124062555186 | -122.46817110840401 | (37.7124062555186, -122.468171108404) | |||
| 30200 | 30200 | 185930 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985039.332 | 2101497.8374 | 37.7494476553955 | -122.494567371863 | (37.7494476553955, -122.494567371863) | |||
| 33005 | 33005 | 211017 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991258.9422 | 2092457.39845 | 37.724986969654495 | -122.47240103009399 | (37.7249869696545, -122.472401030094) | |||
| 33800 | 33800 | 178161 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 16 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5993106.56964 | 2087853.50799 | 37.7124525633948 | -122.46567970845899 | (37.7124525633948, -122.465679708459) | |||
| 35161 | 35161 | 211021 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991241.40021 | 2092233.4270099998 | 37.7243709844069 | -122.472445349599 | (37.7243709844069, -122.472445349599) | |||
| 35365 | 35365 | 186855 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985186.2801 | 2096278.9071 | 37.735126479902895 | -122.49367471051 | (37.7351264799029, -122.49367471051) | |||
| 36257 | 36257 | 186440 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984767.7413 | 2103960.7256 | 37.7561941679911 | -122.495688168642 | (37.7561941679911, -122.495688168642) | |||
| 36495 | 36495 | 178150 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 21 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991622.99627 | 2087995.81221 | 37.71275761073721 | -122.47081770347401 | (37.7127576107372, -122.470817703474) | |||
| 37001 | 37001 | 185960 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984855.8243 | 2101346.8117 | 37.7490222380818 | -122.49519080130301 | (37.7490222380818, -122.495190801303) | |||
| 37263 | 37263 | 185562 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2201 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.299 | 2099768.8111 | 37.7446909699364 | -122.494986371806 | (37.7446909699364, -122.494986371806) | |||
| 37669 | 37669 | 211009 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 25 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991341.559830001 | 2093667.8062200001 | 37.728315229259 | -122.472203623507 | (37.728315229259, -122.472203623507) | |||
| 38117 | 38117 | 185308 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985001.1798 | 2097292.5499 | 37.737898841519105 | -122.494389354717 | (37.7378988415191, -122.494389354717) | |||
| 38392 | 38392 | 178159 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 14 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993218.97583 | 2087844.63687 | 37.7124346884772 | -122.465290557432 | (37.7124346884772, -122.465290557432) | |||
| 39074 | 39074 | 186875 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985206.2214 | 2096387.7822 | 37.7354265885186 | -122.493613787113 | (37.7354265885186, -122.493613787113) | |||
| 39138 | 39138 | 234477 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Grand View Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999979.4834199995 | 2101750.0189 | 37.751003181959895 | -122.442922193204 | (37.7510031819599, -122.442922193204) | ||||
| 39232 | 39232 | 132164 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011515.19186 | 2120799.8495099996 | 37.8039605395195 | -122.404371067467 | (37.8039605395195, -122.404371067467) | |||
| 40111 | 40111 | 178175 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989026.35056 | 2089515.5020599999 | 37.7167797908382 | -122.47990357931002 | (37.7167797908382, -122.47990357931) | ||||
| 40640 | 40640 | 178151 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5993597.52442 | 2087641.3827799999 | 37.7118984245322 | -122.46396744335199 | (37.7118984245322, -122.463967443352) | |||
| 40730 | 40730 | 178130 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5992655.54446 | 2087848.4586 | 37.7124126730818 | -122.4672382093 | (37.7124126730818, -122.4672382093) | |||
| 41068 | 41068 | 211024 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 94 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991236.61569 | 2092101.4351299999 | 37.7240082905392 | -122.472452270761 | (37.7240082905392, -122.472452270761) | |||
| 41214 | 41214 | 211038 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6001171.81546 | 2095754.02956 | 37.7346075158123 | -122.43836947339199 | (37.7346075158123, -122.438369473392) | ||||
| 44219 | 44219 | 186081 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1901 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984821.8866 | 2101948.8735 | 37.7506733477582 | -122.49535255189899 | (37.7506733477582, -122.495352551899) | |||
| 44224 | 44224 | 186691 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984728.0673 | 2105259.502 | 37.7597579231437 | -122.49592118002701 | (37.7597579231437, -122.495921180027) | |||
| 44889 | 44889 | 178131 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992618.59421 | 2087849.2354599999 | 37.7124126730667 | -122.46736597596501 | (37.7124126730667, -122.467365975965) | |||
| 44904 | 44904 | 211027 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 157 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991179.7136 | 2091396.7999900002 | 37.7220702434165 | -122.47259762098 | (37.7220702434165, -122.47259762098) | |||
| 45298 | 45298 | 186040 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1900 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985014.7934 | 2102133.6877 | 37.7511920899125 | -122.49469909773998 | (37.7511920899125, -122.49469909774) | |||
| 46130 | 46130 | 132162 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 165 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6010559.73859 | 2121313.26508 | 37.8053168133783 | -122.40771371440901 | (37.8053168133783, -122.407713714409) | ||||
| 47480 | 47480 | 194424 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 132 Kissling St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 5ft | 6007931.050980001 | 2109095.29996 | 37.77162176316789 | -122.41594490245599 | (37.7716217631679, -122.415944902456) | |||
| 49925 | 49925 | 186380 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1801 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984843.2782 | 2102467.9478 | 37.7520998356184 | -122.495316855331 | (37.7520998356184, -122.495316855331) | |||
| 50141 | 50141 | 178167 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992858.09731 | 2087851.4953400001 | 37.7124327018762 | -122.466538351485 | (37.7124327018762, -122.466538351485) | |||
| 50188 | 50188 | 178142 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991993.89623 | 2087943.0111099998 | 37.7126340744777 | -122.469531924782 | (37.7126340744777, -122.469531924782) | |||
| 50501 | 50501 | 211031 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2375 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5992617.61467 | 2099318.2887 | 37.743903802420505 | -122.468203163863 | (37.7439038024205, -122.468203163863) | |||
| 50538 | 50538 | 211012 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 35 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991334.380059999 | 2093575.3838 | 37.7280610448729 | -122.47222170976102 | (37.7280610448729, -122.472221709761) | |||
| 52632 | 52632 | 178132 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5992585.12632 | 2087848.18621 | 37.7124078599039 | -122.467481573927 | (37.7124078599039, -122.467481573927) | |||
| 53718 | 53718 | 187133 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985163.4571 | 2097445.4987 | 37.738328293602294 | -122.493839558913 | (37.7383282936023, -122.493839558913) | |||
| 54231 | 54231 | 181385 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984917.5854 | 2104501.8427 | 37.7576886993488 | -122.495209866912 | (37.7576886993488, -122.495209866912) | |||
| 54265 | 54265 | 185439 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2300 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985094.1378 | 2099479.3093 | 37.74390853380999 | -122.494229093058 | (37.74390853381, -122.494229093058) | |||
| 54409 | 54409 | 211016 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 46 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991242.43895 | 2092472.66575 | 37.7250279346749 | -122.472459191965 | (37.7250279346749, -122.472459191965) | |||
| 55771 | 55771 | 186733 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1250 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984855.8629 | 2106397.0571 | 37.7628888152225 | -122.49556310804701 | (37.7628888152225, -122.495563108047) | |||
| 56596 | 56596 | 211001 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996755.5114400005 | 2099350.67627 | 37.7442308453761 | -122.45389769125 | (37.7442308453761, -122.45389769125) | |||
| 56811 | 56811 | 178172 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988133.68649 | 2089845.1312099998 | 37.7176329668754 | -122.483013187625 | (37.7176329668754, -122.483013187625) | ||||
| 58985 | 58985 | 211040 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6001161.45161 | 2095717.9227900002 | 37.7345077855016 | -122.43840271862899 | (37.7345077855016, -122.438402718629) | ||||
| 61627 | 61627 | 211032 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 297 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993259.54182 | 2099680.27875 | 37.7449347888095 | -122.46600984507799 | (37.7449347888095, -122.466009845078) | |||
| 62726 | 62726 | 178147 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 18 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991814.6494 | 2087985.34878 | 37.712739962461 | -122.47015453351999 | (37.712739962461, -122.47015453352) | |||
| 63191 | 63191 | 234475 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 378 Highland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007368.44216 | 2096501.6263599999 | 37.7370107660349 | -122.41699854724101 | (37.7370107660349, -122.416998547241) | |||
| 63231 | 63231 | 185118 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.734388044102204 | -122.49217185843099 | (37.7343880441022, -122.492171858431) | |||
| 63541 | 63541 | 234471 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1350 Noe St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6003196.852580001 | 2100348.13678 | 37.7473368492221 | -122.431696139568 | (37.7473368492221, -122.431696139568) | ||||
| 63973 | 63973 | 178149 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 20 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991654.66793 | 2087995.1451599998 | 37.712757610756 | -122.470708188538 | (37.712757610756, -122.470708188538) | |||
| 64531 | 64531 | 184348 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1251 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984683.9949 | 2106431.9954 | 37.762974680362206 | -122.496160108596 | (37.7629746803622, -122.496160108596) | |||
| 64562 | 64562 | 181379 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984933.4588 | 2104463.134 | 37.7575833453331 | -122.495152116603 | (37.7575833453331, -122.495152116603) | |||
| 65528 | 65528 | 132163 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 150 Lombard St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6011528.08163 | 2120803.5748799997 | 37.8039714887622 | -122.40432672370399 | (37.8039714887622, -122.404326723704) | |||
| 65779 | 65779 | 194426 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 132 Kissling St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 6007946.83693 | 2109121.1094299997 | 37.77169351738029 | -122.415892125715 | (37.7716935173803, -122.415892125715) | |||
| 66679 | 66679 | 211036 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001192.69302 | 2095737.41742 | 37.7345630902121 | -122.438296103083 | (37.7345630902121, -122.438296103083) | ||||
| 67079 | 67079 | 186038 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1900 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984981.8854 | 2102120.1374 | 37.7511529582795 | -122.494811896529 | (37.7511529582795, -122.494811896529) | |||
| 68825 | 68825 | 185954 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984829.7049 | 2101412.004 | 37.749199709057706 | -122.495285928093 | (37.7491997090577, -122.495285928093) | |||
| 69007 | 69007 | 186699 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984730.9983 | 2105175.3386 | 37.759527005597604 | -122.495904834542 | (37.7595270055976, -122.495904834542) | |||
| 69760 | 69760 | 185902 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985031.1855 | 2101301.2352 | 37.7489073626901 | -122.494581050501 | (37.7489073626901, -122.494581050501) | |||
| 69894 | 69894 | 186685 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984734.6622 | 2105357.4834 | 37.7600273389586 | -122.495905599978 | (37.7600273389586, -122.495905599978) | |||
| 70507 | 70507 | 184801 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1301 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984720.8276 | 2105758.3732 | 37.7611272600096 | -122.49598302148998 | (37.7611272600096, -122.49598302149) | |||
| 70815 | 70815 | 186456 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984777.372 | 2103875.7247 | 37.755961343063895 | -122.49564859346701 | (37.7559613430639, -122.495648593467) | |||
| 71190 | 71190 | 91505 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 72624 | 72624 | 185709 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2101 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984908.4893 | 2100423.9717 | 37.7464914545154 | -122.49494065264601 | (37.7464914545154, -122.494940652646) | |||
| 72881 | 72881 | 186381 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1801 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984844.8943 | 2102435.3563 | 37.75201044294921 | -122.495308863381 | (37.7520104429492, -122.495308863381) | |||
| 74141 | 74141 | 186421 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984727.9626 | 2104153.7573 | 37.756721849906 | -122.495839973726 | (37.756721849906, -122.495839973726) | |||
| 74910 | 74910 | 186080 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1901 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984851.2986 | 2101988.3321 | 37.7507834123081 | -122.49525375381599 | (37.7507834123081, -122.495253753816) | |||
| 75963 | 75963 | 178152 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5993523.09133 | 2087729.02455 | 37.7121347780763 | -122.46423106162399 | (37.7121347780763, -122.464231061624) | |||
| 75987 | 75987 | 211004 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996822.63607 | 2099410.87592 | 37.7443999871842 | -122.453669936126 | (37.7443999871842, -122.453669936126) | |||
| 77629 | 77629 | 87016 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 35 Whitfield Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49947 | 6017543.1 | 2094109.3 | 37.7310090102049 | -122.38165350279101 | (37.7310090102049, -122.381653502791) | |||
| 80059 | 80059 | 91504 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 80132 | 80132 | 105261 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988914.8 | 2089258.8 | 37.716068469533205 | -122.48027037241002 | (37.7160684695332, -122.48027037241) | |||||
| 80939 | 80939 | 114377 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 842X GONZALEZ DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988421.0 | 2089827.0 | 37.7175998975755 | -122.48201875930201 | (37.7175998975755, -122.482018759302) | ||||
| 81272 | 81272 | 87834 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50721 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 83316 | 83316 | 87018 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1200 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49948 | 6017188.8 | 2093995.7 | 37.7306775177665 | -122.382870487304 | (37.7306775177665, -122.382870487304) | |||
| 84102 | 84102 | 94231 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 24 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 86211 | 86211 | 91503 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 88999 | 88999 | 94233 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Ocean Sloat Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 12 | Permit Number 53611 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | ||
| 91520 | 91520 | 186238 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1701 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984762.5292 | 2103340.0793 | 37.7544897398871 | -122.49566041616501 | (37.7544897398871, -122.495660416165) | |||
| 92148 | 92148 | 87013 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1184 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49946 | 6017813.5 | 2093492.6 | 37.7293305991048 | -122.380675823117 | (37.7293305991048, -122.380675823117) | |||
| 92410 | 92410 | 98278 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 500 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
| 96125 | 96125 | 114371 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 821 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988453.0 | 2089765.0 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) |
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");