trees
861 rows where qSpecies_id = 18 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11866 | 171812 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 825 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6008354.35996 | 2093563.17483 | 37.7289978245749 | -122.413382030664 | (37.7289978245749, -122.413382030664) | 9 | 3 | 7 | 309 | 28 | ||
16942 | 171730 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007892.79548 | 2093379.38085 | 37.7284672398478 | -122.414964695362 | (37.7284672398478, -122.414964695362) | 9 | 3 | 7 | 309 | 5 | ||
18180 | 172292 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1016 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6001343.2172 | 2086829.28712 | 37.7101119374834 | -122.437138099169 | (37.7101119374834, -122.437138099169) | 9 | 7 | 6 | 28861 | 5 | |||
60743 | 37092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1422 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39692 | 5981562.80857566 | 2105390.4854708 | 37.7599316756927 | -122.506877772277 | (37.7599316756927, -122.506877772277) | 1 | 8 | 3 | 56 | 35 | |
62659 | 31774 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 0 | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | |
2631 | 176979 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002427.23589 | 2086817.03836 | 37.7101398650242 | -122.433390645786 | (37.7101398650242, -122.433390645786) | 9 | 7 | 6 | 28861 | 5 | |||
4788 | 71255 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6007494.44606 | 2117816.87319 | 37.7955445300156 | -122.418073553678 | (37.7955445300156, -122.418073553678) | 5 | 1 | 10 | 28858 | 32 | |||
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 | |||
21941 | 176974 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 15 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009262.49228 | 2094178.39386 | 37.7307380316287 | -122.410285956242 | (37.7307380316287, -122.410285956242) | 9 | 3 | 7 | 309 | 28 | |||
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 | |||
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 | |||
33411 | 227589 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 23 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006036.6609 | 2100222.07218 | 37.7471512660344 | -122.42186731675 | (37.7471512660344, -122.42186731675) | 2 | 7 | 5 | 28859 | 22 | |||
39314 | 117939 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 6300 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5983833.68211 | 2109720.90427 | 37.7719552435785 | -122.499344054001 | (37.7719552435785, -122.499344054001) | 11 | 6 | 2 | 55 | 26 | |||
44144 | 207062 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993034.65386 | 2099189.08337 | 37.7435731145127 | -122.466751760605 | (37.7435731145127, -122.466751760605) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |
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 | |
49177 | 176922 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 298 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003957.47292 | 2089506.69936 | 37.7176117887305 | -122.428293410708 | (37.7176117887305, -122.428293410708) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
50537 | 200113 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1566 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014774.445 | 2092572.7944 | 37.7266368132033 | -122.391117932915 | (37.7266368132033, -122.391117932915) | 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 | |||
55623 | 120374 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 433 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5988073.52579 | 2113031.79545 | 37.7812938539051 | -122.484921243675 | (37.7812938539051, -122.484921243675) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
57522 | 119342 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 450 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5985959.22989 | 2112860.79415 | 37.7807009596808 | -122.492222971302 | (37.7807009596808, -122.492222971302) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
60579 | 79264 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.478535346694 | (37.7845600440954, -122.478535346694) | 11 | 6 | 2 | 55 | 26 | |||
61523 | 176925 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 17 Curtis St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000534.5551 | 2088493.30994 | 37.7146349724878 | -122.440052229032 | (37.7146349724878, -122.440052229032) | 9 | 7 | 6 | 28861 | 5 | |||
62830 | 129391 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1851 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004117.78483 | 2119036.12679 | 37.7987016585207 | -122.429844394124 | (37.7987016585207, -122.429844394124) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
71950 | 176972 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 161 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 781886 | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.414559571484 | (37.7278844827614, -122.414559571484) | 9 | 3 | 7 | 309 | 28 | ||
81506 | 227602 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 54 | Front Yard : Yard | Tree | Private 2 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657888 | -122.426906353066 | (37.735757657888, -122.426906353066) | 2 | 7 | 5 | 28861 | 2 | ||||
88386 | 54664 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.97577 | 2086866.66481 | 37.7108286845682 | -122.399434200424 | (37.7108286845682, -122.399434200424) | 10 | 3 | 8 | 309 | 1 | ||
95418 | 129396 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3570 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5997759.42615 | 2115150.05593 | 37.7876694312425 | -122.451565786028 | (37.7876694312425, -122.451565786028) | 11 | 6 | 1 | 54 | 31 | |||
97739 | 31728 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) | 1 | 8 | 3 | 29491 | 35 |
101763 | 176923 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 298 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003940.88243 | 2089479.82592 | 37.7175370613599 | -122.428348842222 | (37.7175370613599, -122.428348842222) | 9 | 7 | 6 | 28861 | 5 | |||
108905 | 176966 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 327 Craut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 7ft | 6004069.61366 | 2093704.49695 | 37.7291443592041 | -122.428204791543 | (37.7291443592041, -122.428204791543) | 9 | 7 | 6 | 28861 | 5 | |||
108940 | 176977 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002472.36908 | 2086850.07188 | 37.7102331283354 | -122.433237015483 | (37.7102331283354, -122.433237015483) | 9 | 7 | 6 | 28861 | 5 | |||
111235 | 107371 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 448 BROADWAY | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011394.4 | 2118786.8 | 37.798426445485 | -122.404647279275 | (37.798426445485, -122.404647279275) | 3 | 1 | 10 | 308 | 23 | ||||
114745 | 31727 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2460 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990175.918 | 2098661.7302 | 37.7419597410001 | -122.476597940821 | (37.7419597410001, -122.476597940821) | 1 | 8 | 3 | 29491 | 35 |
117025 | 187130 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2600 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985156.874 | 2097417.7557 | 37.7382517335963 | -122.493860275789 | (37.7382517335963, -122.493860275789) | 1 | 8 | 3 | 29491 | 35 | |||
117085 | 207065 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993024.95059 | 2099189.67414 | 37.7435741766159 | -122.466785354773 | (37.7435741766159, -122.466785354773) | 1 | 8 | 4 | 29491 | 40 | |||
129111 | 176978 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002453.71663 | 2086834.19677 | 37.7101884805901 | -122.433300348445 | (37.7101884805901, -122.433300348445) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
131892 | 182931 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2639 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982106.6394 | 2097122.6843 | 37.7372626147396 | -122.504384447307 | (37.7372626147396, -122.504384447307) | 1 | 8 | 3 | 29491 | 35 | |||
142817 | 176924 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 525 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002840.55904 | 2090695.62 | 37.7208130388822 | -122.432238933478 | (37.7208130388822, -122.432238933478) | 9 | 7 | 6 | 28861 | 5 | |||
144313 | 98154 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 466 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | Permit Number 768787 | 5991271.26635 | 2112266.29774 | 37.7793777410264 | -122.473802878969 | (37.7793777410264, -122.473802878969) | 11 | 6 | 2 | 54 | 26 | ||
151952 | 124124 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 61 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5996360.44357 | 2112557.14678 | 37.7804697796635 | -122.456218418366 | (37.7804697796635, -122.456218418366) | 11 | 6 | 2 | 54 | 16 | |||
152991 | 207061 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993037.74509 | 2099188.24411 | 37.7435709885186 | -122.466741010989 | (37.7435709885186, -122.466741010989) | 1 | 8 | 4 | 29491 | 40 | |||
154490 | 227620 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005907.97007 | 2102264.49014 | 37.7527520189138 | -122.422457421298 | (37.7527520189138, -122.422457421298) | 2 | 4 | 5 | 28859 | 19 | |||
156291 | 119541 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 823 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5986627.47166 | 2110288.51699 | 37.773677258601 | -122.489722009434 | (37.773677258601, -122.489722009434) | 11 | 6 | 2 | 55 | 26 | |||
159205 | 207064 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993028.04996 | 2099189.22218 | 37.7435731145222 | -122.466774605159 | (37.7435731145222, -122.466774605159) | 1 | 8 | 4 | 29491 | 40 | |||
163532 | 48667 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3362 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2012 12:00:00 AM | 1 | Permit Number 768676 | 5998753.52645 | 2115612.95888 | 37.7889973189237 | -122.448159750376 | (37.7889973189237, -122.448159750376) | 13 | 6 | 1 | 54 | 31 | ||
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 | |||
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 | |
178429 | 207051 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992092.81688 | 2106815.43538 | 37.764458690039 | -122.470563705269 | (37.764458690039, -122.470563705269) | 11 | 8 | 11 | 56 | 12 | |||
182318 | 207068 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 539 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991225.79939 | 2097692.69128 | 37.7393598464762 | -122.472897178881 | (37.7393598464762, -122.472897178881) | 1 | 8 | 4 | 29491 | 40 | |||
183807 | 102256 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1933 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2013 12:00:00 AM | 1 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.7876549629941 | -122.440900572101 | (37.7876549629941, -122.440900572101) | 13 | 6 | 1 | 29490 | 27 | |
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 | |||
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 | |||
187695 | 49756 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.7176031885257 | -122.402648943989 | (37.7176031885257, -122.402648943989) | 10 | 7 | 8 | 309 | 39 | |
189467 | 176976 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6002487.99329 | 2086859.86644 | 37.7102609083974 | -122.433183714473 | (37.7102609083974, -122.433183714473) | 9 | 7 | 6 | 28861 | 5 | |||
31088 | 142250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | 7 | 9 | 11 | 28852 | 10 | |||
31849 | 129400 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3766 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5996779.47393 | 2115339.45033 | 37.7881332907605 | -122.454969901653 | (37.7881332907605, -122.454969901653) | 11 | 6 | 1 | 54 | 31 | |||
32742 | 227643 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3801 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002989.53011 | 2103560.80368 | 37.7561463193257 | -122.432642495251 | (37.7561463193257, -122.432642495251) | 2 | 4 | 5 | 28862 | 22 | |||
43158 | 227617 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6009080.60999 | 2097991.13845 | 37.7411968070922 | -122.411183978775 | (37.7411968070922, -122.411183978775) | 10 | 7 | 7 | 28859 | 2 | |||
58845 | 46819 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 366 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 10 | Permit Number 44897 | 6004049.02082 | 2091179.47735 | 37.7222100502291 | -122.428096112963 | (37.7222100502291, -122.428096112963) | 9 | 7 | 6 | 28861 | 5 | |
68049 | 129448 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008230.44958 | 2115909.44994 | 37.7903486123517 | -122.415391745646 | (37.7903486123517, -122.415391745646) | 5 | 1 | 10 | 28858 | 21 | |||
69978 | 227648 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999992.54639 | 2104934.00184 | 37.7597463657249 | -122.443105663906 | (37.7597463657249, -122.443105663906) | 2 | 4 | 5 | 28862 | 3 | |||
71092 | 250533 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 69 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5987683.92995 | 2115503.12844 | 37.7880567296852 | -122.486450536786 | (37.7880567296852, -122.486450536786) | 11 | 6 | 1 | 55 | 33 | |||
76983 | 207075 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5994498.16233 | 2100407.05536 | 37.7470017132656 | -122.461779641027 | (37.7470017132656, -122.461779641027) | 1 | 8 | 4 | 29491 | 40 | |||
79840 | 207070 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.7523110111603 | -122.464510933358 | (37.7523110111603, -122.464510933358) | 1 | 8 | 4 | 29491 | 12 | |||
80856 | 97675 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000810.80569 | 2117928.44871 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | 13 | 9 | 1 | 57 | 17 | ||||
84073 | 191265 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2100 Thomas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012134.75084 | 2095927.24781 | 37.7357006075903 | -122.400478845738 | (37.7357006075903, -122.400478845738) | 10 | 3 | 8 | 58 | 1 | ||||
102554 | 227658 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 111 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001589.01566 | 2106181.9491 | 37.7632638228943 | -122.437673651738 | (37.7632638228943, -122.437673651738) | 15 | 5 | 5 | 28862 | 3 | |||
106621 | 244199 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 697 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003772.3734 | 2110028.492 | 37.7739493963127 | -122.430396601984 | (37.7739493963127, -122.430396601984) | 7 | 9 | 11 | 29492 | 10 | |||
175891 | 176939 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 8 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6012245.82216 | 2087941.31791 | 37.7137790697309 | -122.399534325569 | (37.7137790697309, -122.399534325569) | 10 | 3 | 8 | 309 | 1 | |||
177495 | 42710 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) | 13 | 9 | 1 | 57 | 17 |
30144 | 129421 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2129 Vallejo St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003307.9218 | 2117884.58152 | 37.795493917972 | -122.43256447999 | (37.795493917972, -122.43256447999) | 13 | 9 | 1 | 29490 | 27 | |||
49165 | 227649 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999999.59495 | 2104920.93401 | 37.7597108865789 | -122.443080347989 | (37.7597108865789, -122.443080347989) | 2 | 4 | 5 | 28862 | 3 | |||
62495 | 129399 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3766 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5996788.91292 | 2115340.40834 | 37.7881364626726 | -122.454937313809 | (37.7881364626726, -122.454937313809) | 11 | 6 | 1 | 54 | 31 | |||
112608 | 129394 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3700 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5997109.18462 | 2115060.18716 | 37.7873854172521 | -122.453808991111 | (37.7873854172521, -122.453808991111) | 11 | 6 | 1 | 54 | 31 | |||
114585 | 207071 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5993749.48127 | 2102344.6615 | 37.7522787587656 | -122.464509159894 | (37.7522787587656, -122.464509159894) | 1 | 8 | 4 | 29491 | 12 | |||
119638 | 129403 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2844 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000067.16914 | 2118384.00921 | 37.7966809025571 | -122.443813899808 | (37.7966809025571, -122.443813899808) | 13 | 9 | 1 | 57 | 17 | |||
138941 | 207095 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1565 Plymouth Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995634.15192 | 2094407.35941 | 37.7305933513933 | -122.457417521726 | (37.7305933513933, -122.457417521726) | 9 | 7 | 4 | 28861 | 40 | |||
140567 | 250532 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.7879977845133 | -122.486444423174 | (37.7879977845133, -122.486444423174) | 11 | 6 | 1 | 55 | 33 | |||
142096 | 57397 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1190 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/1976 12:00:00 AM | 11 | Permit Number 16237 | 6008290.06558 | 2115917.44184 | 37.7903739066804 | -122.415186043726 | (37.7903739066804, -122.415186043726) | 5 | 1 | 10 | 28858 | 21 | ||
147547 | 129462 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 584 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011873.80865 | 2117764.68671 | 37.7956467505394 | -122.402916441935 | (37.7956467505394, -122.402916441935) | 3 | 1 | 10 | 28860 | 4 | |||
152484 | 141665 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5 MASONIC AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998794.5569 | 2112395.1526 | 37.7801644097761 | -122.447786043539 | (37.7801644097761, -122.447786043539) | 15 | 6 | 2 | 54 | 16 | |||
162130 | 129409 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2199 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003265.25593 | 2116107.39334 | 37.7906117953446 | -122.432585105024 | (37.7906117953446, -122.432585105024) | 13 | 9 | 1 | 29490 | 27 | |||
171588 | 176940 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 15 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012273.46712 | 2087900.15525 | 37.7136675861685 | -122.399435885762 | (37.7136675861685, -122.399435885762) | 10 | 3 | 8 | 309 | 1 | |||
182404 | 176938 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 10 Lois Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012264.96042 | 2087928.82829 | 37.7137458424772 | -122.399467299971 | (37.7137458424772, -122.399467299971) | 10 | 3 | 8 | 309 | 1 | |||
697 | 19206 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.401698594427 | (37.7962500076802, -122.401698594427) | 3 | 1 | 10 | 28860 | 4 | |||
44766 | 227650 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 154 Danvers St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000006.33119 | 2104908.86672 | 37.759678136856 | -122.443056184107 | (37.759678136856, -122.443056184107) | 2 | 4 | 5 | 28862 | 3 | |||
48527 | 4552 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004747.7557 | 2113637.7514 | 37.7839147367985 | -122.427279741881 | (37.7839147367985, -122.427279741881) | 7 | 9 | 11 | 28858 | 41 | |||
99134 | 4519 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20X Cleary Ct | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2015 11:31:00 AM | 12 | 3x3 | 6004999.51904 | 2113885.82273 | 37.7846101140023 | -122.426426402111 | (37.7846101140023, -122.426426402111) | 13 | 9 | 11 | 28858 | 41 | ||
108133 | 4549 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004652.295 | 2113623.5507 | 37.7838703460943 | -122.427608988739 | (37.7838703460943, -122.427608988739) | 7 | 9 | 11 | 28858 | 41 | |||
109016 | 176962 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 121 Saint Charles Ave | 1 | : | Tree | Private 2 | 12 | Width 2ft | 5992069.06615 | 2087619.04288 | 37.7117488798662 | -122.469248551103 | (37.7117488798662, -122.469248551103) | 9 | 8 | 4 | 64 | 24 | |||
126007 | 246778 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 392 Franconia St | 2 | Back Yard : Yard | Tree | Private 2 | 12 | 6009934.46977 | 2098852.71045 | 37.7436103455484 | -122.408292376913 | (37.7436103455484, -122.408292376913) | 2 | 7 | 7 | 28859 | 2 | ||||
154682 | 4547 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
160781 | 4550 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 85 Cleary Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004735.0847094 | 2113637.0202701 | 37.7839120126984 | -122.427323526754 | (37.7839120126984, -122.427323526754) | 7 | 9 | 11 | 28858 | 41 | |||
162732 | 227645 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3801 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003027.84051 | 2103561.52563 | 37.7561504741859 | -122.432510056589 | (37.7561504741859, -122.432510056589) | 2 | 4 | 5 | 28862 | 22 |
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) );