Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21627 | 21627 | 10139 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 905 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 12:00:00 AM | 1 | 2X2 | 6005721.36321 | 2103691.7160799997 | 37.7566603214356 | -122.42320418503999 | (37.7566603214356, -122.42320418504) | ||
29331 | 29331 | 219232 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 393 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994163.921 | 2092422.7016599998 | 37.72505940734629 | -122.46235640053101 | (37.7250594073463, -122.462356400531) | |||
35605 | 35605 | 49762 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 123@ GIRARD Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 1 | Permit Number 46556 | 6011554.1535 | 2090217.48516 | 37.7199903867389 | -122.402084923384 | (37.7199903867389, -122.402084923384) | |
40415 | 40415 | 226761 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 69 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005532.060269999 | 2099607.16908 | 37.745434412567896 | -122.423568476998 | (37.7454344125679, -122.423568476998) | |||
40786 | 40786 | 229741 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 714 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6004954.861330001 | 2104148.63623 | 37.757871629989296 | -122.42588755157101 | (37.7578716299893, -122.425887551571) | |||
45434 | 45434 | 176587 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 125 Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011540.71743 | 2090213.76704 | 37.719979427594104 | -122.402131106273 | (37.7199794275941, -122.402131106273) | |||
47184 | 47184 | 229792 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1347 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006987.3466 | 2107613.99379 | 37.7675013456445 | -122.419104149736 | (37.7675013456445, -122.419104149736) | |||
52880 | 52880 | 176585 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Seneca Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5999821.59853 | 2090369.86807 | 37.719746961831 | -122.442651149242 | (37.719746961831, -122.442651149242) | |||
61921 | 61921 | 228526 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009242.70378 | 2106296.2843400002 | 37.7640099687976 | -122.41121004561701 | (37.7640099687976, -122.411210045617) | |||
71654 | 71654 | 229780 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6011438.150669999 | 2102669.0861400003 | 37.7541733704045 | -122.40336141212099 | (37.7541733704045, -122.403361412121) | |||
71727 | 71727 | 176584 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 263 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5997986.0041 | 2088216.93337 | 37.7137306897928 | -122.44884112532301 | (37.7137306897928, -122.448841125323) | |||
72817 | 72817 | 190701 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199 Texas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013753.34046 | 2106269.9769900003 | 37.7641896695377 | -122.39560712917101 | (37.7641896695377, -122.395607129171) | |||
97228 | 97228 | 34748 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 2752 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 1 | 5x12 | Permit Number 38396 | 6008918.26554882 | 2102430.84513518 | 37.7533781509064 | -122.412058993069 | (37.7533781509064, -122.412058993069) |
131666 | 131666 | 190744 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2086 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012709.58294 | 2096557.7365 | 37.737463838180496 | -122.398535643704 | (37.7374638381805, -122.398535643704) | ||||
133111 | 133111 | 226319 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1363 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009300.5119199995 | 2101248.8429900003 | 37.7501540762619 | -122.41065363417101 | (37.7501540762619, -122.410653634171) | |||
135367 | 135367 | 226326 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 739 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007955.30705 | 2103442.0816599997 | 37.7561007003072 | -122.415460702047 | (37.7561007003072, -122.415460702047) | |||
148346 | 148346 | 245473 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2889 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6009585.3359 | 2102170.0295 | 37.752699414397604 | -122.409733705951 | (37.7526994143976, -122.409733705951) | |||
151613 | 151613 | 226366 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1220 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001939.37968 | 2100462.1573799998 | 37.7475785645179 | -122.436052541893 | (37.7475785645179, -122.436052541893) | |||
152981 | 152981 | 226310 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 110 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010345.87417 | 2099884.35237 | 37.7464660383936 | -122.406942531387 | (37.7464660383936, -122.406942531387) | |||
153899 | 153899 | 190705 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2207 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012167.672590001 | 2101868.22715 | 37.7520151045386 | -122.40078226978301 | (37.7520151045386, -122.400782269783) | |||
153976 | 153976 | 226362 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 7 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005992.12876 | 2102270.13031 | 37.7527722527625 | -122.42216678559299 | (37.7527722527625, -122.422166785593) | |||
155165 | 155165 | 219233 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 387 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994164.56547 | 2092392.43636 | 37.724976343277795 | -122.462351978558 | (37.7249763432778, -122.462351978558) | |||
158392 | 158392 | 226775 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4065 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003443.878880001 | 2101243.2515 | 37.7498086241662 | -122.43090581267599 | (37.7498086241662, -122.430905812676) | |||
160383 | 160383 | 226365 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1214 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001939.894830001 | 2100487.05511 | 37.7476469570616 | -122.436052541887 | (37.7476469570616, -122.436052541887) | |||
168226 | 168226 | 226409 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 340 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007041.57099 | 2096614.1671900002 | 37.7373013855609 | -122.41813666630101 | (37.7373013855609, -122.418136666301) | |||
169916 | 169916 | 106484 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 758 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 1 | 3x3 | Permit Number 771079 | 6013015.32424 | 2103511.36307 | 37.756574042268895 | -122.39796620198601 | (37.7565740422689, -122.397966201986) | |
171644 | 171644 | 226410 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 340 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007045.3382 | 2096649.7231400001 | 37.7373992263821 | -122.41812616129499 | (37.7373992263821, -122.418126161295) | |||
174234 | 174234 | 228525 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009242.66431 | 2106282.23281 | 37.763971384304206 | -122.411209189472 | (37.7639713843042, -122.411209189472) | |||
174782 | 174782 | 229840 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3732 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005421.91572 | 2104323.47522 | 37.7583780804987 | -122.42428471508002 | (37.7583780804987, -122.42428471508) | |||
175495 | 175495 | 229865 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 539 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004844.26448 | 2110392.80621 | 37.7750103735616 | -122.426714698547 | (37.7750103735616, -122.426714698547) | |||
179213 | 179213 | 228527 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 405 Florida St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009241.97976 | 2106321.44557 | 37.7640790151609 | -122.4112143273 | (37.7640790151609, -122.4112143273) | |||
180912 | 180912 | 123149 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 530 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992851.14917 | 2111838.68412 | 37.77829500806129 | -122.468306331193 | (37.7782950080613, -122.468306331193) | |||
181213 | 181213 | 101797 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 600X Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6x6 | 6012355.97365 | 2105123.66121 | 37.7609643139807 | -122.400359728744 | (37.7609643139807, -122.400359728744) | |||
182379 | 182379 | 80400 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 847 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51000 | 6000427.8652 | 2111924.6617 | 37.778965778909296 | -122.442101918526 | (37.7789657789093, -122.442101918526) | |
188041 | 188041 | 226307 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 303 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007092.99842 | 2096727.1490900002 | 37.7376145033994 | -122.417966864376 | (37.7376145033994, -122.417966864376) | |||
188188 | 188188 | 229822 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 956 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6009932.67033 | 2103635.88774 | 37.7567437920002 | -122.40863595569701 | (37.7567437920002, -122.408635955697) |
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");