trees
861 rows where qSpecies_id = 18 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1422 | 259801 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
7878 | 259091 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
11502 | 259802 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
13366 | 259090 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
14717 | 259092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
18615 | 259800 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
80345 | 41525 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.7336937659006 | -122.37859297315 | (37.7336937659006, -122.37859297315) | 10 | 3 | 8 | 58 | 1 | |||
58693 | 200018 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.379068779178 | (37.7254942451327, -122.379068779178) | 10 | 3 | 8 | 58 | 1 | |||
75574 | 199962 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1265 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6018011.037 | 2092725.2017 | 37.7272343718441 | -122.379939611903 | (37.7272343718441, -122.379939611903) | 10 | 3 | 8 | 58 | 1 | |||
79185 | 199935 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1310 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6017874.9241 | 2092620.1152 | 37.7269383150479 | -122.380402857754 | (37.7269383150479, -122.380402857754) | 10 | 3 | 8 | 58 | 1 | |||
8854 | 75284 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1335 Griffith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6017835.3471 | 2092484.583 | 37.7265639860027 | -122.380530259866 | (37.7265639860027, -122.380530259866) | 10 | 3 | 8 | 58 | 1 | |||
51303 | 200000 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | 10 | 3 | 8 | 58 | 1 | |||
27627 | 200009 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1435 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017676.8443 | 2092268.1534 | 37.7259609644208 | -122.381063162948 | (37.7259609644208, -122.381063162948) | 10 | 3 | 8 | 58 | 1 | |||
24160 | 200002 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6017646.9261 | 2092314.6221 | 37.726086906985 | -122.381169818775 | (37.726086906985, -122.381169818775) | 10 | 3 | 8 | 58 | 1 | |||
85279 | 200004 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1450 Griffith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6017626.5562 | 2092285.3405 | 37.7260053809224 | -122.381238201921 | (37.7260053809224, -122.381238201921) | 10 | 3 | 8 | 58 | 1 | |||
18052 | 197677 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 410 China Basin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2020 12:00:00 AM | 3 | Width 5ft | Permit Number 784444 | 6015989.40646 | 2109125.42769 | 37.7721542427634 | -122.388072430121 | (37.7721542427634, -122.388072430121) | 14 | 3 | 9 | 310 | 20 | |
44928 | 38574 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | 10 | 3 | 8 | 58 | 1 | |
185996 | 50456 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171 | (37.7596818177679, -122.38931576171) | 10 | 3 | 8 | 28856 | 29 | ||
170603 | 200097 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015067.4938 | 2092354.869 | 37.7260546913573 | -122.390089647295 | (37.7260546913573, -122.390089647295) | 10 | 3 | 8 | 58 | 1 | |||
183963 | 200098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015053.9581 | 2092365.0208 | 37.7260818154372 | -122.390137148672 | (37.7260818154372, -122.390137148672) | 10 | 3 | 8 | 58 | 1 | |||
65371 | 200099 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015044.483 | 2092374.4958 | 37.7261073063636 | -122.390170565448 | (37.7261073063636, -122.390170565448) | 10 | 3 | 8 | 58 | 1 | |||
131123 | 200103 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014982.2186 | 2092417.8102 | 37.7262227853507 | -122.390388836652 | (37.7262227853507, -122.390388836652) | 10 | 3 | 8 | 58 | 1 | |||
64266 | 57069 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | 10 | 3 | 8 | 28856 | 29 | |
55950 | 200104 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.390452952009 | (37.726258938018, -122.390452952009) | 10 | 3 | 8 | 58 | 1 | |||
187013 | 200105 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1528 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014949.7328 | 2092444.2049 | 37.7262934578304 | -122.390502982758 | (37.7262934578304, -122.390502982758) | 10 | 3 | 8 | 58 | 1 | |||
25784 | 99395 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
35863 | 99398 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
45765 | 99380 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | |
51411 | 99394 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
71036 | 99387 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
74332 | 99393 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
135449 | 99385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
151040 | 99386 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
171921 | 99379 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | |
180619 | 99381 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
191047 | 99399 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
172712 | 191251 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.390718148336 | (37.7618193498029, -122.390718148336) | 10 | 3 | 8 | 28856 | 29 | |||
178232 | 191253 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6015148.44265 | 2105367.15882 | 37.7617882296504 | -122.390718735586 | (37.7617882296504, -122.390718735586) | 10 | 3 | 8 | 28856 | 29 | |||
101952 | 191250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015147.38841 | 2105382.23529 | 37.7618295678896 | -122.390723435432 | (37.7618295678896, -122.390723435432) | 10 | 3 | 8 | 28856 | 29 | |||
122965 | 191252 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6015147.22099 | 2105373.94992 | 37.7618068087648 | -122.390723435452 | (37.7618068087648, -122.390723435452) | 10 | 3 | 8 | 28856 | 29 | |||
94581 | 191298 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015180.16063 | 2107302.1939 | 37.7671031752919 | -122.390744266449 | (37.7671031752919, -122.390744266449) | 14 | 3 | 9 | 310 | 20 | |||
155580 | 191299 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015177.82762 | 2107330.32237 | 37.7671802804819 | -122.390754301979 | (37.7671802804819, -122.390754301979) | 14 | 3 | 9 | 310 | 20 | |||
181056 | 191300 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015176.683 | 2107358.12451 | 37.767256555574 | -122.390760204217 | (37.767256555574, -122.390760204217) | 14 | 3 | 9 | 310 | 20 | |||
104925 | 191301 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015174.99109 | 2107387.31726 | 37.7673366186106 | -122.390768096675 | (37.7673366186106, -122.390768096675) | 14 | 3 | 9 | 310 | 20 | |||
22042 | 102557 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
28352 | 102555 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
54279 | 102559 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
131073 | 102554 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
157982 | 102560 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
188829 | 102556 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
192681 | 102558 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
112739 | 191302 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015174.0673 | 2107416.87345 | 37.7674177221897 | -122.390773357708 | (37.7674177221897, -122.390773357708) | 14 | 3 | 9 | 310 | 20 | |||
102404 | 191303 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015172.36775 | 2107445.68773 | 37.7674967456035 | -122.390781250171 | (37.7674967456035, -122.390781250171) | 14 | 3 | 9 | 310 | 20 | |||
33798 | 191304 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015169.51274 | 2107473.76779 | 37.7675736888995 | -122.390793087953 | (37.7675736888995, -122.390793087953) | 14 | 3 | 9 | 310 | 20 | |||
138022 | 191305 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015162.58842 | 2107628.3532 | 37.767997762404 | -122.390827843133 | (37.767997762404, -122.390827843133) | 14 | 3 | 9 | 310 | 20 | |||
128103 | 191306 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015160.53731 | 2107657.60104 | 37.7680779567607 | -122.390836982039 | (37.7680779567607, -122.390836982039) | 14 | 3 | 9 | 310 | 20 | |||
111327 | 191307 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015158.98774 | 2107685.52339 | 37.7681545394383 | -122.390844293528 | (37.7681545394383, -122.390844293528) | 14 | 3 | 9 | 310 | 20 | |||
143178 | 191308 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015156.6298 | 2107712.6724 | 37.7682289538399 | -122.390854347073 | (37.7682289538399, -122.390854347073) | 14 | 3 | 9 | 310 | 20 | |||
32692 | 191309 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015155.38149 | 2107742.43002 | 37.768310592479 | -122.390860744836 | (37.768310592479, -122.390860744836) | 14 | 3 | 9 | 310 | 20 | |||
32862 | 102563 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
36210 | 102562 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
72314 | 102564 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
91278 | 102561 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
104464 | 102565 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
145623 | 102566 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
165931 | 102568 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
184748 | 102567 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||
70959 | 191310 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015152.46863 | 2107768.27489 | 37.7683813952045 | -122.390872626697 | (37.7683813952045, -122.390872626697) | 14 | 3 | 9 | 310 | 20 | |||
157264 | 191311 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.7684659233813 | -122.390877196135 | (37.7684659233813, -122.390877196135) | 14 | 3 | 9 | 310 | 20 | |||
95705 | 191312 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 601 04th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015149.38015 | 2107824.64473 | 37.7685360030565 | -122.390887249657 | (37.7685360030565, -122.390887249657) | 14 | 3 | 9 | 310 | 20 | |||
48341 | 191313 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015141.50158 | 2107991.42305 | 37.7689935025667 | -122.390926158818 | (37.7689935025667, -122.390926158818) | 14 | 3 | 9 | 310 | 20 | |||
27980 | 191314 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015140.28305 | 2108016.70866 | 37.7690628636861 | -122.390932141124 | (37.7690628636861, -122.390932141124) | 14 | 3 | 9 | 310 | 20 | |||
62923 | 191315 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015139.91127 | 2108041.11608 | 37.7691298604716 | -122.390935133173 | (37.7691298604716, -122.390935133173) | 14 | 3 | 9 | 310 | 20 | |||
80330 | 191361 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015122.97696 | 2107297.48765 | 37.7670870801344 | -122.390941728784 | (37.7670870801344, -122.390941728784) | 14 | 3 | 9 | 310 | 20 | |||
31742 | 191316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015137.82836 | 2108066.41916 | 37.7691992215952 | -122.390944106589 | (37.7691992215952, -122.390944106589) | 14 | 3 | 9 | 310 | 20 | |||
165523 | 191360 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015121.96393 | 2107325.37884 | 37.7671636070317 | -122.390947182278 | (37.7671636070317, -122.390947182278) | 14 | 3 | 9 | 310 | 20 | |||
177615 | 191317 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015134.8576 | 2108090.59219 | 37.7692654305833 | -122.390956072084 | (37.7692654305833, -122.390956072084) | 14 | 3 | 9 | 310 | 20 | |||
128870 | 191359 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015119.80828 | 2107355.25601 | 37.7672455235927 | -122.39095672679 | (37.7672455235927, -122.39095672679) | 14 | 3 | 9 | 310 | 20 | |||
19841 | 191318 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015134.48609 | 2108114.99928 | 37.7693324264746 | -122.390959063205 | (37.7693324264746, -122.390959063205) | 14 | 3 | 9 | 310 | 20 | |||
7029 | 191358 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015118.78707 | 2107382.75466 | 37.7673209722044 | -122.390962181167 | (37.7673209722044, -122.390962181167) | 14 | 3 | 9 | 310 | 20 | |||
51842 | 191319 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015133.57873 | 2108141.42692 | 37.7694049406179 | -122.390964049067 | (37.7694049406179, -122.390964049067) | 14 | 3 | 9 | 310 | 20 | |||
20122 | 191320 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1505 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015132.04881 | 2108165.57051 | 37.7694711487159 | -122.390971028707 | (37.7694711487159, -122.390971028707) | 14 | 3 | 9 | 310 | 20 | |||
125735 | 191357 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015116.28501 | 2107414.99409 | 37.767409355789 | -122.390973089032 | (37.767409355789, -122.390973089032) | 14 | 3 | 9 | 310 | 20 | |||
129855 | 191356 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015114.10558 | 2107443.69394 | 37.7674880383618 | -122.390982633562 | (37.7674880383618, -122.390982633562) | 14 | 3 | 9 | 310 | 20 | |||
64744 | 191355 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1780 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015114.26665 | 2107471.16871 | 37.7675634870034 | -122.390983996927 | (37.7675634870034, -122.390983996927) | 14 | 3 | 9 | 310 | 20 | |||
20669 | 200111 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1552 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014807.6076 | 2092549.7837 | 37.7265754706661 | -122.39100168242 | (37.7265754706661, -122.39100168242) | 10 | 3 | 8 | 58 | 1 | |||
29337 | 191321 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015124.16384 | 2108316.28371 | 37.7698845364842 | -122.391008838006 | (37.7698845364842, -122.391008838006) | 14 | 3 | 9 | 310 | 20 | |||
61234 | 191322 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015122.40685 | 2108342.01647 | 37.769955095485 | -122.391016714258 | (37.769955095485, -122.391016714258) | 14 | 3 | 9 | 310 | 20 | |||
146879 | 191323 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015122.46281 | 2108363.5556 | 37.7700142403001 | -122.391018026356 | (37.7700142403001, -122.391018026356) | 14 | 3 | 9 | 310 | 20 | |||
130238 | 191354 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015105.75589 | 2107627.1199 | 37.7679912225533 | -122.391024336029 | (37.7679912225533, -122.391024336029) | 14 | 3 | 9 | 310 | 20 | |||
71155 | 191324 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015118.87024 | 2108392.34888 | 37.770093100956 | -122.391032465874 | (37.770093100956, -122.391032465874) | 14 | 3 | 9 | 310 | 20 | |||
39235 | 191325 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015118.6002 | 2108416.53972 | 37.7701595086914 | -122.391035090994 | (37.7701595086914, -122.391035090994) | 14 | 3 | 9 | 310 | 20 | |||
75861 | 191353 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015102.63762 | 2107654.62196 | 37.7680665641485 | -122.391037044335 | (37.7680665641485, -122.391037044335) | 14 | 3 | 9 | 310 | 20 | |||
46641 | 191352 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015101.55033 | 2107682.63159 | 37.7681434121179 | -122.391042763138 | (37.7681434121179, -122.391042763138) | 14 | 3 | 9 | 310 | 20 | |||
86504 | 191326 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015116.04644 | 2108440.39907 | 37.7702248795025 | -122.391045592385 | (37.7702248795025, -122.391045592385) | 14 | 3 | 9 | 310 | 20 | |||
169859 | 191327 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015115.08625 | 2108468.00525 | 37.7703006267103 | -122.391050843517 | (37.7703006267103, -122.391050843517) | 14 | 3 | 9 | 310 | 20 | |||
95406 | 191351 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1750 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015099.52293 | 2107709.56267 | 37.7682172464566 | -122.391051658332 | (37.7682172464566, -122.391051658332) | 14 | 3 | 9 | 310 | 20 | |||
49373 | 200112 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263 | -122.391053863847 | (37.726602519263, -122.391053863847) | 10 | 3 | 8 | 58 | 1 | |||
118413 | 191328 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015112.5325 | 2108491.8646 | 37.7703659975189 | -122.391061344907 | (37.7703659975189, -122.391061344907) | 14 | 3 | 9 | 310 | 20 |
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) );