trees
6,344 rows where qSpecies_id = 19 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
45060 | 208801 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 137 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5995021.74447 | 2099547.88233 | 37.7446727659429 | -122.45990692429 | (37.7446727659429, -122.45990692429) | 1 | 8 | 4 | 59 | 40 | |||
45227 | 208765 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 535 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994377.5896 | 2099629.65996 | 37.7448602395261 | -122.462140199005 | (37.7448602395261, -122.462140199005) | 1 | 8 | 4 | 59 | 40 | |||
45472 | 208581 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1351 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992996.52293 | 2106268.10134 | 37.7630080691786 | -122.467398258042 | (37.7630080691786, -122.467398258042) | 1 | 8 | 11 | 56 | 12 | |||
47042 | 208567 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1755 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993399.76288 | 2103554.94969 | 37.755581732124 | -122.465806459796 | (37.755581732124, -122.465806459796) | 1 | 8 | 4 | 56 | 12 | |||
48414 | 208712 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1534 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993396.26768 | 2105022.69523 | 37.759611578939 | -122.465925191009 | (37.759611578939, -122.465925191009) | 1 | 8 | 4 | 56 | 12 | |||
49690 | 208582 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 642 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992508.00443 | 2105963.74701 | 37.7621441777339 | -122.469065709928 | (37.7621441777339, -122.469065709928) | 1 | 8 | 11 | 56 | 12 | |||
50613 | 208590 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1640 09th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | Width 6ft | 5993420.78428 | 2104324.22806 | 37.7576951839151 | -122.465789652393 | (37.7576951839151, -122.465789652393) | 1 | 8 | 4 | 56 | 12 | |||
50615 | 181635 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1270 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5987414.7008 | 2106665.1807 | 37.7637745152387 | -122.486732781194 | (37.7637745152387, -122.486732781194) | 1 | 8 | 3 | 56 | 35 | |||
50683 | 183533 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2566 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986786.1395 | 2097806.4563 | 37.7394141923039 | -122.488255712003 | (37.7394141923039, -122.488255712003) | 1 | 8 | 3 | 29491 | 35 | |||
52029 | 183261 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1231 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983023.9383 | 2106705.6545 | 37.7636286930826 | -122.501921829451 | (37.7636286930826, -122.501921829451) | 1 | 8 | 3 | 56 | 35 | |||
52353 | 181759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1237 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5987359.78 | 2106829.3525 | 37.7642220838277 | -122.486934790173 | (37.7642220838277, -122.486934790173) | 1 | 8 | 3 | 56 | 35 | |||
54199 | 183975 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1671 33rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985913.431 | 2103861.5743 | 37.7559889519314 | -122.491718740265 | (37.7559889519314, -122.491718740265) | 1 | 8 | 3 | 56 | 35 | |||
56796 | 182074 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2475 30th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5987032.0303 | 2098348.6173 | 37.7409171658639 | -122.487445355915 | (37.7409171658639, -122.487445355915) | 1 | 8 | 3 | 29491 | 35 | |||
56909 | 48652 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 439 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45945 | 5992980.71663157 | 2103877.73673829 | 37.7564438402713 | -122.467279109483 | (37.7564438402713, -122.467279109483) | 1 | 8 | 4 | 56 | 12 | ||
57501 | 63002 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1247 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1986 12:00:00 AM | 2 | Permit Number 23410 | 5983025.611 | 2106604.4545 | 37.7633509249525 | -122.501908555809 | (37.7633509249525, -122.501908555809) | 1 | 8 | 3 | 56 | 35 | ||
57564 | 208766 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 158 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994489.71371 | 2098586.72475 | 37.7420030555916 | -122.461676894383 | (37.7420030555916, -122.461676894383) | 1 | 8 | 4 | 59 | 40 | |||
58167 | 57914 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1220 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1977 12:00:00 AM | 7 | Permit Number 16872 | 5987404.6616 | 2106925.021 | 37.7644873798395 | -122.486786585217 | (37.7644873798395, -122.486786585217) | 1 | 8 | 3 | 56 | 35 | ||
58176 | 96706 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2012 12:00:00 AM | 1 | Permit Number 767523 | 5987020.524 | 2098284.6556 | 37.7407408729421 | -122.487480442554 | (37.7407408729421, -122.487480442554) | 1 | 8 | 3 | 29491 | 35 | ||
58205 | 208793 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 533 Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993295.58857 | 2101841.19386 | 37.7508701902074 | -122.466042198205 | (37.7508701902074, -122.466042198205) | 1 | 8 | 4 | 29491 | 40 | |||
60115 | 66213 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1219 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1990 12:00:00 AM | 8 | Permit Number 29303 | 5987358.0084 | 2106931.2218 | 37.764501685545 | -122.486948399206 | (37.764501685545, -122.486948399206) | 1 | 8 | 3 | 56 | 35 | ||
60152 | 208620 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 92 Allston Way | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 4ft | 5993943.80464 | 2098648.69817 | 37.7421417796248 | -122.463568955568 | (37.7421417796248, -122.463568955568) | 1 | 8 | 4 | 59 | 40 | |||
60501 | 181760 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1237 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5987360.3706 | 2106812.2267 | 37.7641750955359 | -122.486931489711 | (37.7641750955359, -122.486931489711) | 1 | 8 | 3 | 56 | 35 | |||
60883 | 208713 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1567 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992732.0613 | 2104802.32099 | 37.7589681499891 | -122.468206297105 | (37.7589681499891, -122.468206297105) | 1 | 8 | 4 | 56 | 12 | |||
61222 | 32577 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1210 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | Permit Number 37051 | 5985854.7017594 | 2106979.63157411 | 37.7645468410485 | -122.492151418239 | (37.7645468410485, -122.492151418239) | 1 | 8 | 3 | 56 | 35 | ||
61268 | 208774 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 255 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5994711.51875 | 2100331.22288 | 37.7468057761659 | -122.461036382847 | (37.7468057761659, -122.461036382847) | 1 | 8 | 4 | 29491 | 40 | |||
61439 | 183791 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1958 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986749.6745 | 2099634.9626 | 37.7444326563944 | -122.488516143529 | (37.7444326563944, -122.488516143529) | 1 | 8 | 3 | 29491 | 35 | |||
61442 | 208750 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1525 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991320.33273 | 2098374.54305 | 37.7412375095 | -122.47262002761 | (37.7412375095, -122.47262002761) | 1 | 8 | 4 | 29491 | 40 | |||
61656 | 208787 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5995158.52081 | 2100367.97831 | 37.7469324097188 | -122.459493364749 | (37.7469324097188, -122.459493364749) | 1 | 8 | 4 | 59 | 40 | |||
61930 | 208556 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1686 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990918.75358 | 2103929.79313 | 37.7564675256785 | -122.474413830646 | (37.7564675256785, -122.474413830646) | 1 | 8 | 4 | 56 | 12 | |||
62441 | 181734 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1201 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5987046.7905 | 2107030.1383 | 37.7647551325776 | -122.488032071645 | (37.7647551325776, -122.488032071645) | 1 | 8 | 3 | 56 | 35 | |||
63207 | 121472 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1290 20th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778435 | 5989898.73155 | 2106592.32318 | 37.7637189695993 | -122.47813604713 | (37.7637189695993, -122.47813604713) | 1 | 8 | 3 | 56 | 35 | |
63544 | 208557 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1747 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5990891.03189 | 2103495.92611 | 37.7552746352232 | -122.474478039553 | (37.7552746352232, -122.474478039553) | 1 | 8 | 4 | 56 | 12 | |||
64016 | 208727 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1734 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993134.15705 | 2103651.21226 | 37.7558307193321 | -122.466731997098 | (37.7558307193321, -122.466731997098) | 1 | 8 | 4 | 56 | 12 | |||
64106 | 182020 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1524 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5990092.4753 | 2105192.0185 | 37.7598853531984 | -122.477363607822 | (37.7598853531984, -122.477363607822) | 1 | 8 | 3 | 56 | 35 | |||
65576 | 33160 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2447 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 3 | Permit Number 37383 | 5985473.2595 | 2098547.6093 | 37.7413725147529 | -122.492849584664 | (37.7413725147529, -122.492849584664) | 1 | 8 | 3 | 29491 | 35 | |
66127 | 208777 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 251 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5994781.70078 | 2100398.24114 | 37.7469938298005 | -122.460798558016 | (37.7469938298005, -122.460798558016) | 1 | 8 | 4 | 29491 | 40 | |||
66157 | 208555 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1576 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990586.30747 | 2104659.38849 | 37.7584515344232 | -122.475616807879 | (37.7584515344232, -122.475616807879) | 1 | 8 | 4 | 56 | 12 | |||
66661 | 208707 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1470 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994002.6314 | 2105501.42707 | 37.7609610134521 | -122.463862847713 | (37.7609610134521, -122.463862847713) | 1 | 5 | 11 | 56 | 12 | |||
67161 | 42261 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1542 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42502 | 5988102.05398446 | 2104801.73189041 | 37.7586980402596 | -122.484218796814 | (37.7586980402596, -122.484218796814) | 1 | 8 | 3 | 56 | 35 | |||
67241 | 21204 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2392X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984971.1169577 | 2098921.2732344 | 37.7423691180201 | -122.494613333405 | (37.7423691180201, -122.494613333405) | 1 | 8 | 3 | 29491 | 35 | |||
67424 | 94559 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1652 12th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53733 | 5992517.8 | 2104198.3 | 37.7572972894341 | -122.468903351171 | (37.7572972894341, -122.468903351171) | 1 | 8 | 4 | 56 | 12 | ||
67596 | 45044 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2250 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2001 12:00:00 AM | 2 | Permit Number 43930 | 5988571.6344 | 2100007.292 | 37.7455611190105 | -122.482243530889 | (37.7455611190105, -122.482243530889) | 1 | 8 | 3 | 29491 | 35 | |
67967 | 50251 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1590 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48647 | 5984388.5406 | 2104356.2375 | 37.7572579198882 | -122.497028745879 | (37.7572579198882, -122.497028745879) | 1 | 8 | 3 | 56 | 35 | |
68913 | 208740 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 204 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994237.60015 | 2105335.41039 | 37.7605187124797 | -122.463038154099 | (37.7605187124797, -122.463038154099) | 1 | 5 | 11 | 56 | 12 | |||
68975 | 208614 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2374 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5992350.14389 | 2099307.24039 | 37.743858015244 | -122.469127203767 | (37.743858015244, -122.469127203767) | 1 | 8 | 4 | 29491 | 40 | |||
72337 | 208725 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1762 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993140.00173 | 2103474.29012 | 37.7553452742661 | -122.466698924518 | (37.7553452742661, -122.466698924518) | 1 | 8 | 4 | 56 | 12 | |||
73523 | 208715 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1652 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992499.49084 | 2104185.21716 | 37.7572603095413 | -122.468965718792 | (37.7572603095413, -122.468965718792) | 1 | 8 | 4 | 56 | 12 | |||
74124 | 38021 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 241 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | Permit Number 40232 | 5994108.75272839 | 2098793.54177236 | 37.7425489865914 | -122.463009127636 | (37.7425489865914, -122.463009127636) | 1 | 8 | 4 | 59 | 40 | ||
74747 | 208728 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1728 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993134.19402 | 2103672.74189 | 37.7558898362498 | -122.466733434199 | (37.7558898362498, -122.466733434199) | 1 | 8 | 4 | 56 | 12 | |||
75497 | 208767 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 158 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994476.69928 | 2098601.56198 | 37.7420430457592 | -122.461722969341 | (37.7420430457592, -122.461722969341) | 1 | 8 | 4 | 59 | 40 | |||
76104 | 183797 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2350 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985521.5211 | 2099591.0086 | 37.7442402304398 | -122.492759546804 | (37.7442402304398, -122.492759546804) | 1 | 8 | 3 | 29491 | 35 | |||
78593 | 183308 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1278 42nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5983073.9761 | 2106448.9537 | 37.7629268049938 | -122.501729774074 | (37.7629268049938, -122.501729774074) | 1 | 8 | 3 | 56 | 35 | |||
79107 | 217759 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 450 West Portal Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5991746.21396 | 2096519.68706 | 37.736169188563 | -122.471012402224 | (37.736169188563, -122.471012402224) | 1 | 8 | 4 | 29491 | 40 | |||
79113 | 208599 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 130 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993571.59524 | 2102592.39719 | 37.7529487213139 | -122.4651423051 | (37.7529487213139, -122.4651423051) | 1 | 8 | 4 | 56 | 12 | |||
79474 | 182434 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1551 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985575.3942 | 2104648.4714 | 37.7581297919874 | -122.492945727305 | (37.7581297919874, -122.492945727305) | 1 | 8 | 3 | 56 | 35 | |||
79895 | 208794 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 436 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5993867.27079 | 2101779.82504 | 37.750734651583 | -122.464060828955 | (37.750734651583, -122.464060828955) | 1 | 8 | 4 | 29491 | 40 | |||
80416 | 208788 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 461 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994885.80536 | 2100108.76207 | 37.7462049822866 | -122.460417604297 | (37.7462049822866, -122.460417604297) | 1 | 8 | 4 | 59 | 40 | |||
80638 | 33161 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2447 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 2 | Permit Number 37383 | 5985473.9364 | 2098563.1767 | 37.7414152982347 | -122.492848390582 | (37.7414152982347, -122.492848390582) | 1 | 8 | 3 | 29491 | 35 | |
81269 | 92468 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1845 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52852 | 5989172.6992 | 2101704.2547 | 37.7502554745195 | -122.480289347613 | (37.7502554745195, -122.480289347613) | 1 | 8 | 3 | 29491 | 35 |
81433 | 208565 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1839 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993732.59042 | 2102966.83719 | 37.7539861198715 | -122.464612744679 | (37.7539861198715, -122.464612744679) | 1 | 8 | 4 | 56 | 12 | |||
81867 | 208710 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 240 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5993461.47758 | 2104633.29687 | 37.7585461539006 | -122.465671373542 | (37.7585461539006, -122.465671373542) | 1 | 8 | 4 | 56 | 12 | |||
82421 | 181903 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2375 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987314.6125 | 2099133.079 | 37.7430875657834 | -122.486525887287 | (37.7430875657834, -122.486525887287) | 1 | 8 | 3 | 29491 | 35 | |||
83081 | 208704 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1334 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994279.13743 | 2106421.20132 | 37.7635024049329 | -122.462973275218 | (37.7635024049329, -122.462973275218) | 1 | 5 | 11 | 56 | 12 | |||
83090 | 45374 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1883 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2001 12:00:00 AM | 2 | Permit Number 44198 | 5988441.8935 | 2102504.0344 | 37.7524089623352 | -122.482875097623 | (37.7524089623352, -122.482875097623) | 1 | 8 | 3 | 56 | 35 | ||
83198 | 183875 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1125 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989922.7003 | 2101049.4217 | 37.7485010287551 | -122.477647964487 | (37.7485010287551, -122.477647964487) | 1 | 8 | 3 | 29491 | 35 | |||
83285 | 208615 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 415 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993677.16095 | 2099463.86647 | 37.7443646591164 | -122.464550095205 | (37.7443646591164, -122.464550095205) | 1 | 8 | 4 | 29491 | 40 | |||
83341 | 218214 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Lenox Way | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5993560.88973 | 2098882.74324 | 37.7427623379227 | -122.464909938252 | (37.7427623379227, -122.464909938252) | 1 | 8 | 4 | 59 | 40 | |||
83626 | 208747 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991379.26886 | 2098358.0327 | 37.7411955876074 | -122.472415046045 | (37.7411955876074, -122.472415046045) | 1 | 8 | 4 | 29491 | 40 | |||
84467 | 50283 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2115 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 3 | Permit Number 49092 | 5987878.3634 | 2100889.6868 | 37.7479435907559 | -122.484705442192 | (37.7479435907559, -122.484705442192) | 1 | 8 | 3 | 29491 | 35 | |
84631 | 208634 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 479 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 6ft | 5993651.28903 | 2101848.22012 | 37.7509099969154 | -122.464812672964 | (37.7509099969154, -122.464812672964) | 1 | 8 | 4 | 29491 | 40 | |||
84892 | 208732 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1702 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5993125.39655 | 2103847.65479 | 37.7563695939957 | -122.466776572887 | (37.7563695939957, -122.466776572887) | 1 | 8 | 4 | 56 | 12 | |||
85401 | 208596 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1670 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5992806.5056 | 2104090.87671 | 37.7570190088464 | -122.467897089476 | (37.7570190088464, -122.467897089476) | 1 | 8 | 4 | 56 | 12 | |||
85801 | 50242 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1231 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 3 | Permit Number 46947 | 5985193.178 | 2106799.8183 | 37.7640144312015 | -122.494426160535 | (37.7640144312015, -122.494426160535) | 1 | 8 | 3 | 56 | 35 | |
86655 | 65910 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1362 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28919 | 5994287.66539231 | 2106244.80174478 | 37.7630185488397 | -122.462930981209 | (37.7630185488397, -122.462930981209) | 1 | 5 | 11 | 56 | 12 | ||
87936 | 208605 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2027 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993156.75563 | 2101672.1701 | 37.7503980839042 | -122.466510007557 | (37.7503980839042, -122.466510007557) | 1 | 8 | 4 | 29491 | 12 | |||
87967 | 67235 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1105 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2008 12:00:00 AM | 3x3 | Permit Number 51936 | 5990046.06018762 | 2101055.02579907 | 37.7485235741667 | -122.477221802211 | (37.7485235741667, -122.477221802211) | 1 | 8 | 3 | 29491 | 35 | ||
88769 | 96709 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2900 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2012 12:00:00 AM | Permit Number 767523 | 5987054 | 2098280 | 37.7407300421735 | -122.487364354837 | (37.7407300421735, -122.487364354837) | 1 | 8 | 3 | 29491 | 35 | |||
89071 | 208611 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2540 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991430.17122 | 2098100.81745 | 37.7404922862842 | -122.47222030055 | (37.7404922862842, -122.47222030055) | 1 | 8 | 4 | 29491 | 40 | |||
89085 | 33223 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 160 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37413 | 5994872.66422473 | 2099464.09347697 | 37.7444341277701 | -122.460416341032 | (37.7444341277701, -122.460416341032) | 1 | 8 | 4 | 59 | 40 | ||
89328 | 181766 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1244 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987411.7481 | 2106788.0143 | 37.7641116103372 | -122.486752013951 | (37.7641116103372, -122.486752013951) | 1 | 8 | 3 | 56 | 35 | |||
89951 | 50240 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1558 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 0 | Permit Number 46946 | 5985934.81682201 | 2104623.03543953 | 37.7580809645272 | -122.491700834076 | (37.7580809645272, -122.491700834076) | 1 | 8 | 3 | 56 | 35 | |
91492 | 208741 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 40 Lomita Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991378.25392 | 2104780.00584 | 37.7588285967782 | -122.472886726049 | (37.7588285967782, -122.472886726049) | 1 | 8 | 4 | 56 | 12 | |||
91656 | 208739 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 206 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994228.86048 | 2105333.02981 | 37.7605116725884 | -122.463068207657 | (37.7605116725884, -122.463068207657) | 1 | 5 | 11 | 56 | 12 | |||
91756 | 183516 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2554 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986784.5873 | 2097863.4448 | 37.7395705770672 | -122.488265265576 | (37.7395705770672, -122.488265265576) | 1 | 8 | 3 | 29491 | 35 | |||
91950 | 33155 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2426 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 4 | Permit Number 37378 | 5986136.7355 | 2098710.8978 | 37.7418596376641 | -122.490567558509 | (37.7418596376641, -122.490567558509) | 1 | 8 | 3 | 29491 | 35 | |
91976 | 208700 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 144 Eucalyptus Dr | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5990998.47136 | 2094705.01684 | 37.731143287718 | -122.473465306694 | (37.731143287718, -122.473465306694) | 1 | 8 | 4 | 64 | 40 | |||
92427 | 50230 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1261 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 2 | Permit Number 46939 | 5987058.0109 | 2106711.8338 | 37.7638818109371 | -122.487969874086 | (37.7638818109371, -122.487969874086) | 1 | 8 | 3 | 56 | 35 | |
92714 | 208736 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 650 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992795.36651 | 2105286.54391 | 37.7603013553566 | -122.468022581774 | (37.7603013553566, -122.468022581774) | 1 | 8 | 4 | 56 | 12 | |||
93255 | 50093 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 50 Lenox Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46821 | 5993554.13185114 | 2098881.72529902 | 37.7427591532642 | -122.464933230976 | (37.7427591532642, -122.464933230976) | 1 | 8 | 4 | 59 | 40 | ||
93847 | 181745 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1231 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5987361.5517 | 2106852.3838 | 37.7642854247256 | -122.486930353935 | (37.7642854247256, -122.486930353935) | 1 | 8 | 3 | 56 | 35 | |||
96397 | 91337 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2908 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52059 | 5986985.3281 | 2098282.9635 | 37.7407341741836 | -122.487602010786 | (37.7407341741836, -122.487602010786) | 1 | 8 | 3 | 29491 | 35 | |
96846 | 208775 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 255 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5994732.08941 | 2100350.86625 | 37.7468608956274 | -122.460966675475 | (37.7468608956274, -122.460966675475) | 1 | 8 | 4 | 29491 | 40 | |||
97165 | 181612 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1261 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987056.2393 | 2106698.2512 | 37.7638444135226 | -122.487975003369 | (37.7638444135226, -122.487975003369) | 1 | 8 | 3 | 56 | 35 | |||
97370 | 208731 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1704 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5993125.40332 | 2103828.19424 | 37.7563161607647 | -122.466775134879 | (37.7563161607647, -122.466775134879) | 1 | 8 | 4 | 56 | 12 | |||
97763 | 208598 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1770 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993759.45096 | 2103456.1251 | 37.7553311270571 | -122.464555380548 | (37.7553311270571, -122.464555380548) | 1 | 8 | 4 | 56 | 12 | |||
99369 | 35071 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1636 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38625 | 5992804.10643985 | 2104322.53811306 | 37.7576549521482 | -122.467922236143 | (37.7576549521482, -122.467922236143) | 1 | 8 | 4 | 56 | 12 | ||
100150 | 107699 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 2401 MORAGA ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5986802.4 | 2103641.7 | 37.7554371523715 | -122.488628271884 | (37.7554371523715, -122.488628271884) | 1 | 8 | 3 | 56 | 35 | ||||
101393 | 208657 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 111 Edgehill Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994735.73129 | 2098953.68457 | 37.7430247942726 | -122.460852839282 | (37.7430247942726, -122.460852839282) | 1 | 8 | 4 | 59 | 40 | |||
102969 | 208588 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1606 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993723.8652 | 2104532.06576 | 37.7582833306166 | -122.464756575058 | (37.7582833306166, -122.464756575058) | 1 | 8 | 4 | 56 | 12 | |||
103699 | 208724 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1766 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993141.51449 | 2103447.34491 | 37.7552713769972 | -122.466691734433 | (37.7552713769972, -122.466691734433) | 1 | 8 | 4 | 56 | 12 |
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) );