trees
1,408 rows where qSpecies_id = 113 sorted by SiteOrder
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85213 | 88347 | Permitted Site 7 | Juniperus chinensis :: Juniper 113 | 100x Vienna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738 | 2092796 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | 9 | 7 | 6 | 28861 | 5 | |||
| 100702 | 109040 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 654 Precita Ave | Front Yard : Yard | Tree | Private 2 | 30 | 6009911.5 | 2100416.7 | 37.7479034320272 | -122.408482100152 | (37.7479034320272, -122.408482100152) | 2 | 7 | 7 | 28859 | 2 | |||||
| 130833 | 106685 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 100 Yukon St | Front Yard : Cutout | Tree | Private 2 | Permit Number 772768 | 6000197.4 | 2104288 | 37.757984281634 | -122.442350801363 | (37.757984281634, -122.442350801363) | 2 | 4 | 5 | 28862 | 3 | |||||
| 159975 | 97139 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 937 Goettingen St | Front Yard : | Landscaping | Private 2 | 6011052 | 2090410 | 37.7204909525546 | -122.403834244644 | (37.7204909525546, -122.403834244644) | 10 | 7 | 8 | 309 | 28 | ||||||
| 11839 | 19962 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
| 1587 | 35594 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1303 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/1998 12:00:00 AM | 5 | Permit Number 38957 | 6012015.58746 | 2102213.67536 | 37.7529551460873 | -122.401332479509 | (37.7529551460873, -122.401332479509) | 10 | 3 | 8 | 28856 | 29 | |
| 2355 | 176777 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 107 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6008230.80526 | 2093471.1524 | 37.7287382127949 | -122.413802663375 | (37.7287382127949, -122.413802663375) | 9 | 3 | 7 | 309 | 28 | |||
| 2412 | 219263 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1851 08th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5993725.67794 | 2102905.85054 | 37.7538182676993 | -122.464632221316 | (37.7538182676993, -122.464632221316) | 1 | 8 | 4 | 56 | 12 | |||
| 3474 | 38364 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4001 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | 5 | Permit Number 44994 | 5981794.8549 | 2104174.5597 | 37.7566067521127 | -122.50598509825 | (37.7566067521127, -122.50598509825) | 1 | 8 | 3 | 56 | 35 | |
| 3813 | 176671 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 500x San Juan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 6000440.43474 | 2092860.77254 | 37.7266216745319 | -122.440690633469 | (37.7266216745319, -122.440690633469) | 9 | 7 | 6 | 28861 | 25 | |||
| 3844 | 54791 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 280 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 18 | Permit Number 10640 | 6012628.37407 | 2087183.5823 | 37.7117197939932 | -122.398158948299 | (37.7117197939932, -122.398158948299) | 10 | 3 | 8 | 309 | 1 | ||
| 4817 | 219315 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1200 Capitol Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 5995096.96866 | 2091948.28525 | 37.7238104576833 | -122.459096640518 | (37.7238104576833, -122.459096640518) | 9 | 8 | 4 | 28861 | 24 | |||
| 6243 | 226941 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Fairmount St | 1 | Side Yard : Yard | Tree | Private 2 | 16 | 6004051.37428 | 2097144.63452 | 37.7385891688512 | -122.428512957704 | (37.7385891688512, -122.428512957704) | 2 | 7 | 5 | 63 | 7 | ||||
| 6699 | 123104 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 446 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5992530.91894 | 2112401.00432 | 37.7798204855095 | -122.469455059019 | (37.7798204855095, -122.469455059019) | 11 | 6 | 2 | 54 | 11 | |||
| 7280 | 176726 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1835 Silliman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6005342.6627 | 2092636.32324 | 37.7262833378802 | -122.4237278324 | (37.7262833378802, -122.4237278324) | 9 | 7 | 7 | 309 | 5 | |||
| 7528 | 226882 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2810 19th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6009447.14609 | 2105030.4857 | 37.7605458378345 | -122.410413552952 | (37.7605458378345, -122.410413552952) | 2 | 4 | 7 | 28859 | 19 | |||
| 7930 | 223763 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 126 Bradford St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009530.79254 | 2097866.09723 | 37.7408787078943 | -122.409618578334 | (37.7408787078943, -122.409618578334) | 10 | 7 | 7 | 28859 | 2 | |||
| 9556 | 19963 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 100 STAIRWAY41 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
| 9994 | 176783 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 799X Silliman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6008526 | 2093580 | 37.7290536583746 | -122.412789845037 | (37.7290536583746, -122.412789845037) | 9 | 3 | 7 | 309 | 28 | |||
| 11114 | 71583 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5993925.4185 | 2086705.15736 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | 9 | 8 | 6 | 28861 | 25 | |||
| 11982 | 70512 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004917.4216 | 2092965.01921 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | 9 | 7 | 6 | 28861 | 5 | |||
| 12897 | 61250 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2033 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 7 | Permit Number 24211 | 6007651.97178 | 2119454.00624 | 37.8000485533513 | -122.41764457883 | (37.8000485533513, -122.41764457883) | 5 | 1 | 1 | 28858 | 32 | |
| 13953 | 116804 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 131 LAKESHORE DR | 1 | Median : Yard | Landscaping | DPW 1 | 10x100 | 5984782 | 2094243 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | 1 | 8 | 4 | 64 | 35 | ||||
| 14336 | 226984 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2323 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6001664.11704 | 2096982.04185 | 37.7380073425508 | -122.436755300925 | (37.7380073425508, -122.436755300925) | 2 | 7 | 5 | 63 | 7 | |||
| 14667 | 190808 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2115 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 2ft | 6011806.38674 | 2103701.05515 | 37.7570274903299 | -122.402160501522 | (37.7570274903299, -122.402160501522) | 10 | 3 | 8 | 28856 | 29 | |||
| 15832 | 71937 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | 3 | 1 | 10 | 308 | 23 | |||
| 15840 | 258303 | Private 9 | Juniperus chinensis :: Juniper 113 | 1x Dawnview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | |||||||||||||||
| 17612 | 262236 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 3540 Rivera St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 3x3 | 5982153 | 2100195 | 37.7457010726591 | -122.504451707081 | (37.7457010726591, -122.504451707081) | 1 | 8 | 3 | 29491 | 35 | ||||
| 17868 | 219400 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 434 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998549.53071 | 2095273.11102 | 37.7331375244767 | -122.447400952815 | (37.7331375244767, -122.447400952815) | 9 | 7 | 4 | 59 | 40 | ||||
| 18027 | 190795 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2051 23rd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012296.97439 | 2102792.20367 | 37.7545593540486 | -122.400400016553 | (37.7545593540486, -122.400400016553) | 10 | 3 | 8 | 28856 | 29 | |||
| 19564 | 264882 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 2801 Lawton St | 1 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 3x3 | 5985570 | 2104278 | 37.7571122644181 | -122.49293709397 | (37.7571122644181, -122.49293709397) | 1 | 8 | 3 | 56 | 35 | ||||
| 19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
| 20680 | 176743 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 205 Yale St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6007217.07939 | 2092679.28575 | 37.7265069363429 | -122.417251095779 | (37.7265069363429, -122.417251095779) | 9 | 3 | 7 | 309 | 28 | |||
| 22470 | 129158 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 280 Euclid Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 5998011.3909 | 2113983.22252 | 37.7844800404754 | -122.450609884934 | (37.7844800404754, -122.450609884934) | 15 | 6 | 1 | 54 | 31 | |||
| 23084 | 219318 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 5994210.25958 | 2091948.52134 | 37.7237600911452 | -122.46216184119 | (37.7237600911452, -122.46216184119) | 9 | 8 | 4 | 28861 | 24 | |||
| 25696 | 176816 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 633 Burrows St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 6009439.97458 | 2092928.08247 | 37.7273148890564 | -122.409584156803 | (37.7273148890564, -122.409584156803) | 10 | 3 | 7 | 309 | 28 | |||
| 25729 | 219376 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 150 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6001070.67776 | 2095432.57706 | 37.7337191286367 | -122.43869611345 | (37.7337191286367, -122.43869611345) | 9 | 7 | 5 | 63 | 40 | |||
| 25844 | 53948 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 106 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2012 12:00:00 AM | 10 | Permit Number 769123 | 6009998.5111 | 2095243.6282 | 37.733704169294 | -122.407816497929 | (37.733704169294, -122.407816497929) | 10 | 3 | 7 | 309 | 28 | ||
| 25847 | 176821 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 629 Hamilton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6009772.50024 | 2091512.83879 | 37.7234475542459 | -122.408334832093 | (37.7234475542459, -122.408334832093) | 10 | 3 | 7 | 309 | 28 | |||
| 25963 | 129283 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1725 Jones St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008284.02341 | 2118410.27033 | 37.7972182600691 | -122.415383500662 | (37.7972182600691, -122.415383500662) | 5 | 1 | 10 | 28858 | 21 | |||
| 26549 | 226881 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 14 Liberty St | 1 | : | Tree | Private 2 | 19 | Width 1ft | 6006207.80682 | 2104080.83219 | 37.7577561840284 | -122.42154951882 | (37.7577561840284, -122.42154951882) | 2 | 4 | 5 | 28859 | 19 | |||
| 26894 | 129140 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2399 North Point St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999315.42401 | 2120440.59684 | 37.8022848336387 | -122.446563136298 | (37.8022848336387, -122.446563136298) | 13 | 9 | 1 | 57 | 17 | |||
| 27157 | 176704 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 116 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004724.80903 | 2092778.74424 | 37.7266394973002 | -122.425873855805 | (37.7266394973002, -122.425873855805) | 9 | 7 | 6 | 28861 | 5 | |||
| 27468 | 185221 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2507 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985796.5284 | 2098145.3036 | 37.740286789775 | -122.491702240957 | (37.740286789775, -122.491702240957) | 1 | 8 | 3 | 29491 | 35 | |||
| 28342 | 219381 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 61 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6000145.12885 | 2095680.3694 | 37.7343468113491 | -122.441913778903 | (37.7343468113491, -122.441913778903) | 9 | 7 | 5 | 63 | 40 | |||
| 28757 | 176648 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 281 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002318.30567 | 2094095.55738 | 37.7301188753802 | -122.434287146634 | (37.7301188753802, -122.434287146634) | 9 | 7 | 5 | 28861 | 25 | |||
| 29117 | 206944 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 224 Edna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5998782.54897 | 2093637.88574 | 37.7286608935636 | -122.446477747467 | (37.7286608935636, -122.446477747467) | 9 | 7 | 4 | 28861 | 40 | |||
| 30826 | 129156 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 341 Spruce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 1ft | 5997126.0863 | 2115169.43249 | 37.7876863448031 | -122.453758406952 | (37.7876863448031, -122.453758406952) | 11 | 6 | 1 | 54 | 31 | |||
| 31081 | 115307 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1309 Hyde St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 2x2 | 6007522.86141 | 2116889.0118 | 37.7929984521768 | -122.417909425585 | (37.7929984521768, -122.417909425585) | 5 | 1 | 10 | 28858 | 32 | |||
| 31307 | 176736 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1201 Bacon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6007970.19337 | 2091996.76922 | 37.724675233151 | -122.414599326007 | (37.724675233151, -122.414599326007) | 9 | 3 | 7 | 309 | 28 | |||
| 31570 | 176785 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 194 Hamilton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6009137.47484 | 2093394.32671 | 37.7285781415571 | -122.41066281354 | (37.7285781415571, -122.41066281354) | 9 | 3 | 7 | 309 | 28 | |||
| 31882 | 226911 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 733 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6001786.77721 | 2099686.1484 | 37.745439156509 | -122.436524696781 | (37.745439156509, -122.436524696781) | 2 | 7 | 5 | 63 | 22 | |||
| 32009 | 176645 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 8 Capistrano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6001124.98684 | 2093986.7324 | 37.7297522622573 | -122.43840479965 | (37.7297522622573, -122.43840479965) | 9 | 7 | 6 | 28861 | 25 | |||
| 32413 | 226844 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 627 Alvarado St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6002306.05435 | 2102639.65859 | 37.7535782908153 | -122.434940308068 | (37.7535782908153, -122.434940308068) | 2 | 4 | 5 | 28862 | 22 | |||
| 32433 | 106828 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 631 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009794.12958 | 2091448.15219 | 37.7232711495323 | -122.40825550289 | (37.7232711495323, -122.40825550289) | 10 | 3 | 7 | 309 | 28 | |||
| 32946 | 226887 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1266 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5997536.57649 | 2105194.59271 | 37.7603215415281 | -122.451618405363 | (37.7603215415281, -122.451618405363) | 15 | 5 | 11 | 29492 | 12 | |||
| 33710 | 4370 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 998 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/1992 12:00:00 AM | 12 | 3X3 | 6001204.19033 | 2096097.57717 | 37.7355526592134 | -122.438282146497 | (37.7355526592134, -122.438282146497) | 2 | 7 | 5 | 63 | 7 | ||
| 33855 | 226980 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 139 Farnum St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 39 | Width 3ft | 6002461.28051 | 2097299.02865 | 37.7389229873138 | -122.434021768396 | (37.7389229873138, -122.434021768396) | 2 | 7 | 5 | 63 | 7 | |||
| 34658 | 104715 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
| 35477 | 219341 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 176 Margaret Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 5996604.57651 | 2089160.1054 | 37.7162413244539 | -122.453683881921 | (37.7162413244539, -122.453683881921) | 9 | 8 | 6 | 28861 | 24 | |||
| 36303 | 129338 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 928 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007904.15055 | 2120316.35403 | 37.802430530998 | -122.416833070211 | (37.802430530998, -122.416833070211) | 5 | 1 | 1 | 308 | 32 | |||
| 36388 | 206933 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 105 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 8ft | 6000003.13616 | 2094038.30798 | 37.7298300014536 | -122.442286850953 | (37.7298300014536, -122.442286850953) | 9 | 7 | 4 | 63 | 40 | |||
| 36682 | 176686 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 242 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6004486.61146 | 2091862.36635 | 37.7241098617621 | -122.426632070637 | (37.7241098617621, -122.426632070637) | 9 | 7 | 6 | 28861 | 5 | ||||
| 36824 | 176739 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 318 Princeton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6007769.14827 | 2092407.95318 | 37.725792959174 | -122.41532341065 | (37.725792959174, -122.41532341065) | 9 | 3 | 7 | 309 | 28 | |||
| 37011 | 206948 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 422 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 5997397.56586 | 2093594.47343 | 37.7284624896392 | -122.451262563442 | (37.7284624896392, -122.451262563442) | 9 | 7 | 4 | 28861 | 40 | |||
| 37022 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 577 Sanchez St | 1 | Front Yard : | Tree | Private 2 | 6003673 | 2104901 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | 2 | 4 | 5 | 28862 | 3 | |||||
| 37204 | 227015 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 29 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 1 | Width 2ft | 6002114.09151 | 2096793.82616 | 37.7375161085743 | -122.435186060404 | (37.7375161085743, -122.435186060404) | 2 | 7 | 5 | 63 | 7 | |||
| 37278 | 129315 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1847 Leavenworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6007744.83863 | 2118772.65589 | 37.7981829610394 | -122.417274913428 | (37.7981829610394, -122.417274913428) | 5 | 1 | 10 | 28858 | 32 | |||
| 37733 | 176811 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 77 Colby St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6008163.14276 | 2093697.53873 | 37.7293560209571 | -122.414052586778 | (37.7293560209571, -122.414052586778) | 9 | 3 | 7 | 309 | 28 | |||
| 37932 | 219350 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 350 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993263.51307 | 2089526.95902 | 37.717056510421 | -122.465258746617 | (37.717056510421, -122.465258746617) | 9 | 8 | 6 | 64 | 24 | |||
| 38234 | 176646 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 285 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002296.83551 | 2094083.28356 | 37.7300839555978 | -122.434360494448 | (37.7300839555978, -122.434360494448) | 9 | 7 | 5 | 28861 | 25 | |||
| 38422 | 226909 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 755 Duncan St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 10ft | 6001647.0118 | 2099677.10476 | 37.7454063816074 | -122.437007335031 | (37.7454063816074, -122.437007335031) | 2 | 7 | 5 | 63 | 22 | |||
| 38549 | 129272 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1762 Washington St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 6006226.29667 | 2116990.31514 | 37.7932035515493 | -122.422402818042 | (37.7932035515493, -122.422402818042) | 13 | 9 | 10 | 28858 | 32 | |||
| 38686 | 219369 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 55 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994238.91298 | 2101823.09904 | 37.7508748828804 | -122.46277880671 | (37.7508748828804, -122.46277880671) | 1 | 8 | 4 | 29491 | 40 | |||
| 38712 | 226957 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4415 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001675.32551 | 2104070.79205 | 37.7574720063552 | -122.437223965526 | (37.7574720063552, -122.437223965526) | 2 | 4 | 5 | 28862 | 3 | |||
| 38757 | 248140 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 268 Rutledge St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 6009882.82604 | 2099441.40705 | 37.7452238857837 | -122.408512467075 | (37.7452238857837, -122.408512467075) | 2 | 7 | 7 | 28859 | 2 | |||
| 39179 | 92458 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3319 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52848 | 5983933.4582 | 2104246.8072 | 37.7569307763868 | -122.498594490514 | (37.7569307763868, -122.498594490514) | 1 | 8 | 3 | 56 | 35 |
| 40055 | 176719 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 83 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005086.02152 | 2092756.70841 | 37.7265993983363 | -122.424623588602 | (37.7265993983363, -122.424623588602) | 9 | 7 | 6 | 28861 | 5 | ||||
| 40107 | 206921 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 638 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 5997199.5508 | 2095299.82704 | 37.7331336438848 | -122.452070097972 | (37.7331336438848, -122.452070097972) | 9 | 7 | 4 | 59 | 40 | |||
| 40123 | 256065 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2800 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2018 12:00:00 AM | 3 | 3x3 | 6002545 | 2117972 | 37.7956906526811 | -122.435210571933 | (37.7956906526811, -122.435210571933) | 13 | 9 | 1 | 57 | 17 | ||
| 40960 | 219271 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1251 Funston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 5992034.18905 | 2106913.18497 | 37.7647236941726 | -122.470773601624 | (37.7647236941726, -122.470773601624) | 11 | 8 | 11 | 56 | 12 | |||
| 41497 | 176813 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 243 Girard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 6010699.48876 | 2093611.90345 | 37.7292630148778 | -122.405278131804 | (37.7292630148778, -122.405278131804) | 10 | 3 | 7 | 309 | 28 | |||
| 42476 | 176619 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 375 Hanover St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5999272.06122 | 2086368.18274 | 37.7087278988324 | -122.444263284724 | (37.7087278988324, -122.444263284724) | 9 | 7 | 6 | 28861 | 5 | |||
| 43581 | 16098 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 300 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/17/1997 12:00:00 AM | 6 | 2X3 | 6000050.52204 | 2094718.8331 | 37.7317012658005 | -122.442171864536 | (37.7317012658005, -122.442171864536) | 9 | 7 | 4 | 63 | 40 | ||
| 44047 | 129189 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 3725 Scott St | 1 | : | Tree | Private 2 | 17 | Width 2ft | 6000608.31446 | 2121159.56549 | 37.8043326933704 | -122.442140757907 | (37.8043326933704, -122.442140757907) | 13 | 9 | 1 | 57 | 17 | |||
| 44120 | 117698 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 4049 Clement St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5982870.28986 | 2113072.50922 | 37.7811012062077 | -122.502924603076 | (37.7811012062077, -122.502924603076) | 11 | 6 | 2 | 55 | 26 | |||
| 44592 | 176622 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 28 Tomaso Ct | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6009222.26909 | 2086479.67419 | 37.7095966978914 | -122.409881764928 | (37.7095966978914, -122.409881764928) | 9 | 7 | 8 | 309 | 39 | |||
| 44689 | 35257 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 2363 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 2 | Permit Number 43818 | 6006687.16748 | 2119377.40243 | 37.7997838810836 | -122.420977735243 | (37.7997838810836, -122.420977735243) | 13 | 9 | 1 | 28858 | 32 | |
| 44711 | 129345 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 296 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6011521.70204 | 2119773.31621 | 37.801142293548 | -122.404276243858 | (37.801142293548, -122.404276243858) | 3 | 1 | 10 | 308 | 23 | |||
| 44754 | 253482 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2179 41st Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x5 | 5983532 | 2100331 | 37.7461555051432 | -122.499693454208 | (37.7461555051432, -122.499693454208) | 1 | 8 | 3 | 29491 | 35 | ||||
| 44817 | 176618 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 123 Seneca Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6000040.87547 | 2090086.01199 | 37.7189800550644 | -122.441872826471 | (37.7189800550644, -122.441872826471) | 9 | 7 | 6 | 28861 | 25 | |||
| 45021 | 226948 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 85 Elk St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000812.17024 | 2096305.70528 | 37.7361018257441 | -122.439652421939 | (37.7361018257441, -122.439652421939) | 2 | 7 | 5 | 63 | 7 | |||
| 45746 | 219335 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 261 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994423.03783 | 2089616.126 | 37.7173681417119 | -122.461257314797 | (37.7173681417119, -122.461257314797) | 9 | 8 | 6 | 28861 | 24 | |||
| 46536 | 110171 | Undocumented 4 | Juniperus chinensis :: Juniper 113 | 901 MONTEREY BLVD | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5996075.7 | 2094614.5 | 37.7311874614685 | -122.455906001855 | (37.7311874614685, -122.455906001855) | 9 | 7 | 4 | 28861 | 40 | ||||
| 46685 | 129196 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 75 Cervantes Blvd | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | 13 | 9 | 1 | 57 | 17 | |||
| 47637 | 218142 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 55 Ridge Ln | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 8ft | 5997830.51947 | 2089772.1428 | 37.7179920436889 | -122.449490525783 | (37.7179920436889, -122.449490525783) | 9 | 8 | 6 | 28861 | 24 | |||
| 48199 | 219418 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 201 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5999410.04683 | 2095743.65235 | 37.7344786564593 | -122.444459733527 | (37.7344786564593, -122.444459733527) | 9 | 7 | 4 | 59 | 40 | |||
| 48463 | 176832 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 1555 Cayuga Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 1ft | 5998713.68097 | 2089214.67806 | 37.7165118558136 | -122.446397751868 | (37.7165118558136, -122.446397751868) | 9 | 7 | 6 | 28861 | 25 | |||
| 48684 | 226978 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 11 Thor Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 2ft | 6002261.07248 | 2096075.82305 | 37.7355529829866 | -122.434626552585 | (37.7355529829866, -122.434626552585) | 2 | 7 | 5 | 63 | 7 | |||
| 48927 | 109354 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 900x Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 5x45 | 6007474.1784 | 2120601.58246 | 37.8031895021643 | -122.418341225173 | (37.8031895021643, -122.418341225173) | 5 | 1 | 1 | 28858 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );