Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
880 | 880 | 246102 | DPW Maintained 3 | Tristania conferta :: 79 | 1764 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 5997188.4287 | 2108119.9769 | 37.768333957535795 | -122.453033652641 | (37.7683339575358, -122.453033652641) | |||
3074 | 3074 | 199930 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.727690668221506 | -122.385184171361 | (37.7276906682215, -122.385184171361) | ||
3599 | 3599 | 12345 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/27/1992 12:00:00 AM | 6 | 4X4 | 6004709.3369 | 2113084.1368 | 37.782392475782 | -122.42737320580099 | (37.782392475782, -122.427373205801) | ||
3704 | 3704 | 6903 | Permitted Site 1 | Tristania conferta :: 79 | 333 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3X3 | 6005734.9676 | 2110651.7554 | 37.775771702887894 | -122.42365197493 | (37.7757717028879, -122.42365197493) | ||
4181 | 4181 | 21599 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 6005255.9404 | 2114750.4037 | 37.7869985302762 | -122.425600824408 | (37.7869985302762, -122.425600824408) | |||
4438 | 4438 | 6185 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005465.536 | 2113438.1352 | 37.783407206982005 | -122.424782278636 | (37.783407206982, -122.424782278636) | |||
4663 | 4663 | 17684 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002398.395 | 2112227.2208 | 37.7799086308334 | -122.435306723377 | (37.7799086308334, -122.435306723377) | |||
5039 | 5039 | 13231 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6001312.3137 | 2119307.4165 | 37.7992872786644 | -122.43957165866001 | (37.7992872786644, -122.43957165866) | |||
5826 | 5826 | 7045 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001075.5825 | 2110054.6953 | 37.7738682146278 | -122.43972710968599 | (37.7738682146278, -122.439727109686) | ||
6862 | 6862 | 23930 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003466.7876 | 2114641.1577 | 37.786597310936706 | -122.431783083706 | (37.7865973109367, -122.431783083706) | |||
6992 | 6992 | 7000 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002725.4323 | 2110284.3962 | 37.77459268596171 | -122.434036438862 | (37.7745926859617, -122.434036438862) | ||
7113 | 7113 | 29685 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003360.3482 | 2119674.8613 | 37.800412535842206 | -122.43251101256 | (37.8004125358422, -122.43251101256) | |||
7125 | 7125 | 18238 | DPW Maintained 3 | Tristania conferta :: 79 | 1790X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003705.6129 | 2114238.8254 | 37.7855061428919 | -122.430928082284 | (37.7855061428919, -122.430928082284) | ||
7203 | 7203 | 8199 | DPW Maintained 3 | Tristania conferta :: 79 | 1310X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2011 12:00:00 AM | 3 | 3x3 | 6001414.7162 | 2111141.806 | 37.7768724447291 | -122.438631903562 | (37.7768724447291, -122.438631903562) | ||
8135 | 8135 | 26165 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 10 | 3x3 | 6003705.1408 | 2119642.0239 | 37.800341918970396 | -122.431315547527 | (37.8003419189704, -122.431315547527) | ||
8882 | 8882 | 99306 | Permitted Site 1 | Tristania conferta :: 79 | 1345 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | 3x3 | Permit Number 768843 | 6003605.0174 | 2112439.8748 | 37.780560974986 | -122.43114766452 | (37.780560974986, -122.43114766452) | ||
9849 | 9849 | 106206 | DPW Maintained 3 | Tristania conferta :: 79 | 1600X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5x5 | 6003113.3747 | 2114020.7176 | 37.784873699559 | -122.432961462333 | (37.784873699559, -122.432961462333) | |||
13494 | 13494 | 22395 | DPW Maintained 3 | Tristania conferta :: 79 | 5700 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/2011 12:00:00 AM | 6 | 3x3 | 6013894.8509 | 2092365.7305 | 37.726019406734295 | -122.394144192498 | (37.7260194067343, -122.394144192498) | ||
13734 | 13734 | 22404 | DPW Maintained 3 | Tristania conferta :: 79 | 5800 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6013789.3037 | 2092097.7658 | 37.72527776259471 | -122.394490310229 | (37.7252777625947, -122.394490310229) | |||
13919 | 13919 | 29521 | DPW Maintained 3 | Tristania conferta :: 79 | 2006X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016098.1753 | 2092465.4708 | 37.726415492982795 | -122.386534320443 | (37.7264154929828, -122.386534320443) | ||
14449 | 14449 | 29495 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016616.3583 | 2093144.917 | 37.7283097910179 | -122.384790279442 | (37.7283097910179, -122.384790279442) | ||
14469 | 14469 | 95295 | DPW Maintained 3 | Tristania conferta :: 79 | 4049 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015625.3016 | 2097623.8233 | 37.740553100681 | -122.388528940359 | (37.740553100681, -122.388528940359) | |||
14504 | 14504 | 29438 | DPW Maintained 3 | Tristania conferta :: 79 | 2305X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015624.4095 | 2091751.2497 | 37.72442814458989 | -122.388122301142 | (37.7244281445899, -122.388122301142) | ||
15085 | 15085 | 29384 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014251.8169 | 2089910.1925 | 37.7192968231465 | -122.39273846811199 | (37.7192968231465, -122.392738468112) | ||
15225 | 15225 | 22440 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 3 | 3X3 | 6013624.7927 | 2091445.832 | 37.723478536743 | -122.395013371509 | (37.723478536743, -122.395013371509) | ||
15822 | 15822 | 29431 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015465.5668 | 2091536.6323 | 37.7238300455694 | -122.388656428754 | (37.7238300455694, -122.388656428754) | ||
17736 | 17736 | 15285 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007055.561000001 | 2109424.3851 | 37.772476092683895 | -122.41899662559999 | (37.7724760926839, -122.4189966256) | ||
19569 | 19569 | 9656 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006068.1921 | 2109906.7312 | 37.773744850157 | -122.422446316196 | (37.773744850157, -122.422446316196) | ||
22810 | 22810 | 141129 | Undocumented 2 | Tristania conferta :: 79 | 1740 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002454.9272 | 2113020.8946 | 37.782091069378296 | -122.43516793707701 | (37.7820910693783, -122.435167937077) | |||
23573 | 23573 | 143104 | Undocumented 2 | Tristania conferta :: 79 | 1736 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010039.5193 | 2120117.0378 | 37.8020031344426 | -122.40942953292802 | (37.8020031344426, -122.409429532928) | |||
25260 | 25260 | 137791 | Undocumented 2 | Tristania conferta :: 79 | 1711 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005267.8978 | 2115649.4507 | 37.789467764436395 | -122.425623465766 | (37.7894677644364, -122.425623465766) | |||
25264 | 25264 | 142786 | Undocumented 2 | Tristania conferta :: 79 | 730 POLK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007071.7839 | 2113562.2092 | 37.7838384745362 | -122.419234083256 | (37.7838384745362, -122.419234083256) | |||
27173 | 27173 | 247332 | Undocumented 2 | Tristania conferta :: 79 | 755 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003759.8807 | 2110373.3337 | 37.7748955391679 | -122.430464426106 | (37.7748955391679, -122.430464426106) | |||
27680 | 27680 | 142315 | Undocumented 2 | Tristania conferta :: 79 | 1679 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999782.049 | 2110521.1531 | 37.7750752776396 | -122.444235164846 | (37.7750752776396, -122.444235164846) | |||
27736 | 27736 | 140098 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005841.2329 | 2111549.6492 | 37.7782430990341 | -122.42334822002701 | (37.7782430990341, -122.423348220027) | |||
27820 | 27820 | 95598 | Undocumented 2 | Tristania conferta :: 79 | 1625 Carroll Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013982.6065 | 2092044.9941 | 37.725143606345206 | -122.393818384028 | (37.7251436063452, -122.393818384028) | |||
28789 | 28789 | 141775 | Undocumented 2 | Tristania conferta :: 79 | 1330 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003753.6876 | 2113301.7561 | 37.7829359095028 | -122.430694865244 | (37.7829359095028, -122.430694865244) | |||
37347 | 37347 | 141355 | Undocumented 2 | Tristania conferta :: 79 | 501 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002140.2005 | 2110240.1427 | 37.7744379464273 | -122.436057700577 | (37.7744379464273, -122.436057700577) | |||
37454 | 37454 | 137840 | Undocumented 2 | Tristania conferta :: 79 | 1800X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005085.0 | 2115443.0 | 37.7888905662133 | -122.42624156812799 | (37.7888905662133, -122.426241568128) | |||
38887 | 38887 | 139930 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005698.3365 | 2112597.5586 | 37.7811123361694 | -122.42391708697599 | (37.7811123361694, -122.423917086976) | |||
39119 | 39119 | 140036 | Undocumented 2 | Tristania conferta :: 79 | 970 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001970.0892 | 2111822.8668 | 37.7787740442343 | -122.43675946777799 | (37.7787740442343, -122.436759467778) | |||
39972 | 39972 | 142048 | Undocumented 2 | Tristania conferta :: 79 | 345 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005931.8739 | 2110913.1417 | 37.77650051922029 | -122.422989407689 | (37.7765005192203, -122.422989407689) | |||
42474 | 42474 | 142794 | Undocumented 2 | Tristania conferta :: 79 | 537 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007553.8618 | 2113233.0652 | 37.782961862617796 | -122.417542933515 | (37.7829618626178, -122.417542933515) | |||
43098 | 43098 | 142370 | Undocumented 2 | Tristania conferta :: 79 | 1041 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005599.4645 | 2113294.0647 | 37.7830191883263 | -122.424308687896 | (37.7830191883263, -122.424308687896) | |||
45760 | 45760 | 140044 | Undocumented 2 | Tristania conferta :: 79 | 920 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001989.2532 | 2111661.9499 | 37.778333296035 | -122.43668165046199 | (37.778333296035, -122.436681650462) | |||
51792 | 51792 | 245427 | Undocumented 2 | Tristania conferta :: 79 | 2500 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009012.3222 | 2106874.66 | 37.7655851322084 | -122.412047747256 | (37.7655851322084, -122.412047747256) | |||
52788 | 52788 | 140501 | Undocumented 2 | Tristania conferta :: 79 | 961 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003835.0655 | 2112008.5054 | 37.7793895753187 | -122.43032103371799 | (37.7793895753187, -122.430321033718) | |||
53081 | 53081 | 122839 | Undocumented 2 | Tristania conferta :: 79 | 945 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x3 | 6001935.4114 | 2111748.3401 | 37.77856744182179 | -122.43687409503401 | (37.7785674418218, -122.436874095034) | |||
55734 | 55734 | 139804 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005645.4415 | 2112973.1088 | 37.782140518457105 | -122.424126793395 | (37.7821405184571, -122.424126793395) | |||
56800 | 56800 | 143430 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010708.6813 | 2116911.5375 | 37.7932390808025 | -122.406887849913 | (37.7932390808025, -122.406887849913) | |||
58299 | 58299 | 200821 | Undocumented 2 | Tristania conferta :: 79 | 5210 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014424.8043 | 2093925.5984 | 37.7303319313757 | -122.392421219379 | (37.7303319313757, -122.392421219379) | |||
58534 | 58534 | 41235 | Permitted Site 1 | Tristania conferta :: 79 | 270 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | 14 | Permit Number 41940 | 5998984.5808 | 2112167.7332 | 37.7795508339841 | -122.44711229551001 | (37.7795508339841, -122.44711229551) | ||
63030 | 63030 | 246309 | Undocumented 2 | Tristania conferta :: 79 | 1601 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007064.7803 | 2109330.2021 | 37.772218007718 | -122.41895805383498 | (37.772218007718, -122.418958053835) | |||
63176 | 63176 | 138754 | Undocumented 2 | Tristania conferta :: 79 | 2353 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001354.2081 | 2114211.9636 | 37.785298874430104 | -122.439061306521 | (37.7852988744301, -122.439061306521) | |||
63527 | 63527 | 199953 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016430.7222 | 2092829.8313 | 37.7274343589932 | -122.38541008953501 | (37.7274343589932, -122.385410089535) | |||
66875 | 66875 | 138524 | Undocumented 2 | Tristania conferta :: 79 | 1606 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001651.0494 | 2114066.6351 | 37.7849167251316 | -122.43802391431299 | (37.7849167251316, -122.438023914313) | |||
69287 | 69287 | 244951 | Undocumented 2 | Tristania conferta :: 79 | 251 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005979.0205 | 2110582.4222 | 37.775595103799795 | -122.42280280478201 | (37.7755951037998, -122.422802804782) | |||
69366 | 69366 | 93014 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) |
72028 | 72028 | 47574 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014716.8904 | 2115082.0105 | 37.7884390883158 | -122.39289101606899 | (37.7884390883158, -122.392891016069) | ||
73293 | 73293 | 137778 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001070.034 | 2111731.4491 | 37.7784718415014 | -122.43986654775298 | (37.7784718415014, -122.439866547753) | |||
73575 | 73575 | 141172 | Undocumented 2 | Tristania conferta :: 79 | 1804 ELLIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002097.0461 | 2112969.6237 | 37.7819299636463 | -122.43640237071101 | (37.7819299636463, -122.436402370711) | |||
75632 | 75632 | 140350 | Undocumented 2 | Tristania conferta :: 79 | 1314 ELLIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004464.0389 | 2113300.6657 | 37.782973134082 | -122.42823726583099 | (37.782973134082, -122.428237265831) | |||
76601 | 76601 | 200961 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013983.5299 | 2092601.4044 | 37.72667144833171 | -122.39385412187401 | (37.7266714483317, -122.393854121874) | |||
130500 | 130500 | 199704 | Undocumented 2 | Tristania conferta :: 79 | 1920 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016256.4636 | 2092675.6975 | 37.7270014954531 | -122.386001767813 | (37.7270014954531, -122.386001767813) | |||
135082 | 135082 | 138783 | Undocumented 2 | Tristania conferta :: 79 | 1600 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003596.9905 | 2114337.1163 | 37.78576986972271 | -122.431310902354 | (37.7857698697227, -122.431310902354) | |||
135929 | 135929 | 121010 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6015151.8392 | 2115494.3379 | 37.78959539413329 | -122.391414985971 | (37.7895953941333, -122.391414985971) | |||
146612 | 146612 | 200989 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015396.5622 | 2115726.7219 | 37.790247046647295 | -122.39058450781499 | (37.7902470466473, -122.390584507815) | |||
149704 | 149704 | 200516 | Undocumented 2 | Tristania conferta :: 79 | 5701 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6013944.6393 | 2092273.2471 | 37.7257682331576 | -122.39396560465299 | (37.7257682331576, -122.393965604653) | |||
150258 | 150258 | 199798 | Undocumented 2 | Tristania conferta :: 79 | 2655 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015121.8998 | 2091073.261 | 37.7225386672258 | -122.389812088389 | (37.7225386672258, -122.389812088389) | |||
152647 | 152647 | 200243 | Undocumented 2 | Tristania conferta :: 79 | 3099 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014440.6296 | 2090158.0853 | 37.719987972824896 | -122.39210313506099 | (37.7199879728249, -122.392103135061) | |||
152722 | 152722 | 141093 | Undocumented 2 | Tristania conferta :: 79 | 190 Jordan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5996268.2382 | 2113005.3272 | 37.781695071030796 | -122.456569818134 | (37.7816950710308, -122.456569818134) | |||
153307 | 153307 | 50650 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2012 12:00:00 AM | 2 | Permit Number 768661 | 6012184.2732 | 2112660.7106 | 37.7816497657614 | -122.401483287822 | (37.7816497657614, -122.401483287822) | ||
156234 | 156234 | 200662 | Undocumented 2 | Tristania conferta :: 79 | 1532 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6015174.2771 | 2095413.8657 | 37.734460003730995 | -122.389934087199 | (37.734460003731, -122.389934087199) | |||
157203 | 157203 | 142353 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005235.1926 | 2113355.2198 | 37.783166529217404 | -122.42557327398701 | (37.7831665292174, -122.425573273987) | |||
157621 | 157621 | 200506 | Undocumented 2 | Tristania conferta :: 79 | 5835 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013835.4074 | 2091990.0292 | 37.7249845024722 | -122.39432339322398 | (37.7249845024722, -122.394323393224) | |||
158442 | 158442 | 200936 | Undocumented 2 | Tristania conferta :: 79 | 4240 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015378.4854 | 2097095.9435 | 37.7390899699971 | -122.389345489075 | (37.7390899699971, -122.389345489075) | |||
160051 | 160051 | 200929 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015540.274 | 2097341.815 | 37.7397740512845 | -122.38880325291402 | (37.7397740512845, -122.388803252914) | |||
163855 | 163855 | 200667 | Undocumented 2 | Tristania conferta :: 79 | 1593 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015303.436000001 | 2095600.1842 | 37.7349787586684 | -122.389500546178 | (37.7349787586684, -122.389500546178) | |||
165610 | 165610 | 245024 | Undocumented 2 | Tristania conferta :: 79 | 291 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001247.6582 | 2109580.5442 | 37.7725761073824 | -122.43909788373699 | (37.7725761073824, -122.439097883737) | |||
170461 | 170461 | 95307 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6014265.14 | 2093118.9766 | 37.728108243383105 | -122.392916792791 | (37.7281082433831, -122.392916792791) | |||
173254 | 173254 | 200897 | Undocumented 2 | Tristania conferta :: 79 | 4251 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015457.1359 | 2097071.1438 | 37.7390262352486 | -122.38907181799699 | (37.7390262352486, -122.389071817997) | |||
179733 | 179733 | 200187 | Undocumented 2 | Tristania conferta :: 79 | 2999 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6014602.6431 | 2090373.0881 | 37.720587322073 | -122.391558129174 | (37.720587322073, -122.391558129174) | |||
182827 | 182827 | 199877 | Undocumented 2 | Tristania conferta :: 79 | 1501 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6017008.6079 | 2093600.4201 | 37.7295821995791 | -122.383465938576 | (37.7295821995791, -122.383465938576) | |||
188298 | 188298 | 245889 | Undocumented 2 | Tristania conferta :: 79 | 208 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001301.3376 | 2109508.5838 | 37.7723815763595 | -122.438907043703 | (37.7723815763595, -122.438907043703) |
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");