trees
1,914 rows where qSpecies_id = 45 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
145711 | 200183 | DPW Maintained 1 | :: 45 | 1197 Hollister Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013828.6909 | 2090422.2008 | 37.7206791862384 | -122.394236894514 | (37.7206791862384, -122.394236894514) | 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 | |||
191663 | 200246 | DPW Maintained 1 | :: 45 | 1071 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6013781.7407 | 2090110.9877 | 37.719822047209 | -122.394377408818 | (37.719822047209, -122.394377408818) | 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 | |||
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 | |||
155612 | 200201 | DPW Maintained 1 | :: 45 | 1090 Ingerson Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 6013694.5474 | 2090234.3998 | 37.7201560648851 | -122.394687445541 | (37.7201560648851, -122.394687445541) | 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 | |||
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 | |||
191838 | 200182 | DPW Maintained 1 | :: 45 | 1175 Ingerson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6013359.1884 | 2090422.8715 | 37.7206549194654 | -122.395859877099 | (37.7206549194654, -122.395859877099) | 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 | |||
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 | ||||
59015 | 190673 | DPW Maintained 1 | :: 45 | 149 Freelon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6013287.80421 | 2111419.18552 | 37.7783023338298 | -122.397578465593 | (37.7783023338298, -122.397578465593) | 6 | 2 | 9 | 28856 | 34 | |||
47890 | 190672 | DPW Maintained 1 | :: 45 | 149 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013276.0134 | 2111408.93876 | 37.7782735420174 | -122.39761853578 | (37.7782735420174, -122.39761853578) | 6 | 2 | 9 | 28856 | 34 | |||
113485 | 190671 | DPW Maintained 1 | :: 45 | 149 Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013262.02792 | 2111394.33223 | 37.7782326570475 | -122.397665892288 | (37.7782326570475, -122.397665892288) | 6 | 2 | 9 | 28856 | 34 | |||
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 | ||||
142114 | 108771 | Undocumented 4 | :: 45 | 500X Lathrop Ave | 10 | 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 | ||||
94011 | 190670 | DPW Maintained 1 | :: 45 | 149 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6013247.06653 | 2111383.52028 | 37.7782021367646 | -122.39771689102 | (37.7782021367646, -122.39771689102) | 6 | 2 | 9 | 28856 | 34 | |||
61589 | 190669 | DPW Maintained 1 | :: 45 | 149 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6013237.11478 | 2111370.50988 | 37.7781658589921 | -122.397750405181 | (37.7781658589921, -122.397750405181) | 6 | 2 | 9 | 28856 | 34 | |||
12997 | 258944 | DPW Maintained 1 | :: 45 | 190 Freelon St | 1 | Sidewalk: Curb side : Yard | Landscaping | DPW 1 | Width 2ft | 6013228 | 2111376 | 37.7781804260272 | -122.397782321929 | (37.7781804260272, -122.397782321929) | 6 | 2 | 9 | 28856 | 34 | ||||
63806 | 190668 | DPW Maintained 1 | :: 45 | 151 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6013191.282 | 2111332.85089 | 37.7780599035854 | -122.397906316128 | (37.7780599035854, -122.397906316128) | 6 | 2 | 9 | 28856 | 34 | |||
17525 | 108731 | Undocumented 4 | :: 45 | 1822-1898X 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013006 | 2102886 | 37.7548564119513 | -122.39795458116 | (37.7548564119513, -122.39795458116) | 10 | 3 | 8 | 28856 | 29 | ||||
167802 | 190667 | DPW Maintained 1 | :: 45 | 153 Freelon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6013174.92981 | 2111315.77599 | 37.7780121091073 | -122.397961686491 | (37.7780121091073, -122.397961686491) | 6 | 2 | 9 | 28856 | 34 | |||
52401 | 190666 | DPW Maintained 1 | :: 45 | 153 Freelon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6013164.18283 | 2111305.08822 | 37.7779821643861 | -122.397998114425 | (37.7779821643861, -122.397998114425) | 6 | 2 | 9 | 28856 | 34 | |||
193887 | 190665 | DPW Maintained 1 | :: 45 | 153 Freelon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6013152.15167 | 2111293.3784 | 37.777949341814 | -122.398038913074 | (37.777949341814, -122.398038913074) | 6 | 2 | 9 | 28856 | 34 | |||
120746 | 28868 | DPW Maintained 1 | :: 45 | 75 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6013233.2298598 | 2115774.102568 | 37.7902568901803 | -122.398072854346 | (37.7902568901803, -122.398072854346) | 12 | 2 | 9 | 28855 | 6 | ||
30304 | 190664 | DPW Maintained 1 | :: 45 | 153 Freelon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6013137.75359 | 2111279.19954 | 37.7779096079765 | -122.398087726493 | (37.7779096079765, -122.398087726493) | 6 | 2 | 9 | 28856 | 34 | |||
143496 | 190656 | DPW Maintained 1 | :: 45 | 358 Arkansas St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6012906.49923 | 2105280.13182 | 37.7614246319699 | -122.398466668421 | (37.7614246319699, -122.398466668421) | 10 | 3 | 8 | 28856 | 29 | |||
20749 | 190655 | DPW Maintained 1 | :: 45 | 354 Arkansas St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | 10 | 3 | 8 | 28856 | 29 | |||
79518 | 190654 | DPW Maintained 1 | :: 45 | 330 Arkansas St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012898.89819 | 2105464.44963 | 37.7619303045744 | -122.398505891451 | (37.7619303045744, -122.398505891451) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
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 | ||
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 | ||
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 | ||
163271 | 173852 | DPW Maintained 1 | :: 45 | 450 Toland St | 7 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 8.5x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
170014 | 173846 | DPW Maintained 1 | :: 45 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
179791 | 173853 | DPW Maintained 1 | :: 45 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.7444516111373 | -122.398509629682 | (37.7444516111373, -122.398509629682) | 10 | 3 | 8 | 58 | 1 | ||
124110 | 190653 | DPW Maintained 1 | :: 45 | 320 Arkansas St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6012892.66651 | 2105479.77799 | 37.7619720457008 | -122.398528520179 | (37.7619720457008, -122.398528520179) | 10 | 3 | 8 | 28856 | 29 | |||
1289 | 190652 | DPW Maintained 1 | :: 45 | 310 Arkansas St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.398528520183 | (37.7621425904374, -122.398528520183) | 10 | 3 | 8 | 28856 | 29 | |||
253 | 200884 | DPW Maintained 1 | :: 45 | 1200 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6012817.0471 | 2107089.1245 | 37.7663867409086 | -122.39890301604 | (37.7663867409086, -122.39890301604) | 14 | 3 | 8 | 28856 | 20 | |||
375 | 115067 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
57503 | 115068 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
95951 | 115061 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
115561 | 115066 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
150847 | 115065 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
154502 | 115069 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
162453 | 115062 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
177789 | 115063 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
182182 | 115064 | DPW Maintained 1 | :: 45 | 70 Coral Rd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.399069018455 | (37.7538392609312, -122.399069018455) | 10 | 3 | 8 | 28856 | 29 | |||||
139687 | 51853 | DPW Maintained 1 | :: 45 | 1639 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2005 12:00:00 AM | 8 | Permit Number 48077 | 6012728.89469 | 2105155.76009 | 37.7610732389628 | -122.39907220262 | (37.7610732389628, -122.39907220262) | 10 | 3 | 8 | 28856 | 29 | ||
5962 | 190650 | DPW Maintained 1 | :: 45 | 501 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012697.31498 | 2105105.25182 | 37.7609327945277 | -122.399177878376 | (37.7609327945277, -122.399177878376) | 10 | 3 | 8 | 28856 | 29 | |||
80878 | 190651 | DPW Maintained 1 | :: 45 | 501 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012696.96101 | 2105116.13755 | 37.760962664614 | -122.399179866755 | (37.760962664614, -122.399179866755) | 10 | 3 | 8 | 28856 | 29 | |||
8301 | 114726 | Significant Tree 6 | :: 45 | 520 Townsend St | 2 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
110899 | 114725 | Significant Tree 6 | :: 45 | 520 Townsend St | 1 | Front Yard : Yard | Tree | Private 2 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.400146236912 | (37.7731959986981, -122.400146236912) | 14 | 2 | 9 | 28853 | 34 | |||||
26337 | 201234 | DPW Maintained 1 | :: 45 | 795 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6012343.1682 | 2112809.9895 | 37.7820685155731 | -122.400944074647 | (37.7820685155731, -122.400944074647) | 6 | 2 | 9 | 28856 | 34 | |||
119424 | 199648 | DPW Maintained 1 | :: 45 | 420 05th St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | Width 3ft | 6012151.63129 | 2111560.33 | 37.7786265538123 | -122.401518854125 | (37.7786265538123, -122.401518854125) | 14 | 2 | 9 | 28856 | 34 | |||
152782 | 104960 | Permitted Site 7 | :: 45 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | 10 | 3 | 7 | 309 | 28 | ||||||
7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
7054 | 259630 | DPW Maintained 1 | :: 45 | 25 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011219.86081 | 2087480.59399 | 37.7124567737707 | -122.403048058633 | (37.7124567737707, -122.403048058633) | 9 | 7 | 8 | 309 | 39 | ||
8942 | 259632 | DPW Maintained 1 | :: 45 | 31 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011179.21594 | 2087501.52553 | 37.7125119777417 | -122.40319001201 | (37.7125119777417, -122.40319001201) | 9 | 7 | 8 | 309 | 39 | ||
17095 | 259633 | DPW Maintained 1 | :: 45 | 37 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011138.57107 | 2087522.45708 | 37.7125671815686 | -122.403331965599 | (37.7125671815686, -122.403331965599) | 9 | 7 | 8 | 309 | 39 | ||
52669 | 254715 | Permitted Site 7 | :: 45 | 636 Vermont St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 5x5.5 | 6011227.55095 | 2105388.49702 | 37.7616285037909 | -122.404281111091 | (37.7616285037909, -122.404281111091) | 10 | 3 | 8 | 28856 | 29 | ||
93333 | 254714 | Permitted Site 7 | :: 45 | 636 Vermont St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 03/20/2018 12:00:00 AM | 3 | 10x5.5 | 6011227.55095 | 2105388.49702 | 37.7616285037909 | -122.404281111091 | (37.7616285037909, -122.404281111091) | 10 | 3 | 8 | 28856 | 29 | ||
2626 | 259634 | DPW Maintained 1 | :: 45 | 83 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010826.96041 | 2087682.93228 | 37.7129904051639 | -122.404420283412 | (37.7129904051639, -122.404420283412) | 9 | 7 | 8 | 309 | 39 | ||
7294 | 259631 | DPW Maintained 1 | :: 45 | 86 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010819.87099 | 2087731.57587 | 37.7131235744523 | -122.404448208813 | (37.7131235744523, -122.404448208813) | 9 | 7 | 8 | 309 | 39 | ||
141371 | 129087 | DPW Maintained 1 | :: 45 | 190 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.8039469885131 | -122.404613298068 | (37.8039469885131, -122.404613298068) | 3 | 1 | 10 | 28860 | 6 | |||
134703 | 129088 | DPW Maintained 1 | :: 45 | 190 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011425.38411 | 2120792.86026 | 37.8039363297663 | -122.40468136238 | (37.8039363297663, -122.40468136238) | 3 | 1 | 10 | 28860 | 6 | |||
519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
46922 | 129089 | DPW Maintained 1 | :: 45 | 190 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.404748812406 | (37.8039285776094, -122.404748812406) | 3 | 1 | 10 | 28860 | 6 | |||
52218 | 129090 | DPW Maintained 1 | :: 45 | 190 Lombard St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6011386.68599 | 2120789.41334 | 37.8039247024384 | -122.404815037597 | (37.8039247024384, -122.404815037597) | 3 | 1 | 10 | 28860 | 6 | |||
6014 | 38201 | Permitted Site 7 | :: 45 | 254X Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40328 | 6010721.34684579 | 2091489.60477168 | 37.7234368466837 | -122.405053190481 | (37.7234368466837, -122.405053190481) | 10 | 3 | 7 | 309 | 28 | ||
3194 | 259639 | DPW Maintained 1 | :: 45 | 122 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010584.82353 | 2087852.62198 | 37.7134428042481 | -122.405269135112 | (37.7134428042481, -122.405269135112) | 9 | 7 | 8 | 309 | 39 | ||
29308 | 190674 | DPW Maintained 1 | :: 45 | 446 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010985.96747 | 2112156.82627 | 37.7801992828204 | -122.405593378352 | (37.7801992828204, -122.405593378352) | 14 | 2 | 9 | 28853 | 34 | |||
380 | 116339 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
22185 | 116323 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
25187 | 116322 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
54626 | 116326 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
65073 | 116329 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
75200 | 116321 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
78264 | 116333 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
81688 | 116324 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
86004 | 116328 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
93156 | 116332 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
110493 | 116335 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
114488 | 116330 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
121272 | 116338 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
127977 | 116334 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
148464 | 116325 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
159926 | 116331 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
162458 | 116327 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
172528 | 116337 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
181190 | 116336 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
22609 | 116318 | Undocumented 4 | :: 45 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010547.7 | 2101110.8 | 37.74984488673 | -122.406331036849 | (37.74984488673, -122.406331036849) | 10 | 4 | 7 | 28859 | 19 | |||||
77594 | 116320 | Undocumented 4 | :: 45 | 1451 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010547.7 | 2101110.8 | 37.74984488673 | -122.406331036849 | (37.74984488673, -122.406331036849) | 10 | 4 | 7 | 28859 | 19 | |||||
106263 | 116319 | Undocumented 4 | :: 45 | 1451 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010547.7 | 2101110.8 | 37.74984488673 | -122.406331036849 | (37.74984488673, -122.406331036849) | 10 | 4 | 7 | 28859 | 19 | |||||
28267 | 142762 | DPW Maintained 1 | :: 45 | 400 FILBERT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6010787.7026 | 2120010.8966 | 37.8017535888682 | -122.40683296647 | (37.8017535888682, -122.40683296647) | 3 | 1 | 10 | 308 | 23 |
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) );