trees
56 rows where Neighborhoods (old) = 40 and qSpecies_id = 143
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
832 | 211486 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300 Junipero Serra Blvd | 17 | : | Tree | Private 2 | 56 | Width 0ft | 5991389.83684 | 2094502.84602 | 37.7306108333036 | -122.47209757005 | (37.7306108333036, -122.47209757005) | 9 | 8 | 4 | 64 | 40 | |||
11068 | 211513 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 85 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994187.91707 | 2102046.55023 | 37.7514854856778 | -122.462971364138 | (37.7514854856778, -122.462971364138) | 1 | 8 | 4 | 29491 | 40 | |||
13536 | 217797 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 21 Sloat Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5991294.47802 | 2095928.89148 | 37.7345208760209 | -122.472531163782 | (37.7345208760209, -122.472531163782) | 1 | 8 | 4 | 64 | 40 | |||
24144 | 211491 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 20 | : | Tree | Private 2 | 15 | Width 0ft | 5991339.7288 | 2093695.49673 | 37.7283911545133 | -122.472211971033 | (37.7283911545133, -122.472211971033) | 9 | 8 | 4 | 64 | 40 | |||
25574 | 211465 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 24 Sotelo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5993950.36661 | 2101034.65922 | 37.7486934045725 | -122.463719400457 | (37.7486934045725, -122.463719400457) | 1 | 8 | 4 | 29491 | 40 | |||
34730 | 29621 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 900X Junipero Serra Blvd | 30 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991159.49774 | 2090848.6205 | 37.7205639077711 | -122.472627554023 | (37.7205639077711, -122.472627554023) | 9 | 8 | 4 | 64 | 40 | ||
38195 | 211488 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300 Junipero Serra Blvd | 31 | : | Tree | Private 2 | 3 | Width 0ft | 5991384.87644 | 2094432.52355 | 37.730417458384 | -122.472109594877 | (37.730417458384, -122.472109594877) | 9 | 8 | 4 | 64 | 40 | |||
42474 | 211510 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2147 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990673.7374 | 2100765.68933 | 37.7477655290612 | -122.475030208899 | (37.7477655290612, -122.475030208899) | 1 | 8 | 4 | 29491 | 40 | |||
44135 | 211511 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 340 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5992962.16125 | 2099691.47205 | 37.7449483622804 | -122.467038937503 | (37.7449483622804, -122.467038937503) | 1 | 8 | 4 | 29491 | 40 | |||
46172 | 211493 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 29 | : | Tree | Private 2 | 12 | Width 0ft | 5991335.51142 | 2093629.06085 | 37.7282084941176 | -122.472221709772 | (37.7282084941176, -122.472221709772) | 9 | 8 | 4 | 64 | 40 | |||
50202 | 211475 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 370 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997994.43141 | 2098177.85936 | 37.7410815301989 | -122.449529301835 | (37.7410815301989, -122.449529301835) | 9 | 7 | 4 | 59 | 40 | |||
51792 | 211507 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 900 Junipero Serra Blvd | 56 | : | Tree | Private 2 | 5 | Width 0ft | 5991137.4957 | 2090642.33863 | 37.7199962350219 | -122.472688574812 | (37.7199962350219, -122.472688574812) | 9 | 8 | 4 | 64 | 40 | |||
58054 | 211472 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 200x Terrace Dr | 22 | Median : Yard | Tree | DPW 1 | 7 | 5993829.81407 | 2096532.04591 | 37.7363234123842 | -122.463809497222 | (37.7363234123842, -122.463809497222) | 1 | 8 | 4 | 59 | 40 | ||||
61660 | 211464 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 28 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5993948.4771 | 2101040.96262 | 37.7487106032283 | -122.463726391756 | (37.7487106032283, -122.463726391756) | 1 | 8 | 4 | 29491 | 40 | |||
65719 | 211463 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 28 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5993946.4146 | 2101049.73072 | 37.7487345593556 | -122.463734160116 | (37.7487345593556, -122.463734160116) | 1 | 8 | 4 | 29491 | 40 | |||
70567 | 211466 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 5 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5995817.16924 | 2100181.82044 | 37.7464591163017 | -122.457202367915 | (37.7464591163017, -122.457202367915) | 1 | 5 | 4 | 59 | 40 | |||
73690 | 211514 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 85 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994201.21558 | 2102051.81606 | 37.7515007103061 | -122.462925758622 | (37.7515007103061, -122.462925758622) | 1 | 8 | 4 | 29491 | 40 | |||
75696 | 211468 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 100 Terrace Dr | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 5993742.38425 | 2096618.33581 | 37.7365553043905 | -122.464118038412 | (37.7365553043905, -122.464118038412) | 1 | 8 | 4 | 59 | 40 | ||||
75785 | 211497 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 69 | : | Tree | Private 2 | 4 | Width 0ft | 5991316.04145 | 2093239.93767 | 37.7271389322076 | -122.472260663898 | (37.7271389322076, -122.472260663898) | 9 | 8 | 4 | 64 | 40 | |||
79589 | 217798 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 21 Sloat Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5991302.74384 | 2095929.10897 | 37.7345219516306 | -122.472502602224 | (37.7345219516306, -122.472502602224) | 1 | 8 | 4 | 64 | 40 | |||
79785 | 211469 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 100 Terrace Dr | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5993761.69196 | 2096603.43461 | 37.7365155021795 | -122.464050202552 | (37.7365155021795, -122.464050202552) | 1 | 8 | 4 | 59 | 40 | ||||
82720 | 211498 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 73 | : | Tree | Private 2 | 3 | Width 0ft | 5991315.293 | 2093223.52213 | 37.7270938159129 | -122.472262055146 | (37.7270938159129, -122.472262055146) | 9 | 8 | 4 | 64 | 40 | |||
90287 | 211494 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 39 | : | Tree | Private 2 | 5 | Width 0ft | 5991332.79876 | 2093538.54779 | 37.7279598108755 | -122.472224492292 | (37.7279598108755, -122.472224492292) | 9 | 8 | 4 | 64 | 40 | |||
90859 | 211512 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 160 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994897.8322 | 2099478.1104 | 37.7444740625255 | -122.460330331374 | (37.7444740625255, -122.460330331374) | 1 | 8 | 4 | 59 | 40 | |||
92255 | 211487 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300 Junipero Serra Blvd | 26 | : | Tree | Private 2 | 7 | Width 0ft | 5991384.26477 | 2094458.5137 | 37.7304887854207 | -122.472113603187 | (37.7304887854207, -122.472113603187) | 9 | 8 | 4 | 64 | 40 | |||
92297 | 211502 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 700 Junipero Serra Blvd | 137 | : | Tree | Private 2 | 6 | Width 0ft | 5991202.79588 | 2091613.15012 | 37.7226656234049 | -122.472533597355 | (37.7226656234049, -122.472533597355) | 9 | 8 | 4 | 64 | 40 | |||
94704 | 211490 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 6 | : | Tree | Private 2 | 6 | Width 0ft | 5991347.62863 | 2093783.89597 | 37.7286343339091 | -122.472191102257 | (37.7286343339091, -122.472191102257) | 9 | 8 | 4 | 64 | 40 | |||
95989 | 211508 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 900 Junipero Serra Blvd | 91 | : | Tree | Private 2 | 8 | Width 0ft | 5991145.77584 | 2090549.03297 | 37.7197405199769 | -122.472653154122 | (37.7197405199769, -122.472653154122) | 9 | 8 | 4 | 64 | 40 | |||
96616 | 211460 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 268 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 6ft | 5994425.86849 | 2100644.95899 | 37.7476507746631 | -122.462046874564 | (37.7476507746631, -122.462046874564) | 1 | 8 | 4 | 29491 | 40 | |||
101412 | 211489 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300 Junipero Serra Blvd | 42 | : | Tree | Private 2 | 11 | Width 0ft | 5991385.31343 | 2094370.74598 | 37.730247857955 | -122.472103582925 | (37.730247857955, -122.472103582925) | 9 | 8 | 4 | 64 | 40 | |||
117148 | 211506 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 900 Junipero Serra Blvd | 43 | : | Tree | Private 2 | 3 | Width 0ft | 5991151.65625 | 2090702.0862 | 37.7201611068169 | -122.472643981031 | (37.7201611068169, -122.472643981031) | 9 | 8 | 4 | 64 | 40 | |||
118143 | 211495 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 65 | : | Tree | Private 2 | 3 | Width 0ft | 5991310.32822 | 2093255.28671 | 37.7271807461943 | -122.472281532691 | (37.7271807461943, -122.472281532691) | 9 | 8 | 4 | 64 | 40 | |||
122732 | 211500 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 75 | : | Tree | Private 2 | 3 | Width 0ft | 5991311.90596 | 2093215.57848 | 37.7270718086089 | -122.472273185172 | (37.7270718086089, -122.472273185172) | 9 | 8 | 4 | 64 | 40 | |||
124954 | 211461 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 268 Pacheco St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 46 | Width 6ft | 5994405.70319 | 2100667.69172 | 37.7477120319803 | -122.462118252857 | (37.7477120319803, -122.462118252857) | 1 | 8 | 4 | 29491 | 40 | |||
128315 | 211470 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 100 Terrace Dr | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5993769.41475 | 2096594.44879 | 37.7364912744353 | -122.464022849698 | (37.7364912744353, -122.464022849698) | 1 | 8 | 4 | 59 | 40 | ||||
131923 | 211477 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 100x Idora Ave | 10 | Median : Yard | Tree | DPW 1 | 37 | Width 9ft | 5995466.33774 | 2099382.46662 | 37.7442441346666 | -122.4583576469 | (37.7442441346666, -122.4583576469) | 1 | 8 | 4 | 59 | 40 | |||
134363 | 114801 | Permitted Site 7 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 2147 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2015 12:00:00 AM | Permit Number 776071 | 5990655.8 | 2100775.7 | 37.7477919761741 | -122.475092965537 | (37.7477919761741, -122.475092965537) | 1 | 8 | 4 | 29491 | 40 | |||
136908 | 211515 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 42 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6001141.02777 | 2095226.08896 | 37.7331561620146 | -122.438438104253 | (37.7331561620146, -122.438438104253) | 9 | 7 | 5 | 63 | 40 | |||
137654 | 211462 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 20 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 5993868.16001 | 2100935.65838 | 37.7484168360728 | -122.463996482471 | (37.7484168360728, -122.463996482471) | 1 | 8 | 4 | 29491 | 40 | |||
138327 | 211509 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 900 Junipero Serra Blvd | 95 | : | Tree | Private 2 | 12 | Width 0ft | 5991136.45301 | 2090544.4672 | 37.719727443836 | -122.472685046799 | (37.719727443836, -122.472685046799) | 9 | 8 | 4 | 64 | 40 | |||
138960 | 211459 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 268 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5994445.84522 | 2100625.23796 | 37.7475977758138 | -122.46197636681 | (37.7475977758138, -122.46197636681) | 1 | 8 | 4 | 29491 | 40 | |||
139319 | 211501 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 76 | : | Tree | Private 2 | 6 | Width 0ft | 5991307.02805 | 2093213.27688 | 37.7270652066824 | -122.472289880167 | (37.7270652066824, -122.472289880167) | 9 | 8 | 4 | 64 | 40 | |||
142988 | 211496 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 66 | : | Tree | Private 2 | 3 | Width 0ft | 5991314.70255 | 2093252.79009 | 37.7271741442599 | -122.472266228903 | (37.7271741442599, -122.472266228903) | 9 | 8 | 4 | 64 | 40 | |||
144440 | 211504 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 700 Junipero Serra Blvd | 140 | : | Tree | Private 2 | 19 | Width 0ft | 5991207.79539 | 2091589.11785 | 37.7225999261211 | -122.472514564093 | (37.7225999261211, -122.472514564093) | 9 | 8 | 4 | 64 | 40 | |||
152850 | 83413 | Permitted Site 7 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1315 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50776 | 5993906.0735172 | 2094457.35212766 | 37.7306312095738 | -122.463395327953 | (37.7306312095738, -122.463395327953) | 9 | 8 | 4 | 59 | 40 | ||
153754 | 211503 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 700 Junipero Serra Blvd | 139 | : | Tree | Private 2 | 4 | Width 0ft | 5991198.47785 | 2091598.28701 | 37.7226245630474 | -122.472547440608 | (37.7226245630474, -122.472547440608) | 9 | 8 | 4 | 64 | 40 | |||
160659 | 211467 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 5 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5995826.04382 | 2100197.09565 | 37.7465015679068 | -122.4571727856 | (37.7465015679068, -122.4571727856) | 1 | 5 | 4 | 59 | 40 | |||
164438 | 211499 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 74 | : | Tree | Private 2 | 3 | Width 0ft | 5991307.59918 | 2093221.27988 | 37.7270872139785 | -122.47228848894 | (37.7270872139785, -122.47228848894) | 9 | 8 | 4 | 64 | 40 | |||
168386 | 29959 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300x Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991398.70735 | 2094566.15878 | 37.7307851875836 | -122.472071516681 | (37.7307851875836, -122.472071516681) | 9 | 8 | 4 | 64 | 40 | ||
171904 | 211492 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 500 Junipero Serra Blvd | 28 | : | Tree | Private 2 | 5 | Width 0ft | 5991336.46792 | 2093636.25426 | 37.7282283007794 | -122.472218927287 | (37.7282283007794, -122.472218927287) | 9 | 8 | 4 | 64 | 40 | |||
173515 | 211505 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 700 Junipero Serra Blvd | 141 | : | Tree | Private 2 | 15 | Width 0ft | 5991206.53214 | 2091576.68287 | 37.7225657096252 | -122.472518024694 | (37.7225657096252, -122.472518024694) | 9 | 8 | 4 | 64 | 40 | |||
176564 | 211471 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 200x Terrace Dr | 16 | Median : Yard | Tree | DPW 1 | 14 | 5993818.60983 | 2096510.85227 | 37.736264574251 | -122.463846696775 | (37.736264574251, -122.463846696775) | 1 | 8 | 4 | 59 | 40 | ||||
185211 | 211474 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1315 Monterey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 5993912.04878 | 2094465.35794 | 37.730653535825 | -122.463375251462 | (37.730653535825, -122.463375251462) | 9 | 8 | 4 | 59 | 40 | |||
186019 | 211473 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 1315 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 5993901.96581 | 2094475.82879 | 37.7306817052907 | -122.463410869124 | (37.7306817052907, -122.463410869124) | 9 | 8 | 4 | 59 | 40 | |||
186660 | 29958 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 300X Junipero Serra Blvd | 4 | Median : Cutout | Tree | DPW 1 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991400.2554 | 2094584.59866 | 37.7308359084501 | -122.472067508425 | (37.7308359084501, -122.472067508425) | 9 | 8 | 4 | 64 | 40 | ||
187980 | 211476 | DPW Maintained 1 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 374 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998007.0333 | 2098161.22384 | 37.7410365739886 | -122.4494845309 | (37.7410365739886, -122.4494845309) | 9 | 7 | 4 | 59 | 40 |
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) );