Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137755 | 137755 | 183353 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3542 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982133.0347 | 2100158.2902 | 37.7455991034071 | -122.504518023708 | (37.7455991034071, -122.504518023708) | |||
138688 | 138688 | 15075 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 42 Minerva St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5996338.306623099 | 2089041.3064001 | 37.7158998615697 | -122.454595656346 | (37.7158998615697, -122.454595656346) | |||
154502 | 154502 | 184532 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 4041 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981429.119 | 2102119.1438 | 37.7509416273735 | -122.507097450181 | (37.7509416273735, -122.507097450181) | |||
157211 | 157211 | 183355 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3546 Rivera St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5982088.9451 | 2100155.7156 | 37.74558944081421 | -122.504670285508 | (37.7455894408142, -122.504670285508) | |||
159623 | 159623 | 210100 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 700 Junipero Serra Blvd | 125 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991216.87042 | 2091758.40738 | 37.7230652785221 | -122.472495529943 | (37.7230652785221, -122.472495529943) | |||
178579 | 178579 | 46391 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2474 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 6 | Permit Number 44624 | 5982733.735 | 2098287.5322 | 37.7404978321239 | -122.502302505611 | (37.7404978321239, -122.502302505611) | |
182701 | 182701 | 210097 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Junipero Serra Blvd | 46 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991383.70914 | 2094347.6763 | 37.7301844215576 | -122.47210744821699 | (37.7301844215576, -122.472107448217) | |||
531 | 531 | 27691 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1765 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 7 | 3X3 | 6001581.2067 | 2112155.8038 | 37.779666096456 | -122.438128618136 | (37.779666096456, -122.438128618136) | ||
27292 | 27292 | 250990 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.57195 | 2112909.00953 | 37.7805965385427 | -122.50619104959299 | (37.7805965385427, -122.506191049593) | |||
31021 | 31021 | 40202 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 409 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 7 | Permit Number 41384 | 5982801.49084 | 2112996.87637 | 37.7808894968635 | -122.503157008013 | (37.7808894968635, -122.503157008013) | |
34976 | 34976 | 210093 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5996144.00036 | 2089001.40747 | 37.715779161942 | -122.45526438373899 | (37.715779161942, -122.455264383739) | |||
42850 | 42850 | 43626 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2222 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 7 | Permit Number 43275 | 5985464.7649 | 2100074.5033 | 37.7455644571804 | -122.49299140272 | (37.7455644571804, -122.49299140272) | |
53256 | 53256 | 47907 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 746 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2002 12:00:00 AM | 7 | Permit Number 45646 | 6000056.4472 | 2111499.7732 | 37.7777779701242 | -122.44335627129999 | (37.7777779701242, -122.4433562713) | |
60700 | 60700 | 183354 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3544 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5982117.2654 | 2100157.6466 | 37.7455964086946 | -122.504572502943 | (37.7455964086946, -122.504572502943) | |||
71166 | 71166 | 232033 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 517 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003277.43124 | 2096153.4098099999 | 37.7358236645184 | -122.431118151596 | (37.7358236645184, -122.431118151596) | |||
149060 | 149060 | 49454 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 277@ BLANKEN Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2003 12:00:00 AM | 7 | Permit Number 46388 | 6012179.13947 | 2087360.9312099998 | 37.71218172628829 | -122.39972407980801 | (37.7121817262883, -122.399724079808) | |
150340 | 150340 | 250991 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.93947 | 2112926.15087 | 37.7806436252297 | -122.506191049582 | (37.7806436252297, -122.506191049582) | |||
18168 | 18168 | 28136 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 412 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4X4 | 6006951.93492 | 2097890.14157 | 37.7407998823106 | -122.41853703365 | (37.7407998823106, -122.41853703365) | |||
30475 | 30475 | 43625 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2218 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 8 | Permit Number 43274 | 5985464.7649 | 2100091.9996 | 37.7456124972844 | -122.49299269129699 | (37.7456124972844, -122.492992691297) | |
30918 | 30918 | 117725 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 849 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5983504.07439 | 2113100.0545900003 | 37.7812140668155 | -122.500734098102 | (37.7812140668155, -122.500734098102) | |||
48730 | 48730 | 38372 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4245 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 8 | Permit Number 41159 | 5981126.11155374 | 2104152.1959616 | 37.7565059606627 | -122.508296152224 | (37.7565059606627, -122.508296152224) | |
127824 | 127824 | 24841 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 200X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 8 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
153451 | 153451 | 139625 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 1761 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001622.1557 | 2112159.8649 | 37.779679575976 | -122.437987249049 | (37.779679575976, -122.437987249049) | |||
157813 | 157813 | 98357 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4201 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5981815.8 | 2104809.3 | 37.758350801359704 | -122.50595972261401 | (37.7583508013597, -122.505959722614) | |||
51621 | 51621 | 46380 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2491 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 9 | Permit Number 44617 | 5983004.0718 | 2098197.5632 | 37.7402666818538 | -122.50136114804899 | (37.7402666818538, -122.501361148049) | |
58602 | 58602 | 210092 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 261 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995627.09016 | 2091704.91878 | 37.72317269265079 | -122.457246512943 | (37.7231726926508, -122.457246512943) | |||
73512 | 73512 | 122029 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 791 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990357.66226 | 2109998.66338 | 37.773098484036495 | -122.47679765911 | (37.7730984840365, -122.47679765911) | |||
133721 | 133721 | 119151 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 751 47th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5981332.09183 | 2110596.93925 | 37.774213497724396 | -122.50806211670799 | (37.7742134977244, -122.508062116708) | |||
37360 | 37360 | 34824 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3607 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 10 | Permit Number 38713 | 5984365.3802 | 2113132.09169 | 37.7813525599643 | -122.49775681803001 | (37.7813525599643, -122.49775681803) | |
57844 | 57844 | 72845 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 2625 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 10 | 5989234.0157 | 2097465.6374 | 37.7386209048407 | -122.479767197253 | (37.7386209048407, -122.479767197253) | ||
169128 | 169128 | 210094 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5996151.37066 | 2089000.9708099999 | 37.715778385846896 | -122.45523887719801 | (37.7157783858469, -122.455238877198) | |||
26121 | 26121 | 46393 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2483 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 11 | Permit Number 44625 | 5982691.0939 | 2098244.5526 | 37.740377316448495 | -122.502446759303 | (37.7403773164485, -122.502446759303) | |
49522 | 49522 | 193547 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 65 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6012516.839980001 | 2102871.66546 | 37.7547897972265 | -122.39964523714501 | (37.7547897972265, -122.399645237145) | ||||
179294 | 179294 | 218220 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 300 Claremont Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 5993448.22771 | 2098043.70132 | 37.7404520434185 | -122.46523855682301 | (37.7404520434185, -122.465238556823) | |||
20692 | 20692 | 15069 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1X Minerva St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 11 | 5995941.11063 | 2089006.6713400001 | 37.715781972331 | -122.455966040227 | (37.715781972331, -122.455966040227) | |||
30459 | 30459 | 34825 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 3607 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 12 | Permit Number 38713 | 5984347.22188 | 2113130.44202 | 37.7813469659664 | -122.49781951413901 | (37.7813469659664, -122.497819514139) | |
40578 | 40578 | 210099 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 700 Junipero Serra Blvd | 70 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991230.12075 | 2092291.98484 | 37.72453111681111 | -122.47248860785601 | (37.7245311168111, -122.472488607856) | |||
141651 | 141651 | 24770 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 201X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1998 12:00:00 AM | 12 | 5982138.31917 | 2112600.73174 | 37.779762797108205 | -122.505421833339 | (37.7797627971082, -122.505421833339) | |||
40612 | 40612 | 193546 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012511.31155 | 2102952.5131599996 | 37.7550114792069 | -122.39967003234699 | (37.7550114792069, -122.399670032347) | ||||
63329 | 63329 | 193545 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6012471.27665 | 2103561.30428 | 37.7566808547541 | -122.399851232248 | (37.7566808547541, -122.399851232248) | ||||
159177 | 159177 | 232034 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 5 Clarendon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 2ft | 5998231.75186 | 2104660.34285 | 37.758894411852204 | -122.449175639859 | (37.7588944118522, -122.449175639859) | |||
75400 | 75400 | 210098 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 400 Junipero Serra Blvd | 18 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5991367.910130001 | 2094058.78209 | 37.72939027613779 | -122.47214101722099 | (37.7293902761378, -122.472141017221) | |||
128164 | 128164 | 27505 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1761 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 6001633.12831 | 2112159.85861 | 37.779680182688104 | -122.43794928965201 | (37.7796801826881, -122.437949289652) | |||
27255 | 27255 | 193544 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 900x Carolina St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6012476.687390001 | 2103624.0786200003 | 37.75685352098429 | -122.39983692765499 | (37.7568535209843, -122.399836927655) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");