trees
1,914 rows where qSpecies_id = 45 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
2087 | 261314 | Permitted Site 7 | :: 45 | 2601 Divisadero St | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x106 | ||||||||||||
2635 | 259636 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
3035 | 259640 | DPW Maintained 1 | :: 45 | 198x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
4471 | 259626 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
4568 | 253833 | DPW Maintained 1 | :: 45 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
4944 | 259613 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
5006 | 259624 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
5098 | 251531 | DPW Maintained 1 | :: 45 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
6366 | 117001 | DPW Maintained 1 | :: 45 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
6535 | 259627 | DPW Maintained 1 | :: 45 | 1499x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
8424 | 261322 | Private 9 | :: 45 | 811 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2020 12:00:00 AM | 3 | 3x3 | ||||||||||||
10803 | 259618 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
12379 | 259619 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
12908 | 259612 | DPW Maintained 1 | :: 45 | 1000 Visitacion Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
14450 | 259622 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
14847 | 259625 | DPW Maintained 1 | :: 45 | 1401x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
15760 | 251532 | DPW Maintained 1 | :: 45 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 05/15/2017 12:00:00 AM | 3 | 4x11 | ||||||||||||
15847 | 259635 | DPW Maintained 1 | :: 45 | 98x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
16880 | 259621 | DPW Maintained 1 | :: 45 | 1398x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
17295 | 259617 | DPW Maintained 1 | :: 45 | 1200x Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
17929 | 259649 | DPW Maintained 1 | :: 45 | 700 Delta St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
17931 | 259643 | DPW Maintained 1 | :: 45 | 241 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
18667 | 259652 | DPW Maintained 1 | :: 45 | 99x Cora St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
18887 | 259638 | DPW Maintained 1 | :: 45 | 99x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
146 | 190658 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | 10 | 3 | 8 | 58 | 1 | |||
244 | 200570 | DPW Maintained 1 | :: 45 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.385889477594 | (37.7342110910182, -122.385889477594) | 10 | 3 | 8 | 58 | 1 | |||
295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
1851 | 200636 | DPW Maintained 1 | :: 45 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.7291810369364 | -122.384238246013 | (37.7291810369364, -122.384238246013) | 10 | 3 | 8 | 58 | 1 | |||
2464 | 190663 | DPW Maintained 1 | :: 45 | 1360 Fairfax Ave | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6016747.40621 | 2097393.16894 | 37.7399818904553 | -122.384633036796 | (37.7399818904553, -122.384633036796) | 10 | 3 | 8 | 58 | 1 | |||
8110 | 200249 | DPW Maintained 1 | :: 45 | 1067 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013803.2037 | 2090093.549 | 37.7197753570889 | -122.394301997885 | (37.7197753570889, -122.394301997885) | 10 | 3 | 8 | 58 | 1 | |||
9415 | 200180 | DPW Maintained 1 | :: 45 | 1031 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014690.5634 | 2089785.0188 | 37.7189774793874 | -122.391213128817 | (37.7189774793874, -122.391213128817) | 10 | 3 | 8 | 58 | 1 | |||
9942 | 200177 | DPW Maintained 1 | :: 45 | 1041 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014650.3204 | 2089811.8475 | 37.7190489123065 | -122.39135410876 | (37.7190489123065, -122.39135410876) | 10 | 3 | 8 | 58 | 1 | |||
11756 | 108765 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | ||||
12451 | 200191 | DPW Maintained 1 | :: 45 | 981 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014255.2675 | 2089757.5194 | 37.7188778046353 | -122.392715865878 | (37.7188778046353, -122.392715865878) | 10 | 3 | 8 | 58 | 1 | |||
16374 | 200211 | DPW Maintained 1 | :: 45 | 974 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014078.3317 | 2089599.897 | 37.7184351760665 | -122.39331644356 | (37.7184351760665, -122.39331644356) | 10 | 3 | 8 | 58 | 1 | |||
18831 | 199650 | DPW Maintained 1 | :: 45 | 0 | 1 | : | Tree | Private 2 | 0 | Width 0ft | 6014963.58685 | 2093280.81794 | 37.7285913984524 | -122.390513521988 | (37.7285913984524, -122.390513521988) | 10 | 3 | 8 | 58 | 1 | |||
22783 | 200577 | DPW Maintained 1 | :: 45 | 1701 Keith St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015592.5071 | 2093926.7262 | 37.7303998031535 | -122.388384353362 | (37.7303998031535, -122.388384353362) | 10 | 3 | 8 | 58 | 1 | |||
25967 | 6810 | DPW Maintained 1 | :: 45 | 1400X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016518.03729 | 2097563.61739 | 37.74043721991 | -122.38543798217 | (37.74043721991, -122.38543798217) | 10 | 3 | 8 | 58 | 1 | ||
26314 | 200498 | DPW Maintained 1 | :: 45 | 1055 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013869.6047 | 2090039.2209 | 37.7196298737115 | -122.394068670065 | (37.7196298737115, -122.394068670065) | 10 | 3 | 8 | 58 | 1 | |||
28805 | 200245 | DPW Maintained 1 | :: 45 | 1075 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013768.3263 | 2090118.3656 | 37.7198415597531 | -122.394424294358 | (37.7198415597531, -122.394424294358) | 10 | 3 | 8 | 58 | 1 | |||
31214 | 199649 | DPW Maintained 1 | :: 45 | 1601 Evans Ave | 22 | : | Tree | Private 2 | 0 | Width 1ft | 6015107.35337 | 2098882.19142 | 37.7439796026678 | -122.390407721252 | (37.7439796026678, -122.390407721252) | 10 | 3 | 8 | 58 | 1 | |||
35508 | 3826 | DPW Maintained 1 | :: 45 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | 10 | 3 | 8 | 58 | 1 | ||
35874 | 200502 | DPW Maintained 1 | :: 45 | 1500 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014797.5113 | 2092210.0981 | 37.7256422016088 | -122.391012853891 | (37.7256422016088, -122.391012853891) | 10 | 3 | 8 | 58 | 1 | |||
36523 | 190662 | DPW Maintained 1 | :: 45 | 1498 Fairfax Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | 10 | 3 | 8 | 58 | 1 | |||
43706 | 200497 | DPW Maintained 1 | :: 45 | 1110 Gilman Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014977.2953 | 2089975.1673 | 37.7195154981888 | -122.390235277748 | (37.7195154981888, -122.390235277748) | 10 | 3 | 8 | 58 | 1 | |||
46090 | 173847 | DPW Maintained 1 | :: 45 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
46407 | 173850 | DPW Maintained 1 | :: 45 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
47594 | 6841 | DPW Maintained 1 | :: 45 | 1461 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016176.35578 | 2097734.00436 | 37.7408861578704 | -122.386631271932 | (37.7408861578704, -122.386631271932) | 10 | 3 | 8 | 58 | 1 | ||
50825 | 200155 | DPW Maintained 1 | :: 45 | 1091 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014363.9238 | 2090021.1115 | 37.7196076106807 | -122.392358707449 | (37.7196076106807, -122.392358707449) | 10 | 3 | 8 | 58 | 1 | |||
60026 | 40070 | Permitted Site 7 | :: 45 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | 10 | 3 | 8 | 58 | 1 | ||
62362 | 200730 | DPW Maintained 1 | :: 45 | 1466 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.73326392707 | -122.387841787924 | (37.73326392707, -122.387841787924) | 10 | 3 | 8 | 58 | 1 | |||
62817 | 200162 | DPW Maintained 1 | :: 45 | 1035 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013970.2124 | 2089969.4662 | 37.7194439323961 | -122.393716023061 | (37.7194439323961, -122.393716023061) | 10 | 3 | 8 | 58 | 1 | |||
66506 | 200248 | DPW Maintained 1 | :: 45 | 1107 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014274.7183 | 2090092.8783 | 37.7197997141545 | -122.392672078819 | (37.7197997141545, -122.392672078819) | 10 | 3 | 8 | 58 | 1 | |||
66935 | 200181 | DPW Maintained 1 | :: 45 | 1175 Ingerson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 0 | Width 0ft | 6013299.4945 | 2090456.4074 | 37.7207436812319 | -122.396068570714 | (37.7207436812319, -122.396068570714) | 10 | 3 | 8 | 58 | 1 | |||
69996 | 200194 | DPW Maintained 1 | :: 45 | 1011 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014781.1104 | 2089713.252 | 37.7187854464432 | -122.390895127615 | (37.7187854464432, -122.390895127615) | 10 | 3 | 8 | 58 | 1 | |||
70303 | 190657 | DPW Maintained 1 | :: 45 | 301 Mendell St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016835.36544 | 2097808.79392 | 37.7411279765664 | -122.38435784694 | (37.7411279765664, -122.38435784694) | 10 | 3 | 8 | 58 | 1 | |||
71785 | 200213 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 2 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013590.5861 | 2090251.1677 | 37.7201963256026 | -122.395047981349 | (37.7201963256026, -122.395047981349) | 10 | 3 | 8 | 58 | 1 | |||
75061 | 200171 | DPW Maintained 1 | :: 45 | 1059 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014549.7127 | 2089886.9679 | 37.7192495938582 | -122.391707122944 | (37.7192495938582, -122.391707122944) | 10 | 3 | 8 | 58 | 1 | |||
76602 | 200226 | DPW Maintained 1 | :: 45 | 1131 Fitzgerald Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015013.4132 | 2090222.9153 | 37.7201977688326 | -122.390127728915 | (37.7201977688326, -122.390127728915) | 10 | 3 | 8 | 58 | 1 | |||
77012 | 200166 | DPW Maintained 1 | :: 45 | 1023 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014031.9185 | 2089919.1624 | 37.7193092369184 | -122.393499207549 | (37.7193092369184, -122.393499207549) | 10 | 3 | 8 | 58 | 1 | |||
79157 | 173848 | DPW Maintained 1 | :: 45 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
86077 | 200212 | DPW Maintained 1 | :: 45 | 1101 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013545.648 | 2090276.655 | 37.7202638095936 | -122.395205102903 | (37.7202638095936, -122.395205102903) | 10 | 3 | 8 | 58 | 1 | |||
86162 | 254706 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
91643 | 97034 | Property Tree 8 | :: 45 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
94232 | 200742 | DPW Maintained 1 | :: 45 | 1454 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.7331467841736 | -122.387617287866 | (37.7331467841736, -122.387617287866) | 10 | 3 | 8 | 58 | 1 | |||
95387 | 14993 | DPW Maintained 1 | :: 45 | 1445 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6016309.01096 | 2097636.9306 | 37.7406269561715 | -122.38616582959 | (37.7406269561715, -122.38616582959) | 10 | 3 | 8 | 58 | 1 | ||
95954 | 200161 | DPW Maintained 1 | :: 45 | 1083 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014425.6299 | 2089982.8806 | 37.7195060625081 | -122.392142737787 | (37.7195060625081, -122.392142737787) | 10 | 3 | 8 | 58 | 1 | |||
97709 | 200156 | DPW Maintained 1 | :: 45 | 1047 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013914.5428 | 2090009.7093 | 37.7195513382693 | -122.39391126933 | (37.7195513382693, -122.39391126933) | 10 | 3 | 8 | 58 | 1 | |||
98467 | 200699 | DPW Maintained 1 | :: 45 | 1501 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6015860.7307 | 2095472.4329 | 37.7346588632003 | -122.387564854217 | (37.7346588632003, -122.387564854217) | 10 | 3 | 8 | 58 | 1 | |||
98915 | 199651 | DPW Maintained 1 | :: 45 | 0 | 37 | : | Tree | Private 2 | 0 | Width 0ft | 6018297.01834 | 2097895.80454 | 37.7414476037323 | -122.379309965799 | (37.7414476037323, -122.379309965799) | 10 | 3 | 8 | 58 | 1 | |||
99412 | 200808 | DPW Maintained 1 | :: 45 | 1401 Oakdale Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6016065.8568 | 2094678.3259 | 37.7324897642599 | -122.386800296411 | (37.7324897642599, -122.386800296411) | 10 | 3 | 8 | 58 | 1 | |||
100708 | 200169 | DPW Maintained 1 | :: 45 | 1061 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014525.5668 | 2089911.1138 | 37.7193145533562 | -122.391792274296 | (37.7193145533562, -122.391792274296) | 10 | 3 | 8 | 58 | 1 | |||
101961 | 200202 | DPW Maintained 1 | :: 45 | 1090 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6013720.7054 | 2090215.6197 | 37.72010595277 | -122.394595711042 | (37.72010595277, -122.394595711042) | 10 | 3 | 8 | 58 | 1 | |||
103836 | 200167 | DPW Maintained 1 | :: 45 | 1019 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014049.3571 | 2089910.443 | 37.7192862641022 | -122.393438318502 | (37.7192862641022, -122.393438318502) | 10 | 3 | 8 | 58 | 1 | |||
107754 | 200193 | DPW Maintained 1 | :: 45 | 975 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014303.5592 | 2089724.6542 | 37.7187902452961 | -122.392546641558 | (37.7187902452961, -122.392546641558) | 10 | 3 | 8 | 58 | 1 | |||
109923 | 254704 | Permitted Site 7 | :: 45 | 1443 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 6016508.44225 | 2096807.14943 | 37.7383595811637 | -122.385418455981 | (37.7383595811637, -122.385418455981) | 10 | 3 | 8 | 58 | 1 | |||
110125 | 108826 | Undocumented 4 | :: 45 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | ||||
110361 | 6809 | DPW Maintained 1 | :: 45 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.97847 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | 10 | 3 | 8 | 58 | 1 | ||
114033 | 173849 | DPW Maintained 1 | :: 45 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
115260 | 200762 | DPW Maintained 1 | :: 45 | 1999 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6014632.1803 | 2093750.8421 | 37.7298635995705 | -122.391692072282 | (37.7298635995705, -122.391692072282) | 10 | 3 | 8 | 58 | 1 | |||
115629 | 200244 | DPW Maintained 1 | :: 45 | 1123 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014193.5615 | 2090152.5722 | 37.7199591140845 | -122.392956785762 | (37.7199591140845, -122.392956785762) | 10 | 3 | 8 | 58 | 1 | |||
118244 | 200165 | DPW Maintained 1 | :: 45 | 1071 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014485.3238 | 2089939.2839 | 37.7193896687982 | -122.391933349185 | (37.7193896687982, -122.391933349185) | 10 | 3 | 8 | 58 | 1 | |||
119776 | 200234 | DPW Maintained 1 | :: 45 | 2895 Hawes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014768.3667 | 2089489.9029 | 37.7181714665431 | -122.390923576462 | (37.7181714665431, -122.390923576462) | 10 | 3 | 8 | 58 | 1 | |||
119892 | 200501 | DPW Maintained 1 | :: 45 | 1550 Armstrong Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014687.5837 | 2092287.487 | 37.7258485955534 | -122.391398275474 | (37.7258485955534, -122.391398275474) | 10 | 3 | 8 | 58 | 1 | |||
122628 | 200190 | DPW Maintained 1 | :: 45 | 1027 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014706.6607 | 2089771.6044 | 37.7189415394071 | -122.391156549139 | (37.7189415394071, -122.391156549139) | 10 | 3 | 8 | 58 | 1 | |||
123816 | 200722 | DPW Maintained 1 | :: 45 | 1476 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6015747.1852 | 2094980.6714 | 37.7333022953684 | -122.387923119588 | (37.7333022953684, -122.387923119588) | 10 | 3 | 8 | 58 | 1 | |||
125844 | 200178 | DPW Maintained 1 | :: 45 | 3201 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014218.378 | 2089782.3359 | 37.7189438969212 | -122.39284511455 | (37.7189438969212, -122.39284511455) | 10 | 3 | 8 | 58 | 1 | |||
126949 | 190660 | DPW Maintained 1 | :: 45 | 1395 Fairfax Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6016617.23425 | 2097405.156 | 37.7400076047554 | -122.385083956852 | (37.7400076047554, -122.385083956852) | 10 | 3 | 8 | 58 | 1 | |||
127369 | 200507 | DPW Maintained 1 | :: 45 | 1510 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6014614.4494 | 2091644.4715 | 37.724078943993 | -122.391606161162 | (37.724078943993, -122.391606161162) | 10 | 3 | 8 | 58 | 1 | |||
127885 | 190661 | DPW Maintained 1 | :: 45 | 1400 Fairfax Ave | 12 | : | Tree | Private 2 | 7 | Width 3ft | 6016311.59703 | 2097718.64456 | 37.7408514692121 | -122.386162583062 | (37.7408514692121, -122.386162583062) | 10 | 3 | 8 | 58 | 1 | |||
128848 | 200239 | DPW Maintained 1 | :: 45 | 1131 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014148.6234 | 2090188.791 | 37.7200560674381 | -122.393114655414 | (37.7200560674381, -122.393114655414) | 10 | 3 | 8 | 58 | 1 | |||
130099 | 6759 | DPW Maintained 1 | :: 45 | 1275 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2015 12:51:00 PM | 3 | 3x3 | 6017200.09768 | 2096971.16598 | 37.7388481798969 | -122.383038438091 | (37.7388481798969, -122.383038438091) | 10 | 3 | 8 | 58 | 1 | ||
130887 | 173851 | DPW Maintained 1 | :: 45 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
130912 | 200238 | DPW Maintained 1 | :: 45 | 917 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014595.9922 | 2089500.6344 | 37.7181913669776 | -122.391520156023 | (37.7181913669776, -122.391520156023) | 10 | 3 | 8 | 58 | 1 |
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) );