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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44382 | 44382 | 54527 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 4550 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 8 | 3x5 | Permit Number 10322 | 5981462.67511 | 2111006.65453 | 37.775346149152 | -122.507640822085 | (37.775346149152, -122.507640822085) | |
44824 | 44824 | 68547 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 526 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | 9 | Permit Number 32434 | 5982567.23967 | 2112157.10709 | 37.7785699651083 | -122.50390516811599 | (37.7785699651083, -122.503905168116) | ||
45155 | 45155 | 190814 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 6010041.1190599995 | 2106539.02685 | 37.7647212291204 | -122.40846567444599 | (37.7647212291204, -122.408465674446) | |||
45751 | 45751 | 248141 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 274 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6009875.37752 | 2099433.39728 | 37.745201475562794 | -122.408537657996 | (37.7452014755628, -122.408537657996) | |||
45902 | 45902 | 176783 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 745 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008508.75071 | 2093604.64822 | 37.729120368908205 | -122.41285121931999 | (37.7291203689082, -122.41285121932) | |||
46315 | 46315 | 206948 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 422 Judson Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5997397.5658599995 | 2093594.47343 | 37.7284624896392 | -122.451262563442 | (37.7284624896392, -122.451262563442) | |||
46536 | 46536 | 176864 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1142 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001508.44833 | 2087074.49051 | 37.710794602952106 | -122.436584568222 | (37.7107946029521, -122.436584568222) | |||
46554 | 46554 | 190812 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 618 Texas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6013802.60494 | 2104175.98165 | 37.7584427561511 | -122.39529003900199 | (37.7584427561511, -122.395290039002) | |||
46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
46609 | 46609 | 202031 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1319 Fitzgerald Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 7ft | 6013998.1976 | 2090972.78897 | 37.7222004121965 | -122.3936894751 | (37.7222004121965, -122.3936894751) | |||
46668 | 46668 | 32026 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 910 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | 2 | Permit Number 48084 | 6011942.61594 | 2111635.52885 | 37.7788213676447 | -122.40224721144399 | (37.7788213676447, -122.402247211444) | ||
46998 | 46998 | 44750 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 524 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | 3 | Permit Number 43866 | 5987216.13778 | 2112350.62215 | 37.779373569745104 | -122.487837284703 | (37.7793735697451, -122.487837284703) | ||
47046 | 47046 | 206921 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 638 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5997199.5508 | 2095299.8270400001 | 37.7331336438848 | -122.452070097972 | (37.7331336438848, -122.452070097972) | |||
48359 | 48359 | 66778 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1335 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 5 | Permit Number 30043 | 6006555.48078 | 2119018.76457 | 37.798791728305396 | -122.42140793763001 | (37.7987917283054, -122.42140793763) | |
48905 | 48905 | 226906 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1348 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6001348.722159999 | 2099741.44448 | 37.74556608411171 | -122.43804337830099 | (37.7455660841117, -122.438043378301) | |||
49550 | 49550 | 219265 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1586 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5990318.67489 | 2104606.71448 | 37.758291386764604 | -122.47653854281401 | (37.7582913867646, -122.476538542814) | |||
49793 | 49793 | 53948 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 106 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2012 12:00:00 AM | 10 | Permit Number 769123 | 6009998.5111 | 2095243.6282 | 37.733704169294 | -122.407816497929 | (37.733704169294, -122.407816497929) | ||
50670 | 50670 | 176726 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1835 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005342.6627 | 2092636.32324 | 37.726283337880204 | -122.4237278324 | (37.7262833378802, -122.4237278324) | |||
50706 | 50706 | 176759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 657 Silver Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6005718.13456 | 2093584.1372099998 | 37.728907015522296 | -122.42249716234 | (37.7289070155223, -122.42249716234) | |||
51061 | 51061 | 190797 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2098 20th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 7ft | 6011937.571269999 | 2104699.91058 | 37.7597774480841 | -122.401777021595 | (37.7597774480841, -122.401777021595) | |||
51153 | 51153 | 176836 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 182 Niagara Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999285.39372 | 2089701.94289 | 37.7178824109155 | -122.444456635388 | (37.7178824109155, -122.444456635388) | |||
51393 | 51393 | 190771 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 15 Tubbs St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6015464.37774 | 2103329.09363 | 37.7562096621716 | -122.389483695716 | (37.7562096621716, -122.389483695716) | |||
51537 | 51537 | 190761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 285 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 21 | Width 3ft | 6013218.562419999 | 2105774.14575 | 37.762798465109995 | -122.397422010521 | (37.76279846511, -122.397422010521) | |||
51741 | 51741 | 226913 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1306 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 6001942.32599 | 2100269.94755 | 37.7470509691452 | -122.436028601948 | (37.7470509691452, -122.436028601948) | |||
51770 | 51770 | 176814 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 523 Felton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6009352.45368 | 2093382.51118 | 37.728557749420794 | -122.409918782852 | (37.7285577494208, -122.409918782852) | |||
51821 | 51821 | 185254 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2551 44th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5982701.1675 | 2097764.3628 | 37.7390594386794 | -122.502376400061 | (37.7390594386794, -122.502376400061) | |||
52562 | 52562 | 219270 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1220 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5991777.52525 | 2107074.159 | 37.7651508397576 | -122.47167305767701 | (37.7651508397576, -122.471673057677) | |||
52974 | 52974 | 129305 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1081 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6006148.36265 | 2120696.43143 | 37.8033752121629 | -122.422936000907 | (37.8033752121629, -122.422936000907) | |||
53053 | 53053 | 219245 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 16 Lobos St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 5996729.7413 | 2088712.5742099998 | 37.7150196826824 | -122.45321896478501 | (37.7150196826824, -122.453218964785) | |||
53740 | 53740 | 176618 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 123 Seneca Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000040.875469999 | 2090086.0119900003 | 37.7189800550644 | -122.441872826471 | (37.7189800550644, -122.441872826471) | |||
53919 | 53919 | 218142 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 55 Ridge Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5997830.51947 | 2089772.1428 | 37.717992043688895 | -122.449490525783 | (37.7179920436889, -122.449490525783) | |||
54268 | 54268 | 176658 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 81 Lamartine St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6002690.55167 | 2094295.13031 | 37.7306879789528 | -122.433014498934 | (37.7306879789528, -122.433014498934) | |||
54321 | 54321 | 70512 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 5 | 6004917.4216 | 2092965.0192099998 | 37.7271618505134 | -122.425221249286 | (37.7271618505134, -122.425221249286) | ||
54473 | 54473 | 103306 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 611 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6011832.19369 | 2105491.00064 | 37.7619437242424 | -122.402197092231 | (37.7619437242424, -122.402197092231) | ||||
54485 | 54485 | 129140 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2399 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999315.42401 | 2120440.5968400002 | 37.8022848336387 | -122.44656313629801 | (37.8022848336387, -122.446563136298) | |||
54634 | 54634 | 184594 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1738 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984424.6596 | 2103325.6175 | 37.754430240283796 | -122.496827772507 | (37.7544302402838, -122.496827772507) | |||
56029 | 56029 | 176773 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 290 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6008492.61854 | 2094225.0923 | 37.730823069723 | -122.412950839922 | (37.730823069723, -122.412950839922) | |||
56533 | 56533 | 129170 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2901 Steiner St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6001990.5691 | 2118242.759 | 37.796402586673395 | -122.437148394603 | (37.7964025866734, -122.437148394603) | |||
56672 | 56672 | 96034 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 1075 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767673 | 6008986.730930001 | 2117980.65751 | 37.7960781193685 | -122.41292155709999 | (37.7960781193685, -122.4129215571) |
56837 | 56837 | 65503 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2727 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1989 12:00:00 AM | 5 | Permit Number 28387 | 6000480.85647 | 2117478.59942 | 37.7942184733604 | -122.442317420725 | (37.7942184733604, -122.442317420725) | ||
57147 | 57147 | 219376 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 150 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6001070.677759999 | 2095432.5770599998 | 37.7337191286367 | -122.43869611344999 | (37.7337191286367, -122.43869611345) | |||
57199 | 57199 | 190807 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1950 22nd St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6012259.17788 | 2103783.2795599997 | 37.7572785235114 | -122.400600344128 | (37.7572785235114, -122.400600344128) | |||
58086 | 58086 | 190766 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1400 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6015346.06271 | 2101819.81527 | 37.752058942870995 | -122.389787457026 | (37.752058942871, -122.389787457026) | |||
58322 | 58322 | 176790 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 687 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6009034.54541 | 2092898.31012 | 37.727210413927395 | -122.410983627814 | (37.7272104139274, -122.410983627814) | |||
58394 | 58394 | 227002 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5411 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6002089.29593 | 2098063.49977 | 37.7410009293557 | -122.43536258651699 | (37.7410009293557, -122.435362586517) | |||
59101 | 59101 | 129187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3445 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5999729.19027 | 2120417.1315599997 | 37.8022440296095 | -122.44512962056001 | (37.8022440296095, -122.44512962056) | |||
59190 | 59190 | 129129 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3740 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6000192.65427 | 2121134.45107 | 37.8042400388971 | -122.44357737451901 | (37.8042400388971, -122.443577374519) | |||
59222 | 59222 | 226968 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 496 Roosevelt Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5999791.333330001 | 2106241.20236 | 37.7633241395288 | -122.443895478197 | (37.7633241395288, -122.443895478197) | |||
59244 | 59244 | 71583 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 266 Flournoy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5993925.4185 | 2086705.1573599998 | 37.7093466620935 | -122.462766282735 | (37.7093466620935, -122.462766282735) | ||
59420 | 59420 | 249634 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2550 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 5997294.55506 | 2111271.9763700003 | 37.776994614336 | -122.452894113492 | (37.776994614336, -122.452894113492) | |||
59990 | 59990 | 219377 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 52 Martha Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6000663.58315 | 2095622.36819 | 37.7342170832497 | -122.440117160997 | (37.7342170832497, -122.440117160997) | |||
60078 | 60078 | 206943 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 359 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 10ft | 5997695.93457 | 2093782.21524 | 37.728995063674105 | -122.45024461989401 | (37.7289950636741, -122.450244619894) | |||
60393 | 60393 | 176642 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 450 Palmetto Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5993005.954030001 | 2087230.75027 | 37.7107368152174 | -122.465982240383 | (37.7107368152174, -122.465982240383) | |||
60723 | 60723 | 176819 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 691 Hamilton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6009861.20828 | 2091223.43353 | 37.7226578748526 | -122.40800778375099 | (37.7226578748526, -122.408007783751) | |||
60867 | 60867 | 246724 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501 Shotwell St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6008058.52794 | 2099329.47434 | 37.744814207710796 | -122.41481267936001 | (37.7448142077108, -122.41481267936) | ||||
61110 | 61110 | 92458 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 3319 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52848 | 5983933.4582 | 2104246.8072 | 37.756930776386795 | -122.498594490514 | (37.7569307763868, -122.498594490514) |
61159 | 61159 | 129163 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 101 Parker Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 5996819.747219999 | 2113790.05212 | 37.783881366273704 | -122.45471857981701 | (37.7838813662737, -122.454718579817) | |||
61343 | 61343 | 129164 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Emerson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5998679.83386 | 2113409.66692 | 37.7829434444333 | -122.448255995832 | (37.7829434444333, -122.448255995832) | |||
61598 | 61598 | 176615 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 73 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5999173.59476 | 2089300.0418599998 | 37.716772502713596 | -122.44481420042801 | (37.7167725027136, -122.444814200428) | |||
61910 | 61910 | 245187 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1195 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000895.0351 | 2109289.4071 | 37.7717566471657 | -122.44029675786501 | (37.7717566471657, -122.440296757865) | |||
62081 | 62081 | 176614 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1531 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5998790.48593 | 2089284.65203 | 37.7167083747673 | -122.44613730731301 | (37.7167083747673, -122.446137307313) | |||
62117 | 62117 | 176596 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Lyell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003139.12483 | 2094542.11174 | 37.73139156805539 | -122.431481338298 | (37.7313915680554, -122.431481338298) | |||
62195 | 62195 | 84689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6002195.05393 | 2120739.39081 | 37.80326930438871 | -122.436619630107 | (37.8032693043887, -122.436619630107) | |||
62283 | 62283 | 219329 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 100 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5995365.77553 | 2090599.7710099998 | 37.7201232084876 | -122.45806987824699 | (37.7201232084876, -122.458069878247) | |||
62906 | 62906 | 176774 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 145 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6008278.14713 | 2093326.70687 | 37.7283442548741 | -122.413628786662 | (37.7283442548741, -122.413628786662) | |||
63051 | 63051 | 206914 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 720 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000288.23056 | 2095969.61248 | 37.7351491585898 | -122.441439779525 | (37.7351491585898, -122.441439779525) | |||
63209 | 63209 | 176813 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 243 Girard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6010699.48876 | 2093611.90345 | 37.729263014877795 | -122.40527813180401 | (37.7292630148778, -122.405278131804) | |||
63662 | 63662 | 120171 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2300 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5988414.35774 | 2111262.94747 | 37.7764569397419 | -122.48361242435 | (37.7764569397419, -122.48361242435) | |||
64687 | 64687 | 31118 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 450 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 7 | Permit Number 34839 | 5998792.48559 | 2094316.2837 | 37.730524182724 | -122.446492182475 | (37.730524182724, -122.446492182475) | |
64780 | 64780 | 129114 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 12 Hastings Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6007312.730219999 | 2119281.87279 | 37.79955682294621 | -122.41880627269899 | (37.7995568229462, -122.418806272699) | ||||
64797 | 64797 | 226958 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3875 19th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6003770.72652 | 2104768.59394 | 37.7595068960317 | -122.43002700865699 | (37.7595068960317, -122.430027008657) | |||
64892 | 64892 | 176702 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 943 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005153.2895 | 2092105.0699599998 | 37.724813941005394 | -122.42434471783001 | (37.7248139410054, -122.42434471783) | |||
64909 | 64909 | 176808 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 740 Silliman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6008493.59905 | 2093658.58119 | 37.7292676068058 | -122.41290741167299 | (37.7292676068058, -122.412907411673) | |||
65282 | 65282 | 118037 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3421 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 5984874.28781 | 2113152.5227900003 | 37.7814384776062 | -122.49599778017401 | (37.7814384776062, -122.495997780174) | |||
65315 | 65315 | 176761 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 25 Tulane St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 1ft | 6007405.66478 | 2093755.6687200002 | 37.7294730596285 | -122.416675381275 | (37.7294730596285, -122.416675381275) | |||
65634 | 65634 | 129199 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3688 Fillmore St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6002142.29562 | 2121107.7471 | 37.8042777151067 | -122.436828586663 | (37.8042777151067, -122.436828586663) | |||
66087 | 66087 | 176671 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 250 San Juan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6000440.43474 | 2092860.7725400003 | 37.7266216745319 | -122.440690633469 | (37.7266216745319, -122.440690633469) | |||
66460 | 66460 | 176844 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 838 Avalon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6004810.4561 | 2091959.39958 | 37.7243945970256 | -122.425519490549 | (37.7243945970256, -122.425519490549) | |||
66529 | 66529 | 176653 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 83 Badger St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6002454.85249 | 2094211.40595 | 37.7304447186477 | -122.43382336446699 | (37.7304447186477, -122.433823364467) | |||
66575 | 66575 | 176855 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 699 Prague St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6002700.83355 | 2087431.53609 | 37.711842660275394 | -122.43248890094499 | (37.7118426602754, -122.432488900945) | |||
66666 | 66666 | 227014 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 5557 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6001726.69776 | 2097242.18492 | 37.7387251913123 | -122.436557543618 | (37.7387251913123, -122.436557543618) | |||
66797 | 66797 | 120004 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 530 29th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5986920.19544 | 2112296.72927 | 37.779208328318795 | -122.48885709710599 | (37.7792083283188, -122.488857097106) | |||
67307 | 67307 | 226912 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 704 27th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6001921.54474 | 2100041.06376 | 37.7464213276908 | -122.436084085618 | (37.7464213276908, -122.436084085618) | |||
67422 | 67422 | 250323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.03432 | 2114802.15795 | 37.7861152804279 | -122.48739508214399 | (37.7861152804279, -122.487395082144) | |||
67530 | 67530 | 219258 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1383 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 5991755.50234 | 2106034.38103 | 37.7622946118155 | -122.471673449788 | (37.7622946118155, -122.471673449788) | |||
67750 | 67750 | 129287 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1455 Filbert St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6006061.216030001 | 2119298.10676 | 37.7995308514145 | -122.42313812264 | (37.7995308514145, -122.42313812264) | |||
68222 | 68222 | 176645 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 8 Capistrano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6001124.98684 | 2093986.7324 | 37.72975226225729 | -122.43840479965 | (37.7297522622573, -122.43840479965) | |||
68329 | 68329 | 176623 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 256 Ellington Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5999086.11922 | 2088154.6418400002 | 37.713622502239794 | -122.445034263618 | (37.7136225022398, -122.445034263618) | |||
68388 | 68388 | 176684 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 80 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6004830.04308 | 2092947.4100799998 | 37.7271085629972 | -122.4255220635 | (37.7271085629972, -122.4255220635) | |||
68529 | 68529 | 176622 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 28 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009222.269090001 | 2086479.6741900002 | 37.7095966978914 | -122.409881764928 | (37.7095966978914, -122.409881764928) | |||
69062 | 69062 | 35257 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 2363 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 2 | Permit Number 43818 | 6006687.16748 | 2119377.40243 | 37.799783881083606 | -122.420977735243 | (37.7997838810836, -122.420977735243) | |
69438 | 69438 | 176704 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 116 Vienna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6004724.80903 | 2092778.7442400001 | 37.726639497300205 | -122.425873855805 | (37.7266394973002, -122.425873855805) | |||
70097 | 70097 | 58139 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 378 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1978 12:00:00 AM | 7 | Permit Number 17123 | 6008540.16815 | 2094753.5725900002 | 37.7322768319131 | -122.412823801697 | (37.7322768319131, -122.412823801697) | ||
70140 | 70140 | 176743 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 205 Yale St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007217.079390001 | 2092679.28575 | 37.7265069363429 | -122.417251095779 | (37.7265069363429, -122.417251095779) | |||
70212 | 70212 | 226857 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6000811.73315 | 2096306.95535 | 37.7361052332666 | -122.439654022723 | (37.7361052332666, -122.439654022723) | |||
71429 | 71429 | 226979 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 2779 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002535.8792 | 2095906.2719599998 | 37.735103031462295 | -122.43366432835899 | (37.7351030314623, -122.433664328359) | |||
71661 | 71661 | 129345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 296 Union St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6011521.70204 | 2119773.31621 | 37.801142293548004 | -122.40427624385799 | (37.801142293548, -122.404276243858) | |||
72136 | 72136 | 219271 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1251 Funston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 5992034.18905 | 2106913.1849700003 | 37.7647236941726 | -122.47077360162399 | (37.7647236941726, -122.470773601624) | |||
72183 | 72183 | 219381 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 61 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6000145.12885 | 2095680.3694 | 37.7343468113491 | -122.44191377890301 | (37.7343468113491, -122.441913778903) | |||
72240 | 72240 | 176634 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 600 Blanken Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 6013132.57563 | 2086873.0357 | 37.7108951651419 | -122.396394525203 | (37.7108951651419, -122.396394525203) |
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");